General information
Category:
Reports & Report designer
>>Having created dozens, if not hundreds of reports with the report generator, I thought I had most of the angles
>>figured out. Wrong! I've got a simple report (VFP 6.0) wherein I do the following:
>>
>>I put records into a free table and use that free table as detail in the report. I have the table in the DE of
>>the report; it is also open in the code that fills it. All I can get is the first record in the detail. This table is the
>>first one that I added to the DE. There is only one other table in the DE, and there is no relationship established. I have tried closing the table in the code before calling the report--no difference. This really generates two questions:
>>
>>1. Why am I not getting details??
>>
>>2. Is there a better way to accumulate data other than into a table? Is a view a better way? I tried a cursor,
>>but, since I couldn't place it in the DE, I got no detail.
>>
>>Any help with either question would be greatly appreciated.
>>
>>TIA,
>>John
>
>
John,
>My suggestion always keep report DE empty. You could SQL select the data to be reported.
>
>-First you SQL select into a table in design time to create / modify report. You place the fields with "no alias".
>-Then delete the table.
>-At runtime SQL select into any cursor and call your report.
>
>Also a view would be practical in the same manner.
>
>Why you see only first record ? Sounds like active table is not the one you're reporting on. With no relations, record pointer moves in active table and you get fields from report table, reccount("activetable") times.
>Cetin
Cetin:
Thanks for helping out here--I really appreciate it. It has been my experience that, if I do not have the detail table as
the first table in the DE of a report, I get no detail. I tried CREATE CURSOR with an empty DE; I still get only the
first detail record of the cursor. (I have to analyze each record to see if the conditions meet the parameters and then
adjust the deadlines for the current year. I know of no way to SQL SELECT records in a scenario like this.)
So, if I use a table in the DE, no tables in the DE, or a cursor, I still only see the first record in the report. Nothing
I can do makes multiple lines in the detail section; yet a RECCOUNT() of the table clearly shows multiple records.
Any further suggestions? Sorry to bother you again, but this one has me absolutely stumped.
TIA,
John
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only