Home > Home, MSDN, SSRS > SSRS : how to divide the report horizontally and vertically

SSRS : how to divide the report horizontally and vertically

This Question i got from MSDN, to go to original question click here

In Brief:-

 i need a report where i need to divide the report columns  horizontally and vertically as below image..

3*3

 need to divide the tablix rows as 3 tablix horizontally and 3 tablixes vertically..

Lets create one sample report using below sample query:-

select 1 rownum, 1 columnum,’show in first row first column’ data
UNION
select 1 rownum, 2 columnum,’show in first row second column’ data
UNION
select 1 rownum, 3 columnum,’show in first row third column’ data
UNION
select 2 rownum, 1 columnum,’show in second row first column’ data
UNION
select 2 rownum, 2 columnum,’show in second row second column’ data
UNION
select 2 rownum, 3 columnum,’show in second row third column’ data

So , in the data query try to generate the rownumber value and column number value.

Just place the Matrix control in your report and design as shown in below screen:-

1

Once this done, hide all the text boxes except Data textbox as shown below:-

1

After hiding , run the report, report looks like below:-

1

Thanks

Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : Know BI Tools

 

Advertisements
Categories: Home, MSDN, SSRS Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: