May 18, 2017 at 4:59 am
I have a "City" dataset with a cityname column and other detail columns. I also have a "State" dataset with both a statename and cityname columns and other detail columns. I have setup a List with the first row using an expression and Lookup function to put the statename in that column using cityname for lookup. For the second row I have inserted a tablix using the "City" dataset with a header row. I also have a group on the tablix using cityname and keep the grouping column to show all detail rows to single cityname row and delete the detail column.
My problem arises when I save the report as a PDF and the "City" data exceeds a page length and continues on the next page. I cannot get the List first row to appear on the page and sometimes through a lot of trial and error I do get the tablix header to appear.
I have tried so many combinations of "KeepTogether", "KeepWithGroup", and "RepeatOnNewPage" I can't remember them all. Additionally I have tried "RepeatRowHeaders" and "RepeatColumnHeaders" which are used for matrices even though I don't have a matrix.
Any help would be greatly appreciated.
Thanks,
Rich
May 25, 2017 at 8:09 am
any chance you can combine the data in your data pull before you return it as a dataset? make it look the way you want, then retrieve it
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 4, 2017 at 11:17 am
Already have sp's for datasets would prefer not to add third unless no other way is found.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply