show compressed data

[satishsure]

In List report, we are getting one dealer name column data values are coming in 6 pages .user wants one column of data(may be 3/4 values) besides to that any link/button..or any ->user should be able to click to expand and see all dealers Names in separate report/with in the report.

Dealer
Test1,Test2,Test3..

[Lynn]

In List report, we are getting one dealer name column data values are coming in 6 pages .user wants one column of data(may be 3/4 values) besides to that any link/button..or any ->user should be able to click to expand and see all dealers Names in separate report/with in the report.

Dealer
Test1,Test2,Test3..

Is this a relational source? Is the comma delimited list you show the desired output or is that what your dealer name field contains already? What do you mean by data values coming in 6 pages? Are there other columns on the report that would automatically group and summarize if you omit the dealer name?

Sorry I'm not understanding what you've explained. You could use a drill through link to show the dealers but you mention expand which is a different thing entirely.

[satishsure]

Its relational data source.This field value is coming from prompt parameter and updated as coma separated one.Its not like this in database.I have added the screen shot as well.I am not talking about expand..Can it be possible to hide the dealer names and some body clicks the button/ link it should be displyed

[Lynn]

Its relational data source.This field value is coming from prompt parameter and updated as coma separated one.Its not like this in database.I have added the screen shot as well.I am not talking about expand..Can it be possible to hide the dealer names and some body clicks the button/ link it should be displyed

If it is coming from a prompt response then it shows exactly the same dealers on every row? You can put a conditional style on the dealer column to display or hide based on a parameter. Add a link and have the report drill through to itself with the parameter set to show.

[satishsure]

Yeah, Its coming as rows in the table.If it is possible Can you tell me the steps you have explained me..thanks for your help

[Lynn]

Yeah, Its coming as rows in the table.If it is possible Can you tell me the steps you have explained me..thanks for your help

This link explains how to conditionally hide/show a column.
http://www-01.ibm.com/support/docview.wss?uid=swg21340051

Once you have that working you can add a text item that says "More..." or whatever you want it to say, then add a drill through definition on that text item to the same report, but passing the appropriate parameter value. You'd hide the more link when the report is run to show the full content.

[satishsure]

Thanks for the steps..Will check this