Need to generate Vrystal report with 2 tables.

Question

0.00/5 (No votes)

See more:

Hi All,

Thanks in advance, I'm having some issues in generating sub report from 2 table. i have ask this question in earlier as well, but i didnt get proper answer. Please any one can explain clearly how to accomplish this task. thanks in advance again.

These are my 2 tables,-Cost, Item
COST ITEM
------------------------------- ---------------------------------------
Product_ID Name Weight Piece Product_ID Item Unite_Price Qty type
---------- ----- ------ ----- ---------- ----- ------------ --- ----
001 Chocolate 15g 120 001 choco $12 1.2 R
002 Bread 20g 80 001 milk $15 1.8 R
001 flour $10 2.5 P
002 flour $10 3.5 P
002 east $20 0.8 R
002 bag $10 2.0 R
with these table I need a report like below,
/////////////////////////////////////////////////////////////////////////////////
Product ID-001 Name - Chocolate Weight - 15g Piece - 120
----------------------------------------------------------

Product_ID Item Unite_Price Qty type
---------- ---- ----------- --- ----
001 choco $12 1.2 R -:here with like command I have take
001 milk $15 1.8 R Only "Type like 'R%' "

Product_ID Item Unite_Price Qty type
---------- ---- ----------- --- ----
001 flour $10 2.5 P -:here with like command I have take
Only "Type like 'P%' "
/////////////////////////////////////////////////////////////////////////////////

how can I accomplish this task please any one can help me in this task.
What i did is , I have taken all these as separate dataset with sub reports and try to insert into main report. but subreports are working and generating the values main report is not only generating the headings... please can any one tell me how to do this..

Posted 4-Mar-12 21:14pm

ruzan hizar

Add a Solution

Comments

Prasad_Kulkarni 5-Mar-12 7:39am

its Crystal not Vrystal you might spelled wrongly,

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)

Prasad_Kulkarni · Answer 1 · 2012-03-05T01:41:00

Solution 1

Get some help from these links:
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm[^]
http://highoncoding.com/Articles/556_Creating_Crystal_Report_with_Multiple_Tables_in_ASP_NET.aspx[^]
http://www.youtube.com/watch?v=HiIl7Shir9k[^]

Posted 5-Mar-12 1:41am

Prasad_Kulkarni

Comments

ruzan hizar 6-Mar-12 2:20am

Thanks for the help...but it also not supporting in my case. I'm taking the data from Access database using XML dataset and assigning the dataset to an object. from that object only i'm taking to the report.
here is my code...

DataTable dt = new DataTable();
Class.clsReport rpt = new Cost.Class.clsReport();
dt = rpt.GenerateMainReport(Pcode);

DataSet ds = new dsReport();
foreach (DataRow dr in dt.Rows)
{
ds.Tables["mainReport"].ImportRow(dr);
}
Report.MainReport objMain = new MainReport();
objMain.SetDataSource(ds);

crvMain.ReportSource = objMain;
crvMain.Refresh();
--------------------------------------------------------------------
public DataTable GenerateMainReport(string Pcode)
{
DataTable ds = new DataTable();
try
{
string sqlStr = "SELECT * FROM tblCost WHERE Product_Code = '" + Pcode + "'";

con = new OleDbConnection(clsConnection.connect);
con.Open();

da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand(sqlStr, con);
da.SelectCommand.ExecuteNonQuery();
da.Fill(ds);
return ds;
}
catch (Exception ee)
{
throw ee;
return ds;
}
}
Please any one can check this codes and let me know if any other easy ways to do this task... because i'm new to c#...
Thanks.