crystal report c#

Question

0.00/5 (No votes)

See more:

Hi experts,

Thanks for viewing. I am facing some problems.

I am using followings to generate report:

OleDbConnection DBConn = new OleDbConnection("provider = microsoft.jet.oledb.4.0;" + "data source=" + Form1.path);
            OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(strSQL2, DBConn);
            DataSet dataReport = new DataSet();
            myDataAdapter.Fill(dataReport, "wtdetail");
            Weighmet1 myDataReport = new Weighmet1();

            myDataReport.SetDataSource(dataReport);
            crystalReportViewer1.ReportSource = myDataReport;

Here "strSQL2" is like this "select field1,field2, field3 as ABC from ...". in my designer I have inserted all fields suppose field1,field2,field3. all fields are displayed OK except field3 which has the alias name "ABC".

any help please.

- anil kumar bhakta

Posted 20-Oct-10 6:39am

anil_kumar_bhakta

Updated 20-Oct-10 22:04pm

Dalek Dave

v4

Add a Solution

Comments

Abhinav S 20-Oct-10 12:49pm

Sorry but this is too little information provided. How do you populate your crystal report? Make sure the value is included in your query.

Dalek Dave 21-Oct-10 4:04am

Edited for Code Blocks and Readability.

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)

Sandeep Mewara · Answer 1 · 2010-10-20T06:52:00

Solution 1

Well, did you made the query change? Add the new field in the query such that the data is returned. Then refresh your dataset in your report (if it has already defined fixed data expected).
Once you get the new field in the dataset that you must be binding with Crystal report, drag-drop/use it in your report for display.

Posted 20-Oct-10 6:52am

Sandeep Mewara

Comments

anil_kumar_bhakta 20-Oct-10 13:47pm

thanks. i have trace out the exact problem. actually my "select statement" is as below: -
"select field1,field2, field3 as ABC ....". in my report designer the field "field3" appears but data of this is not showing.