Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago
Solved

Page Break at each instance Mismatch (Report Builder)

Don't know if this is where I would post this question, but I have created a paginated report and have added row groups on 2 separate tables. Both tables use a different query for the dataset. 
Due to this one table returns values 1-6 (in sequence) and the other only returns Values 1 and 5. I was wondering when the page breaks if we could get blanks for missing values on the 2nd table (example below...Row Group on 'Dataset1'[ID] and 'Dataset2'[ID1])

How Can I get it to show 2 and then BLANK(), but once The 1st table displays 5 the second table should show 5 as well??