Hard Code a Column

Hai,
I am trying to use a Union to generate my report. I would like to use a column hard coded to certain value to identify the rows that were generated by different query of the Union. Is there any other way to distinguish the rows generated by different queries of the union.

Any Suggestions would be great help.

Thank You.
Radhika


Listserv Archives (BOB member since 2002-06-25)

Radhika,

Create User Objects from the query panel that contain constant values and use them in your queries. For example, you could create a User Object called ‘Q1 Label’ that is defined simply as the literal string value “QUERY1”. Then create a User Object called ‘Q2 Label’ that is “QUERY2”. Drag Q1 Label into your first query and Q2 Label into your second query.


Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

Hai,
I am trying to use a Union to generate my report. I would like to use a column hard coded to certain value to identify the rows that were generated by different query of the Union. Is there any other way to distinguish the rows generated by different queries of the union.

Any Suggestions would be great help.


Listserv Archives (BOB member since 2002-06-25)

There is currently no other way to distinguish one select in a union from another.

Best Regards,

Andrew J. Erthal

Post Sales Consultant - Central
Business Objects Americas
aerthal@businessobjects.com
Chicago Office (847) 391-9898
St. Louis Office (314) 209-1994
St. Louis Fax (314) 209-7926

From: Radhika Mandava [SMTP:radhika.mandava@WCOM.COM]

Hai,
I am trying to use a Union to generate my report. I would like to use a column hard coded to certain value to identify the rows that were generated by different query of the Union. Is there any other way to distinguish the rows generated by different queries of the union.


Listserv Archives (BOB member since 2002-06-25)