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

Can you use Global Constants in Report Studio

Started by jaymoore1756, 12 Sep 2013 11:28:46 AM

Previous topic - Next topic

jaymoore1756

I have a file that contains information that will be used in creation of letters in Report Studio. The file contains information such as field1  - general manager field2 Joe Smith. The field gets placed in the letter like this
Respectfully
<field2>
<field1>

So when the GM changes then they change the file once the name changes on the letter. This eliminates hard coding in the letters. The issue with the file is that it does not link to anything in the database. Does report studio have the ability to use Global Constants ?

blom0344

Use one report template to store the info. Use component layout references pointing to this report template and changing the template will automatically change the related reports.  We use this for defining header/footers. If a customer wants different logo's etc we only have to change it in the template

jaymoore1756

I set up a footer in the template and I brought the title and the name into the report template and it runs and give me the value I expect. But when I add the layout references to the letter, I get the error item not included in query 1. What am I doing wrong ?

blom0344

I presumed that you did not need any information fetched from a query (as data was not linked to anything in the database) So adding a constant value (report expression) within a layout component would act as a type of constant. Associated queries will not work AFAIK by using references.

jaymoore1756

Sorry I was not clear in how the data was presented. I have tried the fetching the query but it does not work. I was able to create report references and pull them in using the conditional layout tool. So you advice was helpful. I appreciate it.