Fixed number of columns in matrix report .. Urgent help

Question

Fixed number of columns in matrix report .. Urgent help

bunnie

Old Hand

Points: 376
More actions
June 25, 2010 at 1:16 pm

#222669

Hi,
Is there any way that we can display fixed no.of columns on matrix report.Like 5 columns on 1st page ,next 5 on 2nd page and so on.. The rows should be displayed normally,like as many as a pae can have. PLease help me ..this is reaaly urgent for me.
TIA

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

kpsr_kpsr 63487 SSCommitted Points: 1875 More actions · Answer 1

Hi

By using filter conditions u can fix the columns in page, i don't understand thing what u have mentioned, could u plz give some what clear idea,if it's possible.

Thanks

sank

bunnie Old Hand Points: 376 More actions · Answer 2

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 the page. Say 5 columns on the 1st page ,next 5 col's on the 2nd page. There's no restriction on the rows/ records.

Thanks

gayathridevi.msit Ten Centuries Points: 1294 More actions · Answer 3

u have to change ur REPORT -> PROPERTIES -> LAYOUT -> HEIGHT/WIDTH properties... Reduce those points.. so that it breaks up.. but 😎 grouping ll be visible only in 1 st page... 🙂

Regards,
Gayathri 🙂

bunnie Old Hand Points: 376 More actions · Answer 4

bunnie

Old Hand

Points: 376

July 13, 2010 at 7:55 am

#1192035

Thanks Gayathri

bunnie Old Hand Points: 376 More actions · Answer 5

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