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
Sat May 16, 08:00:00 PM 2009
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.
Sat May 16, 09:28:00 PM 2009
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
Fri Apr 22, 10:49:00 PM 2011
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
Tue Aug 23, 02:17:00 PM 2016
Unknown said…
need output like this

Tue Aug 23, 02:21:00 PM 2016
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
Tue Aug 23, 02:24:00 PM 2016
Post a Comment

Popular posts from this blog

BIP Formatting

Image
Adding formatting is easier in BIP. It can be done manually or automated through menu. How to add the BIP formatting manually,  here is an example. Just add the logic and the formatting you needed. How to add the BIP formatting through menu,  here is an example. use the Menu and choose conditional formatting You have to select the data filed and choose the menu option conditional format
Read more

Repeat Table Header in all pages in BIP

how to repeat the column titles on a table in all pages if the table extends over several pages What you need to is: 1. Select and Highlight the table header row 2. Right click and select table properties 3. On the Row tab properties , specify that the header row should be repeated on every page 4. Save the RTF 5. BIP looks at the properties of the word settings for the table and will repeat the header row on every page the table needs. This works so well in PDF output, but RTF output seeems to have some issue with this header repeat functionality We all can beleive, In future releases this bug won't be there ;)
Read more

Limit rows per page

Image
Solution to have fixed number of rows in each page. This solution is not a perfect solution considering the line size increases due to text in each line. But this solution gives you how to fix no of rows per page. In the forum Heated discussion Users are arguing for having a placeholder in same fixed place on all pages, irrespective of no of lines , increased line size due to word-wrap. Here i am not going to discuss anything related to that. But a simple logic of , how to fix number of rows. Step 1: Loop through the records and display them Step 2: Have a condition for MOD of position(), then insert a page-break on the result of Zero Step 3. Blank row has to be filled, a condition has to be added, to find how many blank rows ROWLIMIT - (count of row mod ROWLIMIT) will gives us the rows to be filled. Step 4: use foreach_number function to simulate the iteration. Refer the images below
Read more