Wednesday, March 28, 2012
Report deployment with RS2k, SP1
I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
have only hidden parameters (parameters with a prompt blank).
When I deploy from VS. NET 2003 to an empty folder on my RS server, the
prompts reappear and the checkbox "prompt user" is unchecked. That means
read only parameters and my reports return an error. The only way to correct
that is to manualy change the checkbox.
After the first deployment, each time I deploy the same reports (I replace
the existing), the checks stay but the prompt reappear. I have 15 reports
with 5-10 parameters on 3 environments (dev, qa, prod) and after each
deployment, I have to manualy remove the prompt..... I get crazy....
If someone have some experience with that problem or a workaround, don't
hesitate...
Thanks in adavance
LaurentHi,
have you tried rs.CreateReport with overwrite properties so that you can
overwrite all the parameter and report properties..
when i do upgrade i use this property to overwrite report in the script..
Bava
"Laurent" wrote:
> Hello,
> I have a problem with report's deployment (SQL 2k, RS SP1). All my reports
> have only hidden parameters (parameters with a prompt blank).
> When I deploy from VS. NET 2003 to an empty folder on my RS server, the
> prompts reappear and the checkbox "prompt user" is unchecked. That means
> read only parameters and my reports return an error. The only way to correct
> that is to manualy change the checkbox.
> After the first deployment, each time I deploy the same reports (I replace
> the existing), the checks stay but the prompt reappear. I have 15 reports
> with 5-10 parameters on 3 environments (dev, qa, prod) and after each
> deployment, I have to manualy remove the prompt..... I get crazy....
> If someone have some experience with that problem or a workaround, don't
> hesitate...
> Thanks in adavance
> Laurent
>
>sql
Wednesday, March 21, 2012
Report Builder Parameter List empty
After building a report in report builder, I've set on of the filters to prompt for user input "in this list". When I run the report I get a drop down list with nothing in it. I can manually type in a value an run the report but I'd like to be able to select the parameter from the list.
I've also tried clicking on (no values selected) and selected all the available values...however this gives me the same results.
I also have the same problem...and have been searching for an answer...I know we fixed this or had a solution for this last year...and it may have something to do with the existing cardinalities in the Roles in the model...
But I'm still looking and trying to find a definite answer....
Tuesday, March 20, 2012
Report Builder Filter Prompt...
Is there a way to pass a NULL to a filter prompt in report builder much like in report designer where it allows you to check or uncheck the NULL checkbox?
Thanks.
Report Builder only enables the NULL checkbox for a report parameter if the corresponding field can have NULL values (according to the Attribute.Nullable property in the report model). Are you seeing different behavior?|||This answered my questions. Thanks.Monday, March 12, 2012
Report Builder Date Range Filter
prompt for input. Why is this? Is there a fix for it.
I can replicate the required functionality by using On or Before and On
or After but it seems a bit messy.
Regards
TobiThis is a known issue and is under consideration to be fixed in a future
release.
"Tobi" wrote:
> When selecting From To date range filter you can no longer choose
> prompt for input. Why is this? Is there a fix for it.
> I can replicate the required functionality by using On or Before and On
> or After but it seems a bit messy.
> Regards
> Tobi
>
Saturday, February 25, 2012
report authentication: windows prompt removal
Hello,
I'm writing a small program to access reports on a remote server. When simply accessing the server, using the reportviewer, I get a windows prompt for login. I would like to avoid this by passing the account information.
How should I do this? (Maybe through network credentials)
Could someone send me some example code?
Thank you.
Jos
i'm not sure but i think you mean that you want to acces it through internet explorer?
if that's the case , demanding the credentials depends on the zone your page is in
see internet explorer>extra>internet options>security
by default internet explorer demands credentials for public sites and uses integrated login for intranet, that i wouldn't change
the clue is that any address with a dot . (be it in an ip or dns notation, eg 10.2.54.56 or webserver.domain.local) is regarded by default as a public address
so either you add the adress in the intranet zone or you change the adress in wins notation style ( eg //webserver/reports)
|||Well I want to access the reports through a small asp.net program. You may see the source code in http://www.odetocode.com/Articles/95.aspx
When I access my reportserver (http://sqlreport244_9.mysite4now.com/reportserver) I get prompted for a windows login.
What I would like to do is to set the credentials on the code of the asp.net program to avoid being shown the prompt. This program will be used by several users and don't want them to have to insert the password each time they access the reports.
Thanks