Report: same

Hi There

We created a report from an Informix database stored procedure (with parameters). When we execute the stored procedure in the data page, it returns correct result set with column headings blank. In the datasets page, the field names are: ID, ID_1, ID_2, …

When I preview a report created from the dataset, all the fields shows the same value as field1 (ID). I have no idea on what happened, why it happened, and how to resolve it? Could you please help?

Thanks in advance.

Jane

It's been awhile since I have run into this, so apologies if this isn't exactly right. I believe this occurs when Reporting Services can't get the column metadata from the database, or when all the columns have the same base name (the table.column name may be unique, but the column name is not). So the mapping of values to columns doesn't work correctly.

The workaround for us was to make sure the database query aliased all columns to a unique name.

|||

Thanks for your reply.

You are right, our problem is Reporting Services can't get the column metadata from the stored procedure return result. In the data page, we select Text, and type:

execute procedure proc_name (?)

Because we use stored procedures instead of queries, not sure how to set the column names. Any ideas? Thanks a lot.

Cheers

Jane