Cross Tabs problem with grouping and extra columns; possible bug?

There was a question in BIP forum to get the dynamic column,..

User was Brian, he required , the number of column based on the data in the xml...




This was the XML , he gave.
He required this kind of output, which is obvious,



but , by using the Cross-tab from the menu, and formatting , you cannot expect this output..
That is going to screw up the output.

He was thinking, it is some kind of bug, its not a bug,
the way he want can be done easily :).

Little understanding of how report should work is required :)
here is the solution :)
Please click on the image to see :)

Comments

Anonymous said…
Hi, thanks, I was facing a similar situation. Your blog, gave me a quick solution. however, because of the horizontalbreaktable tag, the other part of the table is coming on the next page. Is there a way to bring both the tables in the same page?
I have data for 52 weeks. Since the table is too large, I am breaking the table, but I want the rest of the columns in the same page? I guess it has got something to do with the tags.. pls help.. Anupam
Vetriselvan said…
Hmm,
We can do that, by using the custom page size.
Increase as far as possible, those number of columns will be there in that page.
Vetri.
Unknown said…
Hi,

In the sample report you're showing baselined & draft amounts for each task. If the same report needs to be modified to show amount, budget type and client details for both baselined & draft tasks.

Could I accomplish this via















Let me know. I'm lost in the semantics.

Thanks
Unknown said…
hi in query i have mulptile group by columns. i need to develope the report GL date as the cross tab. group by like rulename,dept,sales orders like that. please help me how to design rtf template for this. my mail id is sunitha.mca119@gmail.com
Unknown said…
need output like this

Unknown said…


Invoice Number Invoice Date Bill To Customer Number Bill To Customer Ship To State Ship To Country Ship To City Ship To Zip Sales Order Dept Rule Name Gl Date 2016-04 2016-05 2016-06 2016-07 2016-08 2016-09 2016-10

WANT REPORT TO BE LIKE THIS ($ AMOUNTS ON 1 LINE)
10001 03-JUN-2016 32280 Grand Valley State University - Allendale MI US Allendale 49401-9401 17695 41141 TRVN_PS 12-Mo Rev Recog 99.58 99.58 99.58 99.58 99.58 99.58

Popular posts from this blog

BIP Formatting

Repeat Table Header in all pages in BIP

Limit rows per page