How to Show Single Crystal Report according to different Column wise.

Question

0.00/5 (No votes)

See more:

Hello Every One,

I am making an asp.net application. In which i want to show records in report. I have four columns Employee, Project, Date, Module. I want to make such a report in which if user select Employee then report should show employee wise or if user select project then report should be display project wise. Still i have to make different four Crystal Reports which shows according to filters. But I want that is their any GUI control or Functionality in which if user selects Employee Column in report Then report is convert according to employee wise. same for project and any others.

If anyone have any idea or any solution or any article then give me.

please help me.

Posted 5-Jul-12 1:06am

coolnavjot31

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)

ShaikhM · Answer 1 · 2012-07-05T16:17:00

This reminds me of a similar thing that I did for a customer.

I had to dynamically change the sequence of the columns in the report based on users UI selection. I succesfully achieved it using

SQL

PARAMETERS.

Behind every UI selection I was setting parameters in the report. There wasnt any direct field dropped on the report. Instead I placed parameters as columns and passed values to those from my code.

Because in crystal unless you have sections you cant do much about sorting columns.
----------------
Yet another way is to pass an

SQL

order by

clause to the SQL query based on the users UI selection. This also makes sense and creates the query before hand. So behind every control you have place a sort on that particular field sql.

Hope it gives you some direction.