Hi All,
I am in the process of merging some reports that were designed at various times over the last two years.
These three reports use the same underlying view, so the columns are all the same.
I use CR version 8.5.
The first report pulls and groups Warehouse information by their "Transaction Date".
The second report was designed to pull and group by "Manufactured Date",
The third report pulls and groups the same records by "Julian Date".
My Task is to merge these 3 reports into one, and depending on my choice, will group accordingly.
Question: How can I make use of the "Switch" function in my record selection formula.
(I will mention only the 3 most important parameters giving me trouble here)
First Parameter. {?Order_Type} - This Parameter has a drop down List with 3 options.
( "By Transaction Date" -- DateTime field
"By Manufactured Date" -- Date field
"By Julian Date" )
Second Parameter. {?Date_Range} - The user will enter a Date Range depending on whether he chose By 'Transaction Date' or 'Manufactured Date'
Third Parameter. {?Julian_Date} - If the User Chose Option #3 "By Julian Date", he will enter the 3 Digit Juilan Date.
The first problem. How can I design my Record Selection to ignore for example
the {?Date_Range} parameter if the user wants to run by Julian Date.
Eg. I decide to run by Transaction Date, so I will enter the following parameters
1. {?Order_Type} = "By Transaction Date"
2. {?Date_Range} = '2004-1-15' to '2004-1-30'
3. {?Julian_Date} = '011' **( Can I have this parameter ignored )
Is there an easier and less complicated way to do this?
Thanks.
I am in the process of merging some reports that were designed at various times over the last two years.
These three reports use the same underlying view, so the columns are all the same.
I use CR version 8.5.
The first report pulls and groups Warehouse information by their "Transaction Date".
The second report was designed to pull and group by "Manufactured Date",
The third report pulls and groups the same records by "Julian Date".
My Task is to merge these 3 reports into one, and depending on my choice, will group accordingly.
Question: How can I make use of the "Switch" function in my record selection formula.
(I will mention only the 3 most important parameters giving me trouble here)
First Parameter. {?Order_Type} - This Parameter has a drop down List with 3 options.
( "By Transaction Date" -- DateTime field
"By Manufactured Date" -- Date field
"By Julian Date" )
Second Parameter. {?Date_Range} - The user will enter a Date Range depending on whether he chose By 'Transaction Date' or 'Manufactured Date'
Third Parameter. {?Julian_Date} - If the User Chose Option #3 "By Julian Date", he will enter the 3 Digit Juilan Date.
The first problem. How can I design my Record Selection to ignore for example
the {?Date_Range} parameter if the user wants to run by Julian Date.
Eg. I decide to run by Transaction Date, so I will enter the following parameters
1. {?Order_Type} = "By Transaction Date"
2. {?Date_Range} = '2004-1-15' to '2004-1-30'
3. {?Julian_Date} = '011' **( Can I have this parameter ignored )
Is there an easier and less complicated way to do this?
Thanks.