applying parent tablix border properties when child tablix element is hidden
Hi Chopstix,
In your scenario, the easiest way to achieve your requirement is add a column to you report. I have test the issue on my local environment, the steps below are for your reference:
Drag a matrix control to your design surface.Drag the schedule field to the first column and product field to the second column.Add a row group for schedule field in the group pane, group by shop field.Add a column group for product field in the group pane, group by product field.
The report looks like:
If you have any questions, please feel free to ask.
Regards,
Charlie Liao
August 25th, 2012 2:12am
Thanks a lot Charlie Liao for your help.
Unfortunately, the task has been changed. I need to add the employee column. If there are more than 3 products per shop, new row is needed to display info per that shop.
I know it's kinda illogical but I'm not in charge. I suppose query has to be changed, maybe I can use some CTE stuff in order to group info at row level per shop and max 3 products.
Report has to look like this :
shop schedule product product product employee
Eton 10-18 2 3 4 Charlie
York 11-20 3 5 6 Daniel
Yale 8-22 1 2 3 Chris
Yale 8-22 4 5
6
Chris
Yale 8-22 7 11
Knox 9-16 2 3
John
Lao 10-22
11 12 13 Zen
Lao 10-22 15 20
Zen
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2012 3:29am
i want to create a table, each row representing the activity per shop.
i know it's stupid but i need to have in the table three columns for product information.
the query is like this
shop schedule product sequence
1 1 2 1
1 1 3 2
1 1 6 3
2 2 2 1
2 2 4 2
sequence value is set up by using an ranking function
table should look like
shop schedule product product product
1 1 2 3 6
2 2 2 4
i created three child tables for each product box from the parent table , i set up visibility property for each child group depending on a sequence value.
my problem is that border is missing when there are less than 3 products per shop. i don't need white spaces in my table . i think box border property should take into consideration parent table configurations.
August 25th, 2012 7:12am