Report Selection Formula

[knagy]

I am going to try to explain this as best I can so please bear with me. I am using Crystal 9 with a Timberline database. I have created a report and hid the details so that only the subtotals are showing. The main subtotal is based on a Unit Description field. The user can drill down on this subtotal and get the items (details) for that particular Unit Description field. For example, if the user drills down on the 1-1 (Unit description) subtotal, they get the items that pertain to that description. If they drill down on the 1-2 subtotal, they get the items that pertain to that description, and so on. This part works fine. However, each Unit Description needs a unique report that will show additional specific information available for the user if they want it. I would like to set up a hyperlink to access this report in the details section. My problem is that I only want to show one report hyperlink in the details section. Therefore, I would need some type of formula that would automatically select the correct report based on the Unit Description. Is this possible? Thanks for any help.

 

[GJParker]

Use an on-demand subreport and link to the main report by unit description.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[knagy]

The special report for each Unit Description is different. Therefore I would need to have seven (that is how many different Unit Descriptions we have) On-Demand Subreports and seven links. I don't want all seven links to show on every Unit Description drilldown, so I would need some type of suppression formula to suppress six of the links and only show the one link. This formula is where I am having problems. Or are you saying that I can have the seven reports and link them to the Unit Description group field?

Ken

 

[lbass]

You only need one subreport placed in the group header or footer for the description group which you then link to the main report on the description field. If you want it available only on drilldown, then place it in the group footer which you should have hidden until drilldown.

-LB

 

[knagy]

Maybe I'm not explaining this correctly. I can not use a single subreport as the information and the format is different for each unit description. So one report will not support all seven unit description types.

 

[GJParker]

Would the format of the subreport(s)be so different ? i.e. could you use different sections of a subreport to display the data required for each Unit description and use suppression formulas to display teh required section(s).

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

So you are saying that each subreport uses a different table or different fields within a table? If so, then you could add one subreport to each of seven group footers, and then conditionally suppress each group footer section with a formula like:

{table.unitdescription} <> "Currentunitdescription"

These could still be set up as on-demand subreports.

-LB