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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics