Is there any way to find out the width of a closed report programatically?

Is there any way to find out the width of a closed report programatically?

Post by ryanhokans » Tue, 12 Sep 2006 16:23:39


I was just trying to get a list of all my reports along with their
widths.

I can't use the "Reports" collection because it only works on open
reports. So I tried looking into the "AllReports" collection and it
doesn't seem any more useful... only allows you to find out the name of
each report.
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Bob Quinta » Tue, 12 Sep 2006 18:33:41

" XXXX@XXXXX.COM " < XXXX@XXXXX.COM > wrote in


Open the report, get the width and close it again.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.yqcomputer.com/
Warning: Do not use Ultimate-Anonymity
They are worthless spammers that are running a scam.

 
 
 

Is there any way to find out the width of a closed report programatically?

Post by ryanhokans » Thu, 14 Sep 2006 11:49:47


Thanks, Bob!

But too late, actually. I'd already gotten answer from another "guru"
elsewhere...

Turns out to get the width of a closed report in Access (which is what
I was trying to do), all I have to do is open the report. Then I can
get the width! All I have to do at that point is close the report and
pretend it was closed the whole time. I make a fool out of myself this
way, but, since I am following "guru" advice I feel great about it...
which makes me doubly foolish; but still feeling fine!

Genius, huh?

It gets even better, though! If you'll recall (or maybe you won't?),
I'm trying to get the widths of all my reports. And there are a lot of
them - thus the idea to do it without opening each one -- so doing it
this way takes a long time, but with each reiteration I feel more and
more euphoric.

Supercalifragilistic!

Huh?
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Terry Kref » Thu, 14 Sep 2006 16:59:31


Well, you know what, I was going to post some code to help you in this task
but I don't know if I could stand the dazzling wit and sarcasm you throw at
people who try to help you, so I won't.

Don't despair though, there are millions of people out there who's goodwill
you can take advantage of and then abuse them for their trouble.

--

Terry Kreft
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by pietlinde » Fri, 15 Sep 2006 10:40:20


Wow, Terry, you're in rare form today. That MLH post was pure dead
brilliant!
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Ryan » Fri, 15 Sep 2006 13:12:20


Wow! Toady's got a toady!

There was no attempt "help" in the first reply to my request for info
on how to get the width of a *closed* report. Just a smart-assed "open
the report"... And I wouldn't have bothered responding, but I thought
I'd check to see if the respondent was just a good-natured doofus.
Guess what? The *very first* thread I came across in which Bob Q had
participated prior to coming in here and giving his smart-assed
response? Bob Q was *joining in* in attacking the first responder of
*that* thread for apparently not reading the question asked.

Too much.

As is Terry's claim that Bob was "trying to help" with his "open the
report, get the width, close the report."

As is Terry's other claim, I suspect.

Thanks for all your help, gurus. Do you guys have a paypal account or
something so that I can send some money?
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Wayne Gill » Fri, 15 Sep 2006 14:04:29


Don't send money, just don't come back.


Wayne Gillespie
Gosford NSW Australia
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Terry Kref » Fri, 15 Sep 2006 17:53:18


Against my better judgement I'm going to try and educate you.

Consider:-
1) Just because you think of a way you want to do something doesn't mean
that you can actually do it that way.
2) With respect to getting a reports width; Bob Quintal's answer was
correct.

Now we can turn this into a fairly simple logical exercise by reiterating
the original statements
1) (paraphrased) "I want to be able to get the widths of all reports
without opening them"
2) "Open the report, get the width and close it again"

Can you see that by combining the information we have at this point we can
come to the conclusion that you can't do what you want?

By expanding on what Bob says you can see that what you have to do is
iterate through the AllReports collection to get the name of each report,
you can then use that to open each report and get the report width and close
the report again.

BTW despite your libellous allegation the people in this NG (with one
notable exception who shall remain nameless) respond for free, in their own
time with out expecting any recompense.

You on the other hand appear arrogant and really quite incapable of taking
advice in the manner in which it was meant.

Consider; being a smart-arse doesn't mean your smart.

--

Terry Kreft
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Lyle Fairf » Fri, 15 Sep 2006 18:52:41

"Ryan H" < XXXX@XXXXX.COM > wrote in




Well, you know what, I was going to post some code to help you in this task
but I don't know if I could stand the dazzling wit and sarcasm you throw at
people who try to help you, so I won't.

Don't despair though, there are millions of people out there who's goodwill
you can take advantage of and then abuse them for their trouble.

--
Lyle Fairfield
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Terry Kref » Fri, 15 Sep 2006 21:56:45

LOL!

Lyle, if you weren't in this world I'd have to invent you!

--

Terry Kreft






task
at
goodwill
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Lyle Fairf » Fri, 15 Sep 2006 22:41:10


I've been using your stuff since back in the last century, Terry. Why
stop now?
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Bob Quinta » Sat, 16 Sep 2006 06:01:15

"Ryan H" < XXXX@XXXXX.COM > wrote in




First of all it wasn't smartassed! What you failed to read in my
message is that ther is NO WAY you can get a VALID width or
height value from a closed report.

All the original idiot poster said is I can't use the reports
collection because it only works on open reports.

There are people who get their head so far up their rectum in
their concept of how do do something that they overlook the
obvious alternative solution. .

And I wouldn't have bothered
Well you obviously didn't read far enough. I suppose you've
posted here before under such aliases as PCDatasheet or Steve?
You certainly come off as dense as he.


What you failed to read in my message is that there is NO WAY
you can get a VALID width or height value from a closed report.


You certainly are.



No. Just go away. Don't go away mad, just go away.




--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.yqcomputer.com/
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Lyle Fairf » Sat, 16 Sep 2006 10:25:10


Well ...

If one saves the report as text and reads the text (all with code, of
course), one can extract a "width" in (I believe) pixels. And one could
convert this number of pixels to chains, centimeters, nautical miles,
inches or whatever as well.

This may sound expensive in terms of time, but it should take only a
second or two for each report.

Now is the width so obtained "the" width, or a Valid Width, or any use
at all? I have no idea. It certainly is of no value for me, which is
why I haven't got a code sample to post.

And some might argue that a report saved as text was opened. I wouldn't
agree but I can't think of why that matters.

My inclination on reading the OP was to reply, "Sure, there's a way.
Write down zero (0). That is the width of every closed report." But
something happened as I was about to send, and the post was cancelled.
Maybe that was a good thing.

None of the people who live around here are buried in the local
cemetery. Why? It's because they're not dead, yet. The closed report is
like that.
(Grammar apologies)

I think your original answer was complete and sufficient.
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Randy Harr » Sat, 16 Sep 2006 10:53:32

I think most everyone here, with the exception of the OP, understood
the answer. He was so anxious to get into a pissing contest with
everyone here that was able to help him that he couldn't be bothered
to ask for further explanation.
 
 
 

Is there any way to find out the width of a closed report programatically?

Post by Terry Kref » Sat, 16 Sep 2006 16:07:30

Lateral Lyle,
Yes, it's pixels.

Thing is I'm desperately trying not to code it now.

--

Terry Kreft





<SNIP>