Hi,
I created a report which is based on a cross tab query and it is based on one particular col in my table.
Now I have 2 other reports which are exactly the same but just picking up a dif col from the table.So I just used the same report and change my record source depending on the report I want to generate.
report 1 :based on month_Actual col
report 2: based on month_prev col
report 3: based on month_budget col
Now the thing is that I need to show these 3 reports in one report.
This is what I did:
Lets call the General report whos record source I would change previously "report_all"
I created a blank report and added report_all three times as a subreport.
Now what I would like to do is make the first subreport point to query that picks up month actual.The second to point to query that picks up last year col and the third to point to budget col .
I tried right clicking the subreports but the event property option is dimmed.How can I change the record source of these subreports??
Really appreciate it if someone can anyone help me out on this.
Thanks.
sync123
I created a report which is based on a cross tab query and it is based on one particular col in my table.
Now I have 2 other reports which are exactly the same but just picking up a dif col from the table.So I just used the same report and change my record source depending on the report I want to generate.
report 1 :based on month_Actual col
report 2: based on month_prev col
report 3: based on month_budget col
Now the thing is that I need to show these 3 reports in one report.
This is what I did:
Lets call the General report whos record source I would change previously "report_all"
I created a blank report and added report_all three times as a subreport.
Now what I would like to do is make the first subreport point to query that picks up month actual.The second to point to query that picks up last year col and the third to point to budget col .
I tried right clicking the subreports but the event property option is dimmed.How can I change the record source of these subreports??
Really appreciate it if someone can anyone help me out on this.
Thanks.
sync123