Selecting the number of rows 2

[tttggg]

I have a report with few groups.There is a parameter that enables the users to select the number of rows to display on the report. The user should able to select a certain number of rows for each group. For example if the user select 50 rows, then each group should populate 50 rows. Can any one help me how to implement this.

Thanks.

 

[tttggg]

Any one have any idea!!

 

[lbass]

Patience, please. We are volunteering our time--when we have it.

Insert a running total {#cntwingrp} which does a count of any recurring field, evaluates for each record, and resets on change of group. Then go into the section expert->details->suppress->x+2 and enter:

{#cntwingrp} > {?Number of Records}

-LB

 

[tttggg]

Thanks Ibass
I have an issue here.
I'm Getting the data from a SQL Command. It works only when i create the parameter from field explorer.And it doesn't limit the rows on the chart.The chart is displaying all the rows in that particular group. Could you please help me with this.

 

[lbass]

Both the use of a command and the need for a chart are entirely new information--please lay out the basics in your initial post as it affects what solutions are proposed. Do you care which 50 rows are shown? Do you want the most recent or the largest based on a certain field or what? It might help if you show the content of the command.

-LB

 

[tttggg]

I’m sorry for the lack of information.
Well , My groups are based on last seen. (Datetime) Whatever information that were updated in certain date
will be in one group, sorted in ascending order. So each group might have hundreds of rows and the
requirement is that to have an option for the user to select only certain number of rows.Whatever number of
rows that shows up in a group, should show up in the chart. for example if the user selects 10 rows, then
each group will have to have 10 rows in the details section and chart


This is what the constant looks like:

07/09/2007 neo.jjlabs.in MicrosoftWindows 2000 0.0
07/09/2007 dbserver.jjlabs. Microsoft Windows 2000 0.2
07/09/2007 commvault.jjlabs. Microsoft Windows 2000 0.4
07/09/2007 qalab2 Linux Kernel 2.6.9 3.0
07/09/2007 NOVELL Novell 3.0
07/09/2007 cvs Linux Kernel 2.4.20 9.7

Database: Postgres
CR XI R2

Thanks .

 

[lbass]

If it doesn't matter which rows appear within the group, I think you could insert a group #2 on some recurring field, and then go to report->group sort and choose topN = 50. You could also choose topN in the chart expert.

-LB