Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-band report
Message
From
08/04/2011 18:37:46
 
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:
01506744
Views:
30
>>>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 ?

Remember the SET SKIP command? :o) It's a handy way to check relationships in the browse window... SET RELATION should work for your report though...
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Reply
Map
View

Click here to load this message in the networking platform