Crosstab or Change SQL

rbuser

Hi Guys,
I have to rebuild an report which was create with crystal reports.
I use the same sql which is use in Crystal.
SQL Result:
ID_Personal Date abbreviation absent day
37 01.01.2012 We
37 02.01.2012 Work HOL
37 03.01.2012 Work HOL
37 04.01.2012 Work
37 05.01.2012 Work
37 06.01.2012 Work
37 07.01.2012 We
37 08.01.2012 We
....
37 31.01.2012 We

Look in Report Builder should be:
37 01 02 03 04 05 06 07 08
37 We Work Work Work Work work We We
37 Hol Hol

In Crystal was use an Crosstab to solf this problem.
But I never used a crosstab before.
How can I solf this problem with Report builder?

nicocizik

Hi David,

You should be able to recreate this using the Crosstab feature in
ReportBuilder. Take a look at the crosstab demos located in the
\Demos\Crosstab\... directory for some good examples of what can be
accomplished.

rbuser

Hi Nico,
now my crosstab is in the correct form, but some problems are still
existing.
Look of crosstab:
Date
Data 01.01.2012 02.01.2012 03.01.2012 04.01.2012
Count of 1 1 1 1
shortcut
Count of 1 1
missing day
count of 1
holiday

Now my problems:
1. How can I make the text "Data", "Count of shortcut", or any other
text invisible?
2. The crosstab fills the colums correctly, but not with my value, but
with an one.

rbuser

Am 12.03.2012 13:57, schrieb David Wolf:

I've got an solution for this problem. I changed the color to white. Is
this the only opportunity ?

Also I've got two questions more.
3. How can I make the with/ hight of a column smaller?

nicocizik

Hi David,

1. You can also use the crosstab events to alter the cell values. See
the demos I mentioned in my previous post.

2. The crosstab component is simply counting the records related to the
field you selected. This is likely a SQL issue. As a test, try
creating a simpler crosstab and showing the count of a single field.

3. The height and width of the columns/rows are determined by the text
and font that needs to be displayed. There is currently no manual way
to adjust this.