Exactly HOW would one go about creating a constant for a report?

Do you create it in the code section of the report Properties? IF so, how? If you don't do it there where do you do it?

I have an image in the page header, but I don't want it to repeat after the first page. And there are two images actually, and the one that is chosen for display is based upon a company id.

How do you control that?

[363 byte] By [Mainiac007] at [2007-12-24]
# 1
You can control the visiblity state of the image based on the Page Number, e.g. set the hidden property to =IIF(Globals!PageNumber = 1, false, true).
FangWang-MSFT at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2

i have a question for you before answering your question. i did have the same situation...

what is the image source..., whether it is from database, embedded or url .....

since you cannot access dataset in page header, i do not how you are managing to display the image based upon on company id.

what i have done is i have a subreport. in that subreport i am getting the image from db and displaying based upon company id parameter.

the same thing i placed it in main report and pass the company id as parameter... based upon the company id, it displays respective company logo.

regarding displaying it only first page or not, i use the global variables like pagenumber to play with....

hope u got what u want

sureshbabukrishnappa at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3
what you described is what I ended up doing. I actually have the image (gif) in the project in a table header, it takes up two rows, one for each image, and which one is displayed is dependent on the company id.
Mainiac007 at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 4
still my question is: whatis the process for creating a constant for a report? Do you do it through custom code?
Mainiac007 at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified