Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors and Report DE
Message
From
15/01/1999 17:47:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Cursors and Report DE
Miscellaneous
Thread ID:
00176760
Message ID:
00176760
Views:
78
For completeness I've included some discussion that occurred offline...

Hi, David.

The expression builder will only show you fields from cursors in the
report's DE. I always use the DE, so I checked with another MVP who
doesn't ship reports with tables in the DE. She makes a temporary table
from a SQL select statement that "creates" her report data. Then adds it
to the DE for purposes of designing the report. Finally, she removes the
table from the DE before shipping.

Please post these follow ups to the UT. I seem to be having better luck
today with my connection, but I'm just being lazy askinng you to do it ;-)

Best regards,
N

On Thursday, January 14, 1999 5:09 PM, David Bower
[SMTP:Dave_Bower@msn.com.au] wrote:
> Hi Nancy,
> Thanks for taking the trouble to reply this way.
> I think the problem I'm having is more fundamental.
>
> Could you try this and let me know what happens?
> Open VFP6. Open any data file ( a free table).
> MODIFY REPORT TEMP
> Add a field to the report and click on the '...' button next to
expression.
> I see *no* fields. I can't choose any tables (there's no option) If I
choose
> 'options...' all the field options are disabled.
> Something weird here.
>
> You're right about Lisa. She is *the* guru. She used to come out here
every
> year to run a course which I always attended. Mind like a steel trap!
>
> BTW, I've never tried a newsgroup on the web before. Is it easy?
>
> Regards
> David
>
>
> > -----Original Message-----
> > From: N. Folsom [mailto:nfolsom@earthlink.net]
> > Sent: Thursday, 14 January 1999 4:09
> > To: 'dave_bower@msn.com.au'
> > Subject: Thread #174535 Message #174870
> >
> >
> > Hi, David.
> >
> > I'm sorry to take so long to answer and to take this
> > form...But for the
> > past 2 days, everytime I hit "reply" I get a lost connection.
> > (I'm not
> > having much luck with the UT these days :-P)
> >
> > Anyway, I don't have any experience modifying reports during
> > runtime (I
> > used FoxFire!). But if I had to guess, I'd have to say that
> > if the report
> > is using a default data session and the tables are open prior
> > to issuing
> > the MODI REPORT, then, yes, it *should* work. Fat lot of
> > help that is, eh?
> >
> > The true goddess of reporting is the Great Lisa
> > Nichols-Slater. She hangs
> > out on the microsoft.public.fox newsgroups if you might like
> > to try posting
> > there. The server is: msnews.microsoft.com
> >
> > If, of course you haven't already solved your problem!
> >
> > I'll have to leave it to you to post the follow up to the UT.
> > Again, my
> > apologies!
> >
> > Regards,
> > Nancy
> >
Reply
Map
View

Click here to load this message in the networking platform