Hi Martin,
Thanks for the idea. Yesterday at the end of the day, the users changed their specifications for this report. They didn't want detail info at all, only summary info. So, I leave the first report untouched just in case, produced a summary table and created a new report.
Hopefully, now all users are happy :)
>Hi Nadya,
> Use two texts with font "Courier New".
> Source first text is variable: m.Text1
>
> SELE table1
> m.Text1=""
> SCAN ALL
> m.Text1=m.Text1+field1+" "+field2+CHR(13)
> ENDSCAN
>
>
> Source second text is variable: m.Text2
>
> SELE table2
> m.Text2=""
> SCAN ALL
> m.Text2=m.Text2+field1+" "+field2+CHR(13)
> ENDSCAN
>
>
> Or use imaginary group by imaginary field (XX000)...
> Create cursor as table and table2 with new field XX000.
> Records from table1 have in XX000 value "T1" and records from table2 have in XX000 value "T2".
> In detail have details for two tables. For every object set in "Print When: Print Only..." XX000="T1" or XX000="T2"
>
> MartinJ
>
>
>>Hi everybody,
>>
>>I have the following report:
>>
>>Transaction Filing Dates - '30 Day' Timeliness Scorecard for MA...
>>
>>Begining Issue Week: 200203 through Ending Issue Week: 200220
>>
>>Registry Issue Week Latest Filing Date Pub Delay Timely
>>
>>Barnstable 2002 03 12/14/2001 38 No
>> 2002 04 12/26/2001 33 No
>>....
>>
>>Registry Average for Report Period: Avg Timeliness 72.22%
>>=======================================
>>...
>>
>>======================
>>Massachusetts Average: Avg Timeliness all IssWeeks all registries 62.96%
>>
>>
>>I set up 4 report variables: Registry_Timely, Registry_Cnt (end on registry) and similar for report Rep_Timely Rep_Cnt (end on report).
>>
>>The user requested to repeat Registry Summary info right before State Summary, so they don't have to flip through the stack of paper...
>>
>>I explained, that it's quite complicated to achieve, but I'll try.
>>
>>However, I don't see an idea at this moment, how to produce such report. May be you can help me?
>>
>>Can I use two separate tables in one report?
>>
>>Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog