Creating a sub report with variable number of fields to print
- From: "Michel Khennafi" <michel.khennafi@xxxxxxx>
- Date: Wed, 11 Jul 2007 12:45:30 -0500
Good morning
I would like to create a report that includes a subreport.
Situation:
- I have a Table T1
- I created a Xtab query 1 and a Xtab query 2 to extract informations from
the T1 table (sum of a field f1 by day of the week: Sun, Mon, Tue...)
- I created a selection query SQ1 that grabs all the data from Xtab queries
1 and 2 (sum of a field f2 by day of the week)
- Sub report is for data gathered in the selction query SQ1
My problem is that the number of fields returned by SQ1 may vary (1 week i
have totals for Mon thru Fri and another week I could have sums for Mon thru
Sun). I want to create a report that could handle all situations
I could I create a report that handles my problem?
Thanks for any guidance or help
MK
.
- Follow-Ups:
- Re: Creating a sub report with variable number of fields to print
- From: Allen Browne
- Re: Creating a sub report with variable number of fields to print
- Prev by Date: Create a TOC with multiple categories in a report
- Next by Date: Re: print window from print preview?
- Previous by thread: Create a TOC with multiple categories in a report
- Next by thread: Re: Creating a sub report with variable number of fields to print
- Index(es):
Relevant Pages
|
