generate dynamic rdlc report

Question

0.00/5 (No votes)

See more:

iam working on asp.net website vs 2010 & sql 2008

i have some reports for employees
but i hvae notice that evry afew days some body ask for differnet report
for example --> code-name -birth date -join date
another one ask for -->code- name -job-department .......

& some times they ask for different orders of columns

so my idea was to make page that contain all the column that users may need
then user choose the columns he need to dir in the report & the dir order
so if u have any idea on that please help me

Posted 3-Mar-12 1:36am

md_refay

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)

richardw48 · Answer 1 · 2012-03-03T03:43:00

Solution 1

You're going to need to do the following:
1. provide a list of columns to the user to let them choose which ones they want to see and in which order;
2. Build an SQL statement using the columns selected;
3. Create a dataset containing one datatable to contain the required data;
4. Fill the datatable using the SQL command from 2;
5. Pass the dataset/datatable to the report;
6. Show the report

Posted 3-Mar-12 3:43am

richardw48

Comments

[no name] 3-Mar-12 23:13pm

ok this is mean i must have rdlc report with fixed columns
but i need to make dynamic one
& what about the problem of columns orders

richardw48 4-Mar-12 3:08am

The .rdlc file contains the report definition in XML format, so in order to modify the order or visibility of the columns you will need to edit this file directly. Open the rdlc file in NotePad++ or any other XML editor to examine its structure. You can use the HIDDEN tag to hide a column and you can also define the fields and columns. It's not easy but it is possible.