Dataset column name changing.

bluespud

I am using a dataset which is selecting from a DB View. The DB view is collating data from a number of tables.

I can see, via dataset/output-columns that the output colmn names are as per the view, e.g. customer_name, product_name, depot_name.

I then add a table to the BODY, using the dataset (by dragging the data set, and all is well.

However after working on the layout of the table, adding a few tots, a bit of formatting, the column names begin to revert to their original table names. For example, instead of customer_name, product_name, depot_name, I get name_30, name_7, name_12 etc. In addition, some of the display names dissapear too.

This effectivly kills the report as fiels 'custromer_name' etc cant be found. I have started from scratch again, rebooted the PC, but no joy.

Any ideas as to what is going on?

>>UPDATE<<
The column names go wonky when I add parameres to the SQL.
select *
from myView
where fld >= param1
and fld <= param2

Param1 and 2 are report parameters. I have a similar setup in a different report and it works fine.
This behaviour is reproducable, all the time. **** soon as I add the parameters, the names change. I can replace the use of paramerets with dataset filters but there is a performance hit.

elmatador

I've had this before. You need to flush the binding from your table, re-bind it, and then drag the columns on fresh.

It's a BIRTism, and there are many :-(