DataGridview Data(Not From DataBase) to Crystal Reports

Question

1.00/5 (1 vote)

See more:

The Issue Is I want to
Fill the Data in DataGridView
Manually .
and on Button CLick Want to send the data
to Crystal Reports.
I have Done the Process of filling the
DataGridView manually,
But Is Stuck in How to send The Data Of DataGridView
to Crystal Reports.

Have Done Similar Operations in Case of Text Boxes.In which
I have Used Parameter Fields.

I It possible to Send the DataGridView Column Data
To crystal Reports Using parameter Fields,
if Yes.
Please Assist.

Posted 29-Aug-12 3:24am

Karwa_Vivek

Updated 15-Mar-17 9:20am

v2

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)

Kschuler · Answer 1 · 2012-08-29T11:26:00

You don't pass a DataGridView object into a Crystal Report, you instead pass a DataSet object (which can be bound to the DataGridView if you like).

You'll need to design your crystal report with XML Schema that matches the schema of your DataSet object.

Here[^] is one example. And here[^] is a tutorial I found on google. I'm sure you can find other examples and tutorials on CodeProject too.

Hope this helps.

Andrew Alix · Answer 2 · 2012-08-31T07:50:00

Assuming you have created and filled your dataset using the following:
dim ds as new reportDataset 'replace reportDataset with the Name of your Dataset
If you look at a question I asked "Cannot get Crystal Reports vb.net 2008 to display data." you will see how I did it. This works, by the way. I made a stupid mistake that I didn't see until answering your question.

I found it easier to instantiat a report object (objRpt) and put the report in a CrystalReportViewer, than declare a Report Document.
After filling the DataSet with your data add the following code:

VB

'Assuming you have created and filled your dataset using the following:

dim ds as new reportDataset 'replace reportDataset with the Name of your Dataset

'If you look at a question I asked, "Cannot get Crystal Reports vb.net 2008 to display data", you will see how I did it. This code works, by the way. I made a stupid mistake that I didn't see until answering your question.

'I found it easier to instantiate a report object (objRpt) and put the report in a CrystalReportViewer, than declaring a Report Document.

'After filling the DataSet with your data add the following code:

Dim objRpt As New rptSchedule 'Replace rptSchedule with name of your report
objRpt.SetDataSource(ds) 'ds = the DataSet object you created
CrystalReportViewer1.ReportSource = objRpt 'Set the report source
CrystalReportViewer1.Refresh() 'Refresh the report.

DataGridview Data(Not From DataBase) to Crystal Reports

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0