Basics HELP

[dat789]

Hi
New to PRD.

I've got my query working that yields 4 columns -- o, r, d, total.
I dragged each to the Details canvas. Wow, I got
o1 12 "description etc" 45
o1 15 "description etc" 69
o1 23 "description etc" 147
o1 25 "description etc" 12
o1 31 "description etc" 9

Cool. I wish to have header for each of the column. Dragged a text-field and name them accordingly. Preview. Nothing... no headers. The details are there. Help.
Also, for the first first, how do you make it so that o1 appears only 1 time?

Looking forward to hear from. Many thanks!

[TomS]

Hi,

did you assign a "Name" Attribute to the text-fields or a value? Sounds like you assigned the wrong attribute..

Plus: Make sure you have your elements in the header section and not in the "Details" band and they should not overlap each other (HTML output has problems with that)

Cheers,

Tom

[Taqua]

Have you had a look at the Tutorial videos? (Yes, they are well hidden.)

http://sandbox.pentaho.com/2011/08/comprehensive-report-designer-tutorial/


Text-fields are used to display the contents of a field of your database. Usually you want to have "Labels" instead, as labels are meant to display some static text. Put these labels into your group-header.

[dat789]

Cool! Wow! This one works -- using labels.

OK. Now, how about the other item where I asked if it is possible to just make 'o1' appear one time but others will display as normal in their respective row? For example
+------------------+----------+----------+--------+
| o | r | d | total |
+------------------+----------+----------+--------+
o1 | 12 |description| 45 |
----------------------------------------------------
| 15 |description| 69 |
----------------------------------------------------
...
and so on...

Any tips? Thanks!

[dat789]

Guy,
I think at this stage it'd be best for me to mess about the Report Wizard. I got what I was looking for, well, similar. So, thanks @Taqua for the unhiding the well hidden PRD videos.
cheers!

[Taqua]

Making fields only print changed values:

Attributes-Table: Wizard::Show-Changes to "true" and you are there.

[dat789]

Thank you Chief!
This is also very helpful! :) made me smile!