all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Web Service Default Values


Web Service Default Values AG
6/28/2005 7:16:03 PM
sql server reporting services: I have a web service report viewer control that I use to display reports to
end users and have a slight problem with the datetime types and default
values. Basically, I have a report that has a from and to date. The
question is when I make the web service call to return parameters I am
noticing that the DefaultValues string array is not null (returns
system.string[]), but the DefaultValue[0] is null (for the date fields). Is
this a bug. Bottomline is that I specify the date fields to have default
dates (when adding report params in visual studio.net), but no values are
displayed when accessing via the web service api's. I have installed SP2 and
RE: Web Service Default Values Aaron Williams
7/5/2005 11:57:03 AM
Did anyone find a solution for this problem? I'm having the same issue.

[quoted text, click to view]
Re: Web Service Default Values Dan Christjohn
7/5/2005 1:13:17 PM
This may or may not be related, however, once you upload a report to the
report server you can modify the parameters via the report server interface.
Personally I was having an issue where I wanted to pass parameters in the
URL but didn't want to show the parameter fields to the user when the report
was actually displayed. It seems that with RS SP1 or greater if you check
'Prompt User' but leave the 'Prompt String' blank (this is via report server
editting a report and looking at the parameters tab) then you can use and
pass parameters without displaying the actual parameter fields to the user.

Just thinking that playing with the Prompt String and the Prompt User might
display the default data you are looking for.

Good luck and sorry if this didn't really help.

Peace,

Dan


[quoted text, click to view]

RE: Web Service Default Values AG
7/5/2005 6:32:02 PM
Ok, I figured out with the help of a friend (no love from the microsoft guys
;) )
Basically, there is a slight bug when deploying reports etc. To solve the
problem
go to the web interface and delete the report. Go to VS.net and ensure your
defaults etc are in place then redeploy. You will see the default values as
expected on the web interface Apparently the RDL must get cached or
corrupted. Regardless this will solve the problem.

[quoted text, click to view]
AddThis Social Bookmark Button