How to control the table data flow in SSRS

Question

0.00/5 (No votes)

See more:

HI i had a requirement where i have a datset with 100 rows (based on client it varies) so here what i am supposed to do is to show all the rows in same page with two tables side by side for example i created two tables side by side (left and right ) so what i want is when i run my report i have to get the rows in same page instead of going in to next page lets say if my dataset gets 100 records first 50 records should be on left side table and the rest 50 should be other side (right side table ) is it possible to achieve i know one method using the mod to hide the odd and even rows if i do that i will get my data in horizontal format (1st record on left table and second record on right table) i dont want to show my data like that ,i want my data to show up in vertical manner is there a way to acieve it

Posted 26-Apr-11 12:37pm

makwith9789

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-04-26T18:48:00

Solution 1

,i want my data to show up in vertical manner is there a way to acieve it
One possible way:
Have one column in the dataset as index (serial number). We will use this as a filter parameter for simplicity.

Now,
for left side table, filter all the rows after n(lets say 50). Thus only 1-50 rows available and visible in it.
for right side table, filter all the rows before n(lets say 50). Thus only 51-rest rows available and visible.

Try!

Posted 26-Apr-11 18:48pm

Sandeep Mewara

Comments

makwith9789 27-Apr-11 9:12am

HI this Filter helped me ,i have other question like i have only 38 rows coming from dataset and i grouped those two tables with 20 rows per table ,so my left table will get 1 to 20 rows and my right table will get 21 to 38 rows ,the rightside table lay out will be smaller and it looks kind of off is there a way to get some dummy rows and make it equal from report side or should i need to get it from server side?

Sandeep Mewara 27-Apr-11 9:41am

1. If an answer helps, you should upvote and accept the answer.
2. If you are talking of difference because of 2 missing rows (only 18) then you can always fix the row height. In case you are unable to then yes, best would be to add dummy data to the dataset itself on the server side.