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 |
|
ramya.k
Starting Member
4 Posts |
 Posted - 2009-02-11 : 06:26:40
|
| Hi,I need to refer to db fields in my page header. I used hidden text boxes in body and referred to them thru ReportItems(textbox1.value)in page header.But when i download to PDF/Excel format,the header contents are not showing up.So tried using another way to achieve this:Using hidden parameters,by capturing the db field values in them and referring to them in header thruParameters!param1.value.But facing the error " The 'param1' parameter is missing a value".I gave the default values also..but still getting the same error when i go to Preview tab.Has anyone faced this issue? pls guide me on how to overcome it.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-11 : 09:19:21
|
| whats the datatype of param1? also does default value you gave for it exists among the values of dataset you assigned it to? |
 |
|
|
ramya.k
Starting Member
4 Posts |
Posted - 2009-02-11 : 22:48:43
|
quote:
Originally posted by visakh16
whats the datatype of param1? also does default value you gave for it exists among the values of dataset you assigned it to?
Hi,Thanks for the reply.it is of String datatype. I tried by assigning default values from dataset,by manually giving a hardcoded value and also assigning null value.But nothing worked.Getting the same error. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-12 : 11:13:12
|
| nope. you're getting this error means the value given is not correct. just remove current dataset from parameter tab and hardcode a value and see if it works |
|
|
|
ramya.k
Starting Member
4 Posts |
Posted - 2009-02-12 : 22:52:40
|
quote:
Originally posted by visakh16
nope. you're getting this error means the value given is not correct. just remove current dataset from parameter tab and hardcode a value and see if it works
Hiusing hard coded values also did not work..the same error shows up.Pls help me solve this problem.Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 01:31:27
|
| are you using value in same way as its stored in your table? |
|
|
|
|
|
|
"The 'param1' parameter is missing a value" Error