Generate dynamic report using rdlc

Question

0.00/5 (No votes)

See more:

Hi everybody,

how to create a dynamic column report using MSReport(rdlc). For instance I have a datatable with n columns. I need to give the column choosable option to the application user to make visible the column or to hide the column in runtime like how the gridview is working. Or can we send the boolean value to hide or visible the column created in rdlc with datasource.

Posted 12-Mar-12 1:52am

Shivapragasam

Updated 12-Mar-12 1:56am

v2

Add a Solution

3 solutions

Solution 1

hi Shiva,
You can achieve this easily by passing parameters to your report.
for example I have a column named Country code
I will pass parameter to report let say CountryVisible
in that parameter I will pass true or false

Well all this is a part of code you will be writing for your report

At report end you select a column of you table and right click on it and select visibility.
Then go to expression and type
=iif(Parameters!CountryVisible.Value="True",true,false)

Posted 12-Mar-12 23:15pm

shabibraza

Updated 12-Mar-12 23:39pm

v2

Comments

Shivapragasam 14-Mar-12 2:18am

what is true, false in the expression

=iif(Parameters!CountryVisible.Value="True",true,false)

Solution 3

that what i said to you ..
true and false were the bool type values

Posted 13-Mar-12 21:41pm

shabibraza

Comments

Shivapragasam 14-Mar-12 4:38am

i know we are at the same page. also i know those two are boolean type values. Can you please explain that expression. i cant understand how its working. i think if the value of 'CountryVisible.Value="True"' means true else means false am i correct.

Add a Solution

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

Shivapragasam · Accepted Answer · 2012-03-13T20:21:00

Solution 2

Finally i found it. i just send a Boolean parameter (isVisible) to the report. I used the following expression in column visibility "Hidden" property expression

=Parameters!isVisible.Value

Posted 13-Mar-12 20:21pm

Shivapragasam

Generate dynamic report using rdlc

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Generate dynamic report using rdlc

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us