Creating Conditional Report!! Please help me!

[ahmad6483]

I have a main report (based on query 1) and two subreport(based on query 2 & 3). I want to create a button to run the main report on the below conditions:

1. If "a specific field of query 1" is equal to 1 then run the main report using "subreport 1 (based on query 2)"
2. If "a specific field of query 1" is equal to 2 then run the main report using "subreport (based on query 3 ) "

How can I define this in access 2010??

[June7]

Sounds like something I tried to do a long time ago and gave up on.

Why do you have two subreports? Are they really the same datasource just with different filter criteria?

If you want to provide db for analysis, follow instructions at bottom of my post.

[ahmad6483]

there is two types of reports, there are some courses for employees, employees with grade "one" can promote to level 3 and the others can promote to level 5, for this reason classification of courses are different for example:
courses include: a-b-c-d-e-f-g-h-i-j-k-l
grade one should be: abc-defgh-ijkl
the others: ab-cde-fghi-jkl

[June7]

That didn't help me understand data structure. But possible options:

1. Two subreport controls on main report on top of each other, code in main report Detail section OnFormat event sets visibility dependent on value in a field of main report or parameter passed in the OpenArgs argument of DoCmd.OpenReport

2. Code to change the SourceObject of subreport

3. The simplest approach might be two complete main reports (thank goodness for copy/paste), each with the different subreport then code would open the appropriate main report.

I do 1 and 3 with reports and seem to remember attempts at 2 failed.