JT

I'm using the ARIS Report Writer to generate a report in Excel.  I am able to get my data, however, the Report Writer appears to put a header row whenever I have change in one of the values in the data used to categorize changes.  See example below.  I only want the header row in Row 1.  I seem to be able to either get no headers at all or the repeating ones.  Any pointers will be appreciated.

by Stefan Broadus
Posted on Fri, 11/12/2010 - 16:16

You are probably using a data table query to create this. Is your report being run over several criteria (groups, models, or objects)? (It appears so)

It looks as if your header is either in the dynamic section of your data table, or in a lower level query and thus being replicated every iteration of the query criteria. If this is the case, move the header into the static region or into the highest level query in your report.

If this still doesnt work, try inserting a formatting table in the above the data table to put your header. I know not the ideal solution, but this work around has worked for me in the past.

-Stefan

0
by Jim Thompson Author
Posted on Mon, 11/15/2010 - 14:38

In reply to by thaase

Stefan,

I am using data table query that is embedded in a two level nested query. 

I took your suggestion about moving the column headers to the static area for the top-level query.  This solution worked for me. 

Thank you for your help.

Jim T.

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock