September 3, 2019 at 12:41 am
New to SSRS reporting and not sure how to create this properly.
I have attached a word document. Each permit has at least one parcel and address. Some have multiple. When a permit has multiple I would like it to appear as it does in the word document so that the permit number does not repeat for every extra parcel or address.
September 3, 2019 at 6:10 am
Nobody's going to read an attached (maybe virus-infected) file. Post your CREATE TABLE and INSERT scripts here.
Maybe JOIN() does what you want?
September 3, 2019 at 9:01 am
What version of SQL Server? Perhaps STRING_AGG or FOR XML PATH and STUFF will help you here?
I also reiterate Pietlinden's comment; the users are unlikely to download a word document to help you. Especially when you haven't actually attached it either. If it's important, then put the information in a post and as text, as then we don't have to download anything.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 3, 2019 at 12:13 pm
Thanks, I will remember it for next time. It was actually just grouping that I needed to make everything fit right.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply