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.-

View Entire Topic
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

.