J
John
I am having a problem with a report that has a subreport on it. Both the main report and the subreport pull the same type of data. The text boxes on the reports add the number of accts (similar to count) and there are 4 sum text boxes for amounts. That is it
The formula's that I use (courtesy of Duane Hoakam) are =Abs(Sum(trans_code) In ("T5053","T3049","T3459","T3460") to do the count and =Abs(Sum((trans_code) In ("T5053","T3049","T3459","T3460"))*[total_charges])) to do the sum
The subreport pulls the correct amount of data but the text boxes on the main report don't. Should I have separate queries for each (there are only 3 things on the summary report that I am looking at and the amount of data on the report is small)The problem I am having with my main report and subreport is that both have a date parameter that prompts the user for the Number of the Month so that the query can only pull that info for that month
In both the main report and subreport I do have a group under sorting and grouping that is the expression in my query to prompt for the month. On both reports the text boxes are placed in the group's header
I am getting prompted 3 times for the Number of the Month when I run the report. What am I doing wrong
TIA
John
The formula's that I use (courtesy of Duane Hoakam) are =Abs(Sum(trans_code) In ("T5053","T3049","T3459","T3460") to do the count and =Abs(Sum((trans_code) In ("T5053","T3049","T3459","T3460"))*[total_charges])) to do the sum
The subreport pulls the correct amount of data but the text boxes on the main report don't. Should I have separate queries for each (there are only 3 things on the summary report that I am looking at and the amount of data on the report is small)The problem I am having with my main report and subreport is that both have a date parameter that prompts the user for the Number of the Month so that the query can only pull that info for that month
In both the main report and subreport I do have a group under sorting and grouping that is the expression in my query to prompt for the month. On both reports the text boxes are placed in the group's header
I am getting prompted 3 times for the Number of the Month when I run the report. What am I doing wrong
TIA
John