If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Changing a page list to point to new query

Started by Anke, 15 Dec 2010 03:04:08 PM

Previous topic - Next topic

Anke

I have a report with several joins in it, the report output page is a list.  I have created several new queries and joins and would like for the list to point to a different query.  I found in the List (under ancestor) to point to a new query, but the data items still show the old query. 

Since I have just created new joins and the data items are the same, isn't there some way to not only change the list query to a new query, but also have the items to point to the new query?

Example.  [query1].employeeName  table is now joined to another table, so I change the list to point to the new query created by the join [finalqry].  In the list, the employee still shows the [query1] schema.  I would like to have the data item say [finalqry].employeeName, without having delete and move to the list again. 

The reason is, the list on my report has extensive conditional formating on each item, and I don't want to have to redo everything and suck up a bunch of time, if there is a way to simply point to the 'new' query.

Thanks!
Anke   :)

kattaviz

Hi,
Try replacing the [query1] with [finalqry] in the report specification XML if it is hte only change.

HTH
thanks & regards
Satish Katta

Anke

Thanks for the suggestion.  Really,  I was trying to find a way to do this throught the interface.  There are several joins from the orginal qry1 to the final one, so there will be new fields output on the new final list.
I really thought I was able to do this is the past, but it was many dead braincells ago, and they are long gone or deleted  :-\
  Any other suggestions??? 

Oh, I just have so much formatting on the list, text flow and lots of conditional formatting, guess I had better get a start on the rework, just sucks to have to burn up a bunch of time on this :(

Thanks!!
Anke