cancel
Showing results for 
Search instead for 
Did you mean: 

Need to fill to the right instead of underneath

Former Member
0 Kudos

Hello:

I am new at Crystal Reports (use version XI). It's kind of difficult to me to explain what I need to do, so I'm putting an example to be more clear.

Currently I have:

Student

Grade 1

Grade 2

Grade 3

Student

Grade 1

Grade 2

Grade 3

Student

Grade 1

Grade 2

Grade 3

, the students's names are inserted in the DB before (using Visual Basic).

I need my report to be like this:

Student Student Student

Grade 1 Grade 1 Grade 1

Grade 2 Grade 2 Grade 2

Grade 3 Grade 3 Grade 3

Is this possible? How?

Thank you so much

Isaac.-

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

As per your requirement, you need the report in following format:

Student Student Student

Grade 1 Grade 1 Grade 1

Grade 2 Grade 2 Grade 2

Grade 3 Grade 3 Grade 3

For getting this format, the easiest way would be to use " CroosTab" report.

However since it requires 3 different columns for creating crosstab report, yoo can add one more temp column to database (say temp). Now create your cross tab report such that :

Temp--->Row

Student Name---->Column

Summarised Field---->Max of Grade

Once your report is created, suppress the Total and Row field. So what you will get is your required output.

Regards,

Chinmay

Former Member
0 Kudos

Hello:

I am trying to create a cross tab report as you told me, but I can only insert the cross-tab at the header of the report or at the footer, and I need to insert the tab at the detail section. How can I do this?

Thanks

Isaac.-

Former Member
0 Kudos

Kachro, you can not put a cross tab in a detail section. You could add a group, and put it in the group header or footer.

Another option, is to not use the cross tab at all.

Go to Section Expert

Select your details section

Near the bottom you will see, format with multiple columns,

check that box,

You should see a new tab at the top called layout

click that tab

You can set the width of your section there. ie... ( if your fields take up 1 inch, you can put 1.25 as a width)

Look for Printing Direction, and select Across then down

You can also check format groups with multiple column should you need to.

This should get you started. You may need to adjust field size, etc to get the appearance correct.

Former Member
0 Kudos

what Chinmay1009 apparently is working for me. The only problem I am having now is that I can not delete the total column. How do i do this?

Thank you so much,

Former Member
0 Kudos

Hello Kachro,

Insted of deleting total column, you can hide this total column using 'Supress'.

So use conditional supress or Supress to hide your 'total' column.

Hope this helps.

Regards,

Chinmay Athavale

Former Member
0 Kudos

.

Answers (2)

Answers (2)

Former Member
0 Kudos

I've been trying using cross-tab but the results aren't what I expected:

I know Crystal Reports can do easilly this:

Quote #50

Job Wage Days Worked

Paintor 100000 30

Housekeeper 50000 25

Electrician 25000 30

.

.

.

Now, I need to do this:

Quote #50

Job Paintor House Keeper Electrician

Wage 100000 50000 25000

Days Worked 30 25 30

.

.

.

I know it's kind of a cross-tab, but if I use Max at the Sumarized Field the value that pops is the Maximum of the entire database, and not the one of the Quote #50.

How can I do this?

thanks in advance

isaac.-

Edited by: kachro on Jul 27, 2010 8:32 PM

Former Member
0 Kudos

Hi Isaac,

What field did you apply the 'Max' to? How do you want the report to determine the 'max' value? If 'max' is applied to a field, it will go thru the whole database to find the maximum value, not for or within a specific transaction/quote.

Heather

Former Member
0 Kudos

Hello:

Actually I do not want that to happen, I am just replying to a user that pointed me that above in this same thread. You're right, the values returned are the Maximum of my database, but I need to get the values from a specific quote, not all the DB.

Former Member
0 Kudos

The neatest option is a Cross tab but with Student as the row and grade as the column.and a simple count as you summary. This will yield

Grade 1 Grade 2 Grade 3

Student 1 1 1

Student 1 1 1

Ian