Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-band report
Message
 
 
To
08/04/2011 18:30:15
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01506740
Message ID:
01506742
Views:
40
>>Hi everybody,
>>
>>I have created a simple (as I think) 2 detail bands report (see attached layout). In the code before running this report I have
>>
>>select csrCloseouts
>>set relation to Closeout into Skims
>>set relation to Closeout into ServerBanks additive
>>
>>
>>However, when I try to run it, I get this error message
>>
>>---------------------------
>>An Error Occurred
>>---------------------------
>>Error: Skims is not related to the current work area.
>>
>>nError: 1165
>>
>>Method: printreport
>>
>>Line: 185
>>---------------------------
>>OK
>>---------------------------
>>
>>Do you know what am I missing?
>>
>>Thanks in advance.
>
>Can't really tell by your image if the detail bands are setup right or not. I'm assuming you followed Cathy's steps online?
>If you set skip to do you see all the related records just browsing?
>Silly question, but the tag order is set correctly on all tables before you issue the set relation, right?
>The datasession isn't changing is it?

Good point about tag - I haven't set or created it in the temp tables, I guess I'll need to do so.

What do you mean by SET SKIP ?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform