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:
00689431
Views:
29
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.
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform