May 14, 2012 at 4:05 pm
I have a formatting question for report builder 3.0 that is executing on a sql server 2008 r2 database. I would like the 3 layers of control breaks to be left justtified. I know there are the groupings in the tablix. However, groupings indents the values on each line. I want the data to be left justified since the data on each line will take up the entire line.
Here is what I would like the report builder 3.0 report to look like:
Report title
Client # 1 (left justified)
Contact information for client #1 (left justified)
Transaction category with description (left justified)
process date transaction code transaction description
99/99/99 999 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
99/99/99 999 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Client # 2 (left justified)
Contact information for client #2 (left justified)
Transaction category with description for client # 2 (left justified)
process date transaction code transaction description
99/99/99 999 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
99/99/99 999 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can you tell me how to solve me problem? Are there several levels of titles I can use and/or how can I a ccomplish these task usging the tablix?
May 15, 2012 at 5:20 am
Create the tablix as normal for the lowest level transaction detail rows. Add the grouping level working outwards using the ParentGroup option ie row groups creating group headers. This will add extra columns but stay with it.
Merge the cells above the transaction detail rows into a single cell for each group. Add the relevent group header field into each. Remove the columns to the right.
Fitz
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply