Formatting multiple datasets in columns
I have 3 datasets that need to be displayed on a dash board. The issue is the one is long with many rows while the other 2 are short. I would like to format it like this:
Dataset1 Dataset2
Dataset3 Dataset2
Dataset2
Dataset2
Dataset2
Dataset2
But instead I'm only able to display it like this:
Dataset1 Dataset2
Dataset2
Dataset2
Dataset2
Dataset2
Dataset2
Dataset 3
If it matters all the data is a fixed number of rows.
Any assistance will be appreciated - thanks in advance.
May 28th, 2012 11:45am
Hi MOPAP
Thanks for your posting. You will be able to achieve this please follow these steps
Create a blank reportPlace a rectangle inside the report Put a tablix inside your rectanglePut your dataset 2 inside that table Place another rectangle inside your first rectangle beside the first tablePut two table inside your second rectangle and place the remaining two dataset dataset1 and dataset3 inside those tablesYou are done
If you have any question please let me know.
Many Thanks
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 5:59pm
Perfect! Thank you so much Sir! I played with rectangles but couldn't get it right, but your solution worked perfectly.
May 29th, 2012 2:53am


