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