How can show tow record on the one crystal report?

Question

0.00/5 (No votes)

See more:

please kindly tell me how can show more then one record on one crystal report as examples bellow

if there is a database tow rows below

HTML

name      class        fees
ali       10th          100
john      9th           80

and in crystal report

HTML

Name    ali                                  Name     john
Class   10th                                 Class    9th
Fees     100                                 Fees      80

please kindly i want to show as above examples please help me

Posted 7-Feb-12 23:04pm

irfanansari

Updated 8-Feb-12 2:51am

Anuja Pawar Indore

v2

Add a Solution

Comments

Ravi Tuvar 8-Feb-12 6:57am

hi irfan,

first you have to listset the fields you want to show in detail section and then follow this steps..

a) Right click on top of "Section3 (Details)" on the report, select "Section Expert..."

b) On "Section Expert" window (the "Details" section is already highlighted) untik all the checkboxes on "Common" tab

c) Tick the "Keep Together" checkbox and "Format with Multiple Columns",

once you tick the "Format with Multiple Columns", a new tab as "Layout" is displayed

d) Click on the "Layout" tab and set the "Width" for "Detail Size:" (in my case 0.950) and

set the "Vertical" for "Gap Between Details:" (in my case 0.100)

e) select the "Accross then Down" radio button from "Printing Direction:" and click on the "OK" button....

i hope it will work fine...

Tech Code Freak 8-Feb-12 8:51am

Post your answer in the Solution form and not as a comment. Type it in Add a Solution below.

Anuja Pawar Indore 8-Feb-12 8:55am

Added pre tag

3 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)

Manoj Kumar Choubey · Answer 1 · 2012-02-08T02:43:00

Solution 2

Search Pivot or Cross reporting

http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx[^]

Posted 8-Feb-12 2:43am

Manoj Kumar Choubey

Comments

thatraja 8-Feb-12 9:29am

Good call, 5!

Mantu Singh · Answer 2 · 2012-02-08T00:24:00

Solution 1

you may try using group by clause when creating connection for crystal report and use like below in report

[Name][dbfild]
[Class ][dbfild]
[Fees ][dbfild]

in report details section

Best of luck........

Posted 8-Feb-12 0:24am

Mantu Singh

Sanjay K. Gupta · Answer 3 · 2012-02-08T02:48:00

Solution 3

Use subreports

You can learn about from the net.

Posted 8-Feb-12 2:48am

Sanjay K. Gupta