Inserting DataGrid to a particular section in crystal report VS2010

Question

1.00/5 (1 vote)

See more:

VS2010

, +

My database consist of 5 rows where each row consist of students register for subjects.
Following is my database design :

HTML

Name		|USN	|SubCode  |Test1  |Test2  |Sum	
StudentName 	 001	 Sub001	   27 	    35     62 
StudentName 	 001	 Sub002	   28 	    30     58
StudentName 	 001	 Sub003	   35 	    35     70
StudentName 	 001	 Sub004	   30 	    35     65
StudentName 	 001	 Sub005	   33 	    27     50

From the above table, as studentname and USN is common, i just need an instance of those
data and I want Subcode, Test1, Test2 and Sum column to be displayed in a particular
section of crystal report in a datagrid view format. Is this possible?

Posted 17-Jun-15 9:10am

partha143

Add a Solution

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)

Sinisa Hajnal · Answer 1 · 2015-06-17T20:40:00

Solution 1

You can create a dataset (using dataset component in VS). Add that dataset to crystal report. In design mode for the report, drag and drop said data wherever you want.

Now all you have to do is create the instance of the report in code and pass it real dataset with your data.

You can easily find the details googling.

Posted 17-Jun-15 20:40pm

Sinisa Hajnal

Updated 17-Jun-15 20:43pm

v3

Comments

partha143 19-Jun-15 11:43am

Sinisa, thank you for your reply. I have already successfully implemented what you have suggested. My question is how can I pass a all contents of datatable/dataset/datagrid to a particular section in Crystal Report? I want to achieve this as I am developing marks card for my college where I am passing subjectcode,test1,test2 and sum to my report with either datatable/dataset/datagrid and I am passing respective Name and USN individually to the same report.

Sinisa Hajnal 19-Jun-15 15:11pm

Well, dataset can contain multiple tables so you could pass it into report and use one part in group header, another in page header and yet third in details.

Or you could create subreport (this is the only way to have details of details item) - subreport behaves in all ways as normal report (has name, datasource, headers, details, other sections, etc) - it is simply embedded in the master report at some point.

Does that help?

partha143 20-Jun-15 1:04am

Sinisa, could you please share any of the example code for the 1st solution you have provided in above comment (dataset can contain multiple tables so you could pass it into report and use one part in group header, another in page header and yet third in details.). I guess this solution will solve my problem. Thank you

Sinisa Hajnal 20-Jun-15 3:52am

Unfortunately, I can't. This is not dependant on the code. You have to create a dataset in VS designer (you can simpy drag stored procedure from the datasource). You can find the description of the procedure online. However, very important thing is to NAME THE TABLES. Then before you assign the datasource in code, you name the tables in your dataset the same (case SENSITIVE).

When you create that datasource, open the report in designer and add that datasource component as datasource. You will see all the tables of that datasource available - it's just a matter of placing the data where you want it.

As it is designer based and I don't have the tools at home, I cannot even show you screenshots. But there are examples online now that you know what to look for.

Good luck.