Hi,
I have a page P, the data used in it is from Query C.
Query C is a join of Query A and B. Works fine.
Now I want to expand this page with some extra columns, so I join Query C with Query D.
Query D has now all the data I need on page P.
Page P has a quite complex layout (coloring, etc) and is large (many columns).
How can I easily add the columns from Query D into the existing Page P?
Kind regargds.
Thanks in advance.
Quote from: WFBangert on 20 Dec 2023 04:47:56 AMHi,
I have a page P, the data used in it is from Query C.
Query C is a join of Query A and B. Works fine.
Now I want to expand this page with some extra columns, so I join Query C with Query D.
Query D has now all the data I need on page P.
Page P has a quite complex layout (coloring, etc) and is large (many columns).
How can I easily add the columns from Query D into the existing Page P?
Kind regargds.
Thanks in advance.
I would use a slightly different approach. Join your data from D into the mix with either queries A or B, then the final query (that feeds the report objects on your page) will remain as C, and there will be no re-work of what you have already created on the page.
Cheers!
MF.
Thanks for your suggestion, I tried a while ago, but didn't work, but maybe I didn't do it the right way.
After the holidays I will try this again.
Kind regards
Freek
Quote from: WFBangert on 21 Dec 2023 02:50:07 AMThanks for your suggestion, I tried a while ago, but didn't work, but maybe I didn't do it the right way.
After the holidays I will try this again.
Kind regards
Freek
When you try it, post up any questions or issues - we'll help if we can.
Cheers!
MF.
Hi,
I've tried your suggestion, but by doing that, the queries are renamed, by me or by Cognos.
I didn't succeed in keeping the query name C intact....
Is there a kind of procedure, standard way of doing this?
Thanks in advance,
Kind regards,
Freek
I have build the page again, thanks for your answers.
I close this topic.
Kind regards.
Freek
Thanks for your suggestion, I tried a while ago, but didn't work, but maybe I didn't do it the right way.
After the holidays I will try this again.
Kind regards
Freek