Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2005-03-24 : 17:46:07
|
| I have images(five) stored in a table. I would like to display these images dynamically on the report based on the report parameter that I am going to select.For example, if I select parameter A, image B will be displayed in the header section on the report. If I select parameter X, image D will be displayed in the header section on the reportHow can I do this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-24 : 18:04:45
|
| Have you used RS yet? This is just a simple parameter that you pass to a query, preferably to a stored procedure.Tara |
 |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2005-03-24 : 19:20:08
|
| Can you show me some example? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-24 : 19:22:18
|
| What part do you need help with? Designing the report, writing a stored procedure, how to put the query in the report, etc...? Are you familiar with Reporting Services? Do you know how to write stored procedures that have input parameters?Tara |
|
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2005-03-24 : 19:43:40
|
| Yes, I do familiar with all of the stuff that you mentioned.I have a org table with org codeOrg Code100110021003and image table A.jpg 1001 B.jpg 1002 C.jpg 1003I am trying to display the image in the header section of the report based on the report parameter that I am going to select ( ORG_ID)For example, If I select ORG_Id 1001, A.jpg should be displayed in the header section of the report. May be some example of stored procedure? and designing the report? |
|
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2005-03-25 : 10:57:36
|
| My problem is I can do this in the body section of report,but I can't do this in the header section of report.I am keep getting an error:" The value expression for the image ‘image2’ refers to a field. Fields cannot be used in page headers or footers." |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-03-25 : 11:04:08
|
| use a group header for your page header then. Be sure to set the "repeat on new page" of the group header to True, and it will act just like page header. You can create a dummy group if needed, set the expression for the group equal to =1 or something like that.(this tricks works for Access and crystal as well; most report designer apps don't let you put DB fields in page headers/footers)- Jeff |
|
|
|
|
|
|
|
|
Display image dynamically..