Extracting Top-N Values and passing them to subreport

[69AceCool]

CRXI
ODBC Connection to Remedy ARS 5.1

Hi All,


I have a report that counts the number of requests and groups by Category. I then use the Group Sort expert to Sort the records by Top-N. e.g
Software
Hardware
User Access
Mobile
Audio Visual

How do I capture these in to variables that I can pass in to subreports. (I know how to pass variables to subreports just don't know how to capture the Top-N info above)

Many thanks!

 

[lbass]

What is it you are trying to pass? If you link the subreport to the main report on category, then the subreport will appear in the appropriate place, based on the topN sort. So I guess you mean something else, please provide more explanation about what the subreport is supposed to do and what in the main report you are summarizing and using for the topN sort.

-LB

 

[69AceCool]

Sorry lbass, I would like to have 5 on-demand subreports sitting as links next to a crosstab in the main report so that a user can click on them and get further detail on the TopN Category. There is aggregate data in the main report but it is all 'Top Level' which suits the purpose of the main report. (This drill-down info will provide much greater detail than what is in the main report, different graphs, period data, etc) I hope to be able to pass one of each of the Top 5 Categories as variables to the subreports.
e.g

Software 55 --- Link to Software Task Detail
Hardware 22 --- Link to Hardware Task Detail
etc..

The TopN can change order of course which I will account for.

Hope that makes sense

 

[lbass]

That you are using a crosstab was a key piece of information to leave out! You should always identify the row, column, and summary fields when referencing a crosstab and indicate in what report section it is placed.

I think the best you can do is to use one subreport instead of five, where you group on the category field, show the group summary in the group header, and hide the detail. Then do a topN sort on the summaries in the subreport. Then suppress all sections but the group header and resize them to match the height of the crosstab rows. I would also format with "relative position" on the section containing the crosstab and subreport.

The downside is that the user will have to click twice to get to the detail, but it will give the look you want.

-LB

 

[69AceCool]

Hi lbass,

I need to have the TopN categories seperate as the amount of detail that is retrieved can be large and performance wise takes longer if you have to retrieve all of the TopN's in one subreport. Also depending on the type of TopN Category I would like to run a specific subreport that provides a different analysis.

Is there systemically anyway that I can hold the TopN in seperate variables within the Main report?

many thanks for your time,

A.