Prompts related to subreport

[shelby55]

Hi

I have created a report with many subreports. Due to the amount of space available on the report, I want the user to be able to select how the data is grouped i.e. singular quarters if the timeframes selected are only 2 quarters or combined i.e. showing Q1/Q2 in one column of the crosstab and Q3/Q4 in the other. If this were just a main report, I would use boolean prompts and create the column heading formula to read:

If {?QtrsA} then "QtrNameA" else
If {?QtrsB} then "QtrNameB"

However, it doesn't appear that I'm able to have a boolean prompt passed from the main to the subreport (the fields don't even show up in the subreport as {?Pm-QtrsA} like the date parameters do). I don't want the prompt from the subreport because then I end up with one for each subreport which may be confusing to the user. Is there anyway to get around this or will I have to develop two versions of the report?

Thanks.

 

[synapsevampire]

Your formula doesn't make sense, aqnd booleans can be passed.

What you're likely experiencing is that your formula doesn't assuredly encompass all data, so it can't be used for many things.

Your formula slightly modified:

If {?QtrsA} then "QtrNameA" else
If {?QtrsB} then "QtrNameB"
else
"Blah"

Not sure why you'd do it this way though...

-k

 

[shelby55]

Hi SynapseVampire

Just as an fyi, the fields for QtrNameA and QtrNameB are as follows:

If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["04","05","06"] then "Q1 & Q2" else
If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["07","08","09"] then "Q1 & Q2" else
If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["10","11","12"] then "Q3 & Q4" else
If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["01","02","03"] then "Q3 & Q4"

and

If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["04","05","06"] then "Q1" else
If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["07","08","09"] then "Q1" else
If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["10","11","12"] then "Q3" else
If Mid(ToText({I10_Abstract_And_Provider_VR.DischargeDate}),1,2) in ["01","02","03"] then "Q4"

Not sure why these wouldn't encompass all data. Please explain why you wouldn't do it this way - if there is a better way I'd like to know! Also, please explain what you meant by booleans can be passed - if so, what could I have done wrong that this isn't working?

Thanks.