How to show data in two crystal report from two different tables in asp.net?

Question

0.00/5 (No votes)

See more:

, +

I'm working with vs2010 and sqlserver 2008 and i have installed sap srystal report now i have to create two different crystal report from two different tables of same database only one table in one report and another table in another report can any one help me plz?

Posted 26-Jan-14 1:27am

Member 10550190

Add a Solution

Comments

JoCodes 26-Jan-14 9:16am

Can you tell where are you stuck? It seems not much a complicated scenario

thatraja 27-Jan-14 3:31am

Confusing. Explain clearly.

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)

JoCodes · Answer 1 · 2014-01-26T03:41:00

Not sure exactly what you are looking for.

But if its 2 different table ( without any relation ) and 2 different Reports then simply use 2 different SqlAdapter with separate StoredProcedure and fill to Different Datatables.
These two DataTables can be in a single Dataset and can be accessed separately to serve specific Reports .

Something like

SqlDataAdapter adptr1 = new SqlDataAdapter("sp1",connection);
SqlDataAdapter adptr2 = new SqlDataAdapter("sp2",connection);
DataSet dataset = new DataSet();
adptr1.Fill(dataset, "Table1");
adptr2.Fill(dataset, "Table2");

//Can be accessed like
dataset.Tables["Table1"] // for report 1
dataset.Tables["Table2"]//for report 2

Above approach is based on your need but can be done with different ways too.

Please specify if anything else your requirement is.