Merge various formulas in Selection Formula 1

[pko123]

Hi,
I have one report that includes Manual Cross-tab(summary report) 7 rows and 5 columns,now the reqirement of the new report is when user click the any combination of row and column, the details should be shown in another seperate report corresponding to that number.
In order to achieve that i have created a report and using that report as a hyperlink to each combination of row and column.

first question: is there any better way of achieving this goal?

second question: for 5 columns the criteria is something like that

First column : Date1> currentdate -90 and Date2<currentdate 
Second Column: Date< currentdate
third column: date = currentdate and status in ('a','n')
forth colum : date = currentdat
fifth       : date1 > currentdate and date2 < currentdate +90

is there any way to merge these 5 formulas in one selection formula?

thanks in advance

 

[lbass]

1) I think you have to use the hyperlink approach.
2) Selection formula for what? Each column has to have a separate conditional formula, and each hyperlinked report would have its unique record selection formula, so it's unclear what the question relates to.

-LB

 

[pko123]

Thanks for reply,
In the above , I was trying to create only one generalized hyperlinked report and trying to link the main report to the hyperlinked report through parameters in the hyperlink. so i wanted to create a generalized formula of above 5 formulas, so i have to create minimum manuplation for each hyperlink.

and another problem i am facing is , when i tried to create a link betwwen main and hyperlink report thru paramter, one of the parameter value has "-" eg In-Building, and for this particular vaule the hyperlink is not workin,
any suggestions?

 

[lbass]

You might have to link on formulas like:

replace({table.string},'-','')

I don't really follow your idea about merging the selection formulas. The formulas once entered will be dynamic (since they are based on currentdate).

-LB