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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

Default Parameter Values not Updated when Report Updated

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server
 

This is either a bug or really wierd behavior by design that needs to be rethought in the near future.

I'm an enterprise developer on a commercial product that integrates and leverages reporting services.  We install a sizable number of reports automaticly as part of our production isntallation or upgrade.  I have a recent QA bug on that process that I find mystifying.

We install reports through calls to the CreateReport web service and its worked pretty well.  Recently, I had a report with a parameter whose definition changed.  Specifically, the default value of the parameter changed from 'All' to 'Select' and corresponding changes were made to the valid values list of the parameter.  When the report is installed, it works just fine.  But when the report is created as part of an upgrade to an existing system, the report for the most part gets all the expected changes but the new default value is not picked up.   Instead, it seems to stay hung on 'All', with the result that the parameter remains in a state of having unresolved dependencies ('All' no longer appears as a valid value) and as a result, breaks our interface (which was designed for single rather than multistep entry of parameters).

I know that some properties are not reset when calling CreateReport. &n


View Complete Post


More Related Resource Links

KPI for updated values

  

I would like to show a value in a KPI and I wonder if there's a way to have a list or something simple where ONE value can be inputted and possibly overwritten (using versioning for history) and that value is updated so the KPI indicates the updated value.  Normally this value will be updated daily.

I checked out Last list value as KPI and it says that it can't be done.  I don't know if anyone has any suggestions or recommendations for this.  I know that they want a history of this and they are currently referencing it in an excel spreadsheet that is linking and the Excel Services is running but seems to be having trouble.

Example:

The Values today are: 8

The above information would be updated daily and there only needs to be ONE value put in to do that update.  Is there something I could do out of the box (I don't do programming, but I do have SharePoint Designer).  For me, if a user inputs the value in a custom list, how do I have the KPI reference the LAST item, instead of a sum or max, or min.?  Is there a way to have only ONE item in the list that overwrites the other, without having to edit it?  I know views show that, if you

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.

Report Parameter Values - Can I use getdate() or now() or any other function?

  
Hi all,      I have a report that utilizes a calendar function but I need to make it a subscription report. Is it possible to use getdate() or now() on the Report Parameter Values? I have a text box that says Enter a Date and that is where I want to have the default value to be run with the subscription. Please let  me know if possible. Thank you.

Report parameter values must be specified before the report can be displayed. Choose parameter value

  

Helllo...I am getting error "Report parameter values must be specified before the report can be displayed. Choose parameter values in the parameters area and click the Apply button." when I deploy the report in the SharePoint. The report works fine in the when I run in BIDS. we have two parameter in this report...Parameter #1 is tied filterd based on the user who is accessing the report and Parameter #2 is dependent on the value selected in Parameter #1.

Please let me know what I am doing wrong here? Is there any workaround to get past this message?

Thanks for help.

 


Default values for filters not populating in report builder (SQL server 2005)

  

Hi,

I  am frustrated with this challenge for  populating default values for filters in report builder. Here are the steps that I am performing.

I have clicked on the filter icon, then dragged the dimension to the filter pane, switched the properties to Prompt and changed the operator to 'in this list'.

 by default the value selected is 'no value selected', Microsoft online tutorials says that this should automatically populate the filter criteria with the default list of values for the underlying dimension. However it dosen't

How do I populate this filter with default list of values.

Please help.

Regards

 

Vincent

 

 

 

 

 

 


Get Values from last updated row using Sql server Triggers

  

I want to Get Values from last updated row using Sql server Triggers.

what is the procedure 4 that (equivalent to NEW and OLD keywords in Oracle).

Plz reply me

Thank You

 

 


Get Values from last updated row using Sql server Triggers

  

I want to Get Values from last updated row using Sql server Triggers.

what is the procedure 4 that (equivalent to NEW and OLD keywords in Oracle).

Plz reply me

Thank You

 


sql profiler doesn't show mdx report parameter values

  

Hi All,

Is there any way that I can afterwards see the members selected as parametervalues in an SSRS report. 

Maybe I'm missing something, but to me its looks as if SQL Profiler is capturing the mdx dataset queries exactly as specified in the report definition, but SQL Profiler does not show the parameter values selected by the end-user.

For analysis puposes I need to figure out what parameter values have been selected by my end-users on report-execution.

Any suggestions/workaround for this ?

Kind regards,

Cees

 


Please remember to mark replies as answers or at least vote helpfull if they help and unmark them if they provide no help.

SSRS URL Paramter Value does not match with report parameter Values

  

Hi,

We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly.

But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing.

The reports db and the application db through which we display the reports are different. how do we address this issue.

pls help.

regards, hari.


Report viewer control is is displaying parameter item 'select a value' even when the default param

  

Hi,

I am using SSRS 2008 R2,

I have set the default parameter of dropdown and in the output "select a value" item text is removed ,also in the Report Manager 'select a value' removed .

But when I am displaying the same reports in the ReportViewer control as ReportViewer1.ServerReport  in the the vs 2010 asp.net project the item select a value is reappearing in the output.

Could you please help me remove the default item text 'select a value' from the ReportViewer control aswel.

Thanks,
Shyam


SSRS URL Paramter Value does not match with report parameter Values

  

Hi,

We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly.

But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing.

The reports db and the application db through which we display the reports are different. how do we address this issue.

pls help.

regards, hari.


existing Values of a Measure not usable if other than the highest level of report-range-parameter is

  

Hello,

I´m working on some new reports with SSRS 2008. Until yesterday I was making good progress. Then SSRS stopped behaving sensible...

I´ve got a measure "Share_EA_completed" which bases on another measure "EAs" and contains the share of completed EAs of the total of EAs. That measure works fine, if I select "All" in the report-parameter. If other levels (such as "Region xy" or "Team 37 of Region xy") are selected, the formula

=FormatPercent(Aggregate(Fields!Share_EA_completed.Value) -
    (5/1000000),2)

gives back "0,00%", which is totally nonsense because if I run the Query of that Dataset in the query designer, I can see, that there are values for each team, and each region.

Does anybody know, how the bloody h... this is possible? I tried everything (publishing the calculated measure again, starting Visual Studio again, rerunning the query etc) but nothing works. Does anybody have an idea?

 

As always your help would be much appreciated!

Regards

NuramonTheWanderer


Crystal Report parameter value window.

  

 Hi friends,

   I am using Crystal report which displays the result of stroed procedure which have 2 paramater.

  When i run report it shows two window for getting each parameter.

  My need is, can i have one window for getting all the paramter value for stored procedure.

 

  With Advanced thanks,

  Jawahar.

 

 

 

 


Crystal Report vs 2003 convert to vs 2008 parameter problem

  

Hi friend,

I have a project develop with Visual Studio 2003, when i convert the project to Visual Studio 2005 is work well. But when i convert to Visual Studio 2008, the crystal report when have pass parameter will prompt the parameter field to re-type then show the report.

But in this converted project i create a new report and pass the parameter is ok. That means i wan re-do all report @.@??
 

Does someone can help me solve this problem??

Thank you


Toolbox: Updated grid controls, open-source comparison tools, and more

  

This time: Windows Forms grids, professional-looking date textboxes, file merging, and more.

Scott Mitchell

MSDN Magazine November 2007


SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000

  

XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002


how to refresh image updated with AsyncFileUpload

  

I've created an AsyncFileUpload device that uploads an image in ListView but it doesn't refresh on the page until the page is manually refreshed. Any ideas on how to accomplish this? This is the applicable code:

In ListView control:

<asp:UpdatePanel ID="udpPhoto" runat="server">
    <ContentTemplate>
        <span style="text-align: center; vertical-align: middle; font-size: 7pt;">
            <br />
            <asp:Button ID="btnEPhoto" Font-Bold="False" TabIndex="160" Text="Upload/Change Photo"
                UseSubmitBehavior="False" OnClick="btnPhoto_Click" runat="server" />
            <br />
            <asp:Label ID="lblEPhoto" runat="server" Font-Bold="True" Text="Uploaded Photo:" />
            <br />
            <asp:HyperLink ID="lnkEPhoto" runat="server" BorderWidth="2px" NavigateUrl='<%# Eval("Photo_Recent") %>'
                Target="_blank">
                <asp:Image runat="server" ImageUrl='<%# Eval("Photo_Recent") %>' Height="50px" ID="imgEPhoto">
                </asp:Image>
      
Categories: 
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