Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Parameter default won't delete.


Parameter default won't delete.

Author
Message
TimParker
TimParker
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 132
I have a couple of reports that have start and end date parameters. I had thought about putting a default on them for the start date. Since most of our reports start with 1/1. But then changed my mind. Now when I go back to remove the default. It stays. Angry

1. I have tried, deleting the default, then setting it to no default and re-saving my report.
2. I have tried, just setting it to no default and re-saving the report.
3. I have also deleted the parameters, saved and then re-added with no default, saved. But the defaults are still there when I look at properties.

I am not catching on to what is happening. If I run the report (I am using report builder 2) it looks fine, but as soon as I reload the report the default is back.
Gazareth
Gazareth
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2863 Visits: 5331
Hi Tim,
As I understand it, you're editing the defaults in Report Builder only?
If you edit the parameters in Report Manager directly the change should stick.

Cheers
TimParker
TimParker
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 132
Thank you, I don't understand the logic there, but it appears to have fixed my "problem."

I would think that if I go back to where I bit the report and added the default value, that it should update the server copy. But it is fixed!

Cheers.
Gazareth
Gazareth
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2863 Visits: 5331
No worries. Think the behaviour is that report deployments (or saves when using Report Builder), don't overwrite the parameters' default settings.
skanker
skanker
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1019 Visits: 1385
I have noticed the same issue myself.

Last year we upgraded our reports from 2005 to 2008 R2. All went well and we breathed a sigh of relief. A few weeks ago I needed to amend some details and change a parameter - this was all done in Visual Studio and then deployed. It caused me a major headache when I kept testing the report and wondering why my changes had not worked.... I deployed again and same result - arrghhhhh... Luckily for me a colleague had recently had the same issue and had found the solution. It would never have occurred to me to go and make changes via report manager.

Simple when you know how but really frustrating to get ones head around it all. Why a re-deployment does not overwrite these details I still do not fully understand. Hehe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search