BI Publisher keep Running Totals where row details are hidden?

John Bruso1

Summary

BI Publisher keep Running Totals where row details are hidden?

Content

Hi All,

I need to use Running Totals to figure out my sub totals and totals. However, I do not want to show these detail rows on my final report, just the subtotals and totals. But, if I hide the detail rows, my running totals go to 0.

In Crystal Reports you can just hide rows and still get your running totals. How can I do this inside of BIP??

Instead of seeing Running Total Details:

I just want to see the summary:

Thank you,

John

Carlos Carvalho

Ok, understood.

So solution is by editing source query as replied by ​

Besides, why are you having to process the data in BIP when you can do it in the SQL wich will not impact (has much) in performance.

BR

Carlos

Carlos Carvalho

Hello,

For what i see you just need to use the tag: <?xdoxslt:sum(//FIELD_NAME)?> in last row of the rtf template

e.g.:  <?xdoxslt:sum(//Project_Miles)?>

Regards,

Carlos

P.S.- Ah, after post i saw the other response and realize one thing i missed (the group), so include that suggestion also.

Carlos Carvalho

Hello,

Can you pls provide a screen shot of what you intend as output layout result (i do not use crystal-therefore i do not know what you are referring to)?

Thanks

Carlos

Kavitha_CP-Oracle

Hi John,

What is your BIP version?

John Bruso1

Bean,

Ya, I was just trying to avoid having to rework the whole thing just because I can't hide some rows... I may just do that... go back and build in the logic into the SQL.

Thanks!

John

Venkat Thota - BIP

Please upload RTF Layout and xml , will send you Updated Layout. Thanks

John Bruso1

Bean, I can get the totals.. that's not the problem... I want to hide the details... all of the rows... so I just see the subtotals...

j

John Bruso1

Venkat, is there no solution inside of BIP besides editing the source query?

John Bruso1

Hi Kavitha and Bean,

I've attached images to the top. I'm using Word BIP Plugin 11.119.

john

Venkat Thota - BIP

Please handle at source level by using group by clause or apply group by in template on functional classification column. Thanks