Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Complicated logic for Report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00689239
Message ID:
00689539
Views:
28
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
Previous
Reply
Map
View

Click here to load this message in the networking platform