.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

In a SQL2005 Reporting Subscription I need to revert the parameter back to the default value "overri

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
Hi, In a SQL2005 Reporting Subscription I need to revert the parameter back to the default value "override-default." This value was updated to a specific value and now I am unable to have the report updated daily with the new data.  Within Report Manager, drill into the specific report, click on the properites tab, and chose the second link on the left "Parameters."  For the value in question (DataID) someone unchecked the "Has Defalult" button.  This results in the "Use Default" check box being removed from the UI in the Subscription tab.  I can get the Use Defalut box back by entering a specific value in the 'defalut value' but the report runs against that one value (instead of updating daily.) Before the "Has Defalult" was unchecked, the Defalut Value is a buttton, which says "Override Defalut."  It is this 'button' that I am trying to get back. I've googled this and looked thru MS kb without luck.  (I think it maybe a matter of using the right language...) Thank you for your reply.   Victoria  

View Complete Post

More Related Resource Links

Reporting Subscription - dynamic To depending on dynamic input parameter



SSRS : 2005

Deployed: A Simple RDL with a single input parameter(for simplicity say the parameter is City).

The requirement is to send the report to Mayor of each city.  I already have a table with following info.





> Report should run at a static schedule and send reports to each mayor with their City. Currently using regular subscriptions.. which means 50 subscriptions for fifty different cities.

Every time a new city comes, automatic subscription to the Mayor Email ID. Email should not be sent if the there is no data for the city on that particular day.



Personal view reverts back to default after updating properties of item


I am working with a company that has 1 site collection with several sub sites.  I have built 3 document libraries with workflow in 3 different sub sites and all behave as expected.  I have one site where ALL libraries do something perplexing;

If you are in a custom personal view and you go into the properties of a document and then exit (update or not, does not matter) it reverts back to the default view of that library. 

Has anyone seen this?  is there an option when creating an album that could cause this?

thanks in advance for any input on this odd issue.

How to increment default dates in the subscription


I have a report that I want run on a monthly subscription, but the report has a default date parameter. Is there a way to have the default date parameter increment each month. So if I choose to receive the subscription monthly I would want that default date to increment.

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

When trying to install SQL 2008 Reporting 'Install the native mode default configuration' is greye

Whilst troubleshooting an earlier issue with SQL 2008 R1 I needed to install SQL without reporting, I then went through the SQL add feature to add Reporting once SQL was working.  The issue I am getting is that the option I need for SCOM R2 'Install the native mode default configuration' is greyed out and the only choice I have is 'Install, but do not configure the report server' which apparently happens when you don't install reporting at the same time as installing the SQL database engine.  In order for SCOM reporting to install I need manually configure SQL reporting to how it is configured when you install in native mode.  Can anyone help with a document on how to configure this manually ? thanks

Multivalued parameter & Data driven subscription for SSRS 2005

I need to create data driven subscription for our reports. Most our reports have multi valued parameters (7-12 parameters with at least 4-5 with multiple values)and need to be send to a users between the range of 25-200. So standard subscription is really not a choice.I have gone through most of the threads before. Question 1:Does any one have a solution for the SSRS 2005 regarding passing mutiple values for a parameter for the Data subscription table. If yes, could you please share the information. Question 2:I found some solutions using the SOAP API. Can any one explain that in detail- how we can do it ?Reference:http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516735&SiteID=1 Question 3:Here is the other solution I found in one of the postsApparently passing in values like {A, B, C} only works when you configure the parameter values not to come from a dataset so that SSRS doesnt check for ValidValues.Reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/b2c50aea-2032-4025-a155-306c00fcb856/Any commends about this solution?Thanks

WebpartToolPart category "Appearance" expanded by default - How to revert this ?

Hi When I create a sharepoint 2007 webpart and attach a custom Toolpart to the webpart it works fine. However, when I go into edit mode the appearance category is always expanded, and I would like it to be collapsed. I have noticed that the Content Query Webpart be default has collapsed all the catgories of the WebPartToolpart. I tried to look through the code in Reflector, but I wasn't able to figure out how this webpart does the trick. I have found that the WebPartToolpart class has and Expand() method, but undfortunately not a Collapse method. Does anyone has the answer to this one ? Best Regards Lars Kohsel, Nykredit Denmark.

Load View and Partial View (Master/Detail) with default parameter(s) ?

MVC newb.  Members view (index) that lists members that users can select to show a partial view in the same view with details for the selected member Uses jquery (Ajax.ActionLink) to call a partial view method in the members controller to then load the members detail section Works fine up to here....but I'd like to load the partial view with "member" details for a default or random member on initial load -- ie not through the Actionlink selection How do I invoke the partial view method on the initial load?  I'm sure this is basic stuff but still still getting my head around the mvc "way" Can someone point me to an example or explanation somewhere?  (not turning anything up on my searches thus far)   thanks in advance!!

After applying a self-signed cert to MOSS 2007 web app, IIS 6.0 sets the IP Address back to default

I am trying to configure FBA with SSL on my moss 2007 farm, but after web apps are created, and I switch the Authentication Provider for the "FBA" zone (Extranet), it changes the IP's back to default, so then I switch it back to the right IP, and run the SelfSSL.exe to assign the cert, then go back and check the IP, it is set back to default. I need to set the IP because, without it, it stops the site. This is the IP listed under "Multiple SSL identities for this Web Site". This behavior has to have surfaced before, Any idea?

how to store credentials with windows authentication in reporting service for subscription

when I try to set up a subscription, I get this error message: "Subscriptions cannot be created because the credentials used to run the report are not stored or if a linked report, the link is no longer valid" I use a datasource which use windows credentials to access a database which contains stored procedure with OpenRowset query to access cube data in analysis service on the same server.  I have to use windows credentials to access cube data in analysis service.  How can I store the credentails with windows credentials? I appreciate your help!

how to set default value to one parameter based on another parameter value



I have two parameters in a SSRS2008 report which are named as,

1) @showclient - datatype bit

2) @client - datatype varchar. ( This is dependent on @showclient parameter)

I want an expression to set the default value for @client parameter to be " noclients" when the value of @showclient parameter is set to 0( zero).

Thank you.

Acceptable Parameter Types in Reporting Services


I have a web service I am using to create a report in SQL Reporting Services 2008 Business Intelligence Studio.  One of the parameters is an array of a string.  I am not sure how to pass that in the query.


<Method Name="GetBogus" Namespace="http://www.tempuri.org/">
<Parameter Name="codes" Type=

Multi value Parameter Float datatype in Sql Reporting Services2008


Hello there,

I am having a report where i am having 2 parameters to pass the values to Store Procedure in SQL 2008. 

1) @Name Nvarchar(50),

2) @Cost Float

I can able to pass the Multiple values to parameter 1 . From the example below link


but i cannot use that for the float data type. How can i pass multiple values of float data type to my store procedure any help much appriciated..

Thanks Jeevan Dasari....-:)


SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

Cannot set parameter default value



I'm using SSRS 2008 running off a SSAS 2008 cube. My report dataset is running the following query:


In the properties for the DateDateHierarchyCalendar parameter, I set the Available values to Get Value From Query, and this points to the following query:

WITH MEMBER [Measures].[ParameterCaption] AS [Date].[Date Hierarchy - Calendar].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Date].[Date Hierarchy - Calendar].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Date].[Date Hierarchy - Calendar].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Date].[Date Hierarchy - Calendar].ALLMEMBERS ON ROWS FROM [MyCube]

The Value field is set to ParameterValue and the Label field is set to ParameterCaptionIndented.

I then have a named set in SSAS called [Calendar Current Month] which looks like the following:


How to change the Default Value of the Parameter to "Query Based"


Hi I have a Report which i deployed into my localhost.

In the Report Manager, Report Parameter Properties, I unchecked the HasDefault option for which Default value is coming from some Query.

When I retry to Set the Default Value to Query Based, Its not taking.

Need Help.

BDC: Cannot create default instance on a Parameter with DircetionType 'Out', 'Return' or 'SqlRe



I created a ADF with the Application Definition Designer. Some things are allready working, some don't. One thing I want to achieve is the filtering on wildcard filters. I defined a method for a "Customers" table and added two "in"-parameters for "Name" and "FirstName". I also added an instance of type "Finder". Now I want to receive some data from this query with help of the "Execute" feature of the Application Definition Designer. But this return only an error "Cannot create default instance on a Parameter with DircetionType 'Out', 'Return' or 'SqlReturn'". What am I doing wrong?

Thanks for any help!



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend