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

Oh, I think I just answered my own question.... division is div and not / So, <?xdoxslt:truncate(( (SUM_LIMIT_AMT * 1.05) div 100000 ) + 1) * 100000?>

Thanks 335, Unfortunately, that doesn't clearly tell me how to pass the Project ID from the Main query to the sub template query... similar to how this would function inside of a Crystal report with a sub report that is passed the project ID variable to retrieve the project in the sub report with the same ID. What am I…

Hi Venkat, Yes, the main template has 1 data source (Projects) and the sub template has a different data source (Engineers). Project ID is the common value between the two. Is this possible within BI Publisher or do I need to figure out a way to connect the data within Peoplesoft into 1 query? Thanks! John

Thanks Tim! Just the hint I needed to make progress... I think I'm good now. Whew! John

Thanks Guys, This is what we expected but wanted to confirm with you all. Thanks for all of your help.

Wow, thanks Brajesh. I was actually looking for a way to protect the rtf data if a user outputted it from peoplesoft into excel. Sorry for the confusion. I probably need to look into a peoplesoft feature and not a BIP feature. If I was starting from an excel template your solution would work.

Thanks. I do understand that we need to use for each statements... My confusion is that the 1 report seems to be displaying many rows of data without these for each statements. I've attached an rtf example with a pdf of the output to the original post. The sample data has 5 rows. I expect to see only 1 row because there…

Thanks Brajesh... does your xsl output into wordpad or some other tool? If it is in wordpad, do you get line numbers in it? How? If it is in another program, where do you change what program the XSL-FO opens in? Thanks, john

2807, how do I upload the xml sample data and rtf template here? I don't see a file attachment option. John

I found it.. bottom right corner.... they hid that well The files are attached to the original post.

Woohoo, I found the problem... Click the contents of the rows, and look at Page Layout/Spacing/ After and change 10pt to 0pt. That fixed my extra space issue! Woop! John

I figured it out. Within the Pivot Table wizard, on the right side under MISC/ Row Layout choose 'Inline' instead of 'Outline'