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.
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.
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.
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
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.