loading more than one reports in a reports viewer

Question

0.00/5 (No votes)

See more:

have made a winform and as i am a learner started c# quite few months ago i have a need of creating reports so i created a reports using wizard but now i have a need of chaging the reports. so i thought up of building the reports not with the wizard but with the code so that i can change the query

select * from table1

and the second query for the next reports as

select * from table2

. so that i can put the searching facility in my reports.but i have googled out and i cant find any reports componenets. means what component are required for developing reports. like if it use dataset or datatable. an example will help me to build. sorry for my bad english as i am weak in it.

Posted 28-Mar-13 19:05pm

sariqkhan

Add a Solution

2 solutions

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 · Answer 1 · 2013-03-28T19:54:00

Solution 2

If SSRS, see: multiple report generation using single microsoft report viewer control[^]

If Crystal, see: Single Crystal Report Viewer for All Report Web Appln C#[^]

Posted 28-Mar-13 19:54pm

Sandeep Mewara

Comments

Menon Santosh 29-Mar-13 2:00am

nice solution

sariqkhan 29-Mar-13 4:44am

sandeep sir. in that two article where i can write the query?? is there any option that i can change the query?

Sandeep Mewara 29-Mar-13 4:51am

If you really need it then for SSRS, you can define query using expressions. Easy would be to have two reports with static query and design - show the report as per need.

sariqkhan 29-Mar-13 5:22am

sir i am using the windows form, not the webform and sir the query will be of depend on month so i dont want to make total 12 reports for each and every month

Sandeep Mewara 29-Mar-13 5:25am

Then look for 'query via expressions in SSRS'

BTW, if everything (data columns) remain same and just the month changes, then that can be one parameter to one SQL query and one report. Why multiple query or report?
Just have a paramter (in where clause), pass that at runtime and show the data returned.

sariqkhan 29-Mar-13 5:51am

is there any parameter option in SRSS??? i thought that will be only in crystal reports/

sariqkhan 29-Mar-13 5:45am

is there any parameter option in SRSS???
i thought that will be only in crystal reports/

Sandeep Mewara 29-Mar-13 6:08am

Yes, parameters are there in SSRS too.
See my previous answer to another post on it: http://www.codeproject.com/Answers/566259/Parameter-usage-in-report-viewer.aspx#answer1

For more, look here: http://www.codeproject.com/search.aspx?q=ssrs+parameter&x=0&y=0&sbo=qa&usfc=false

Deenuji 29-Mar-13 9:25am

pls give some idea for my posted question

http://www.codeproject.com/Questions/569601/howplustopluscreateplusallocationplusandplusinputp

Menon Santosh · Answer 2 · 2013-03-28T19:44:00

Solution 1

you need some basic of creating crystal report so first go through the following article

Creating Crystal Reports using C# with Datasets[^]

Posted 28-Mar-13 19:44pm

Menon Santosh

Comments

sariqkhan 29-Mar-13 4:42am

sir. what is this. in that article??
DBConnection DBConn = new DBConnection();
OleDbDataAdapter myDataAdapter = DBConn.getDataFromDB();

Menon Santosh 29-Mar-13 5:43am

DBConnection is a class, and getDataFromDB is a function which return dataadapter, you better download the code to understand it well