February 25, 2015 at 6:51 pm
Dear SQLServerCentral members and administrators:
Hello, a pleasant day to all.
I am creating an RDL with a dropdown of approximately 50+ companies about their purchases. Is there a way to separate them with a blank row in RDL to separate each company every time I generate report? It is something like:
Company | Purchase Order | Purchase Date
=============================================================
Company A | AB-001 | 12-03-2014
Company A | AB-908 | 12-04-2014
<blank row here>
Company B | ZD-115 | 12-01-2014
Company B | DF-123 | 12-04-2014
Company B | AF-908 | 12-05-2014
In addition, I would like to do this in RDL (if there's a code/strategy for it), because the stored procedure was made by a colleague and I am not allowed to modify such, I was just assigned to create an RDL for that stored procedure.
Thank you all and have a nice day ahead. 🙂
Respectfully Yours,
MarkSquall
________________________________
"Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20
February 25, 2015 at 7:19 pm
Here's how I did it.
Steps:
1. addd a tablix to your report.
2. Add Company, PurchaseOrder, PurchaseDate fields to the tablix.
3. Right-click the body line (with the lines).
4. Add Group: Parent Group
Group by: Company
Check Add group footer
Click Okay.
5. Now we have company1, Company, Purchase Order, Purchase Date.
Delete the leftmost column (Company1).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply