Thank you for the response!

I tried hiding the indicator when value is "n/a" , but wasn't able to display the text "n/a" then.

So the way I made it work is...

First let me appolozige for posting the code in a clumsy manner, though I tried creating spaces, it did end up like that after I posted it. Will try to...

hey ,

I tried using DENSE_RANK() function inthe dataset query ,and it did worked for me.It's now showing 5columns/page.

Hope this might help others.

Thanks

Thanks Gayathri

Hi ,

Thanks for the reply.

What Iam trying to do is.. I've a matrix report ( parameterized ).When I run the report ,I need fixed no.of columns to be displayed on...

Thank you so much.

The expression I included is for the same visibility of the detail row. But still it's not working . When I add this expression , it gives...

Hi ,

Thanks a lot.I understand what you are telling .I have 3 parameter dropdowns for Division, Region , SalesOffice. And the report should look something like this if the default...