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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

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

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
 
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.


View Complete Post


More Related Resource Links

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.

 


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.


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.


Default Parameter Values not Updated when Report Updated

  

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

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


Get Submitted SQL with Parameter Values (Not @Names)

  

Hi

I want to retrieve the full SQL that my Web Application generates and executes on the database. So when the INSERTED or UPDATED events are triggered on the SqlDataSource, I want to get that particular SQL Statement.

The  problem I've got there though is when I use "e.Command.CommandText" that gets the SQL statement with the paramter names NOT the paramter values. I specifically need the values.

So... how can I get it to display the full SQL statement containing submitted values!?

Thanks

Matthew


How can I pass a parameter into my report?

  

I looked all over the forums, spent about a day on it, found numerous people having similar problems passing a parameter, but all the solutions I found so far were partially incomplete or incompatible to my project. I tried using a few of the "solutions" and they generated exceptions. I'm using straight ASP.NET so far with no c#. Is there a way to do it without code behind?

If someone suggests a solution I would be very grateful! Laughing I'm certain that if you provide a complete working example that others in the future will be very grateful as well.


Here is what I have thus far:


I used studio to create an .ASPX web form, and I used the report wizard to create a .RLDC file on the .ASPX page.

When I execute it, it works! Beautiful... Now how do I pass it a parameter?

So this is what I have below (which works), but I want to pass in a single int32 parameter to the stored procedure usprptGetData in which it is based.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MyPage.aspx.cs" Inherits="My_Reports_Guarantor" %>
<%@

two temperory table values from sql to a crystal report

  

in a crystal report ,  i used stored procedure name to display the fields.my problem is,  in the procedure i selected the fields from two temperary tables.but in vs 2005 field explorer showing only the fields from the first temperory table.y the second temperry table fields are not displaying?

i need two temporary table values .In sql tempo table query like as follows

Select  * #TmpSummrep1.

Select  * #TmpSummrep2


all fields from #TmpSummrep1 available in field explorer.

my procedure is running without any errors.


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.

Displaying a Parameter Value in the report footer that corresponds with the parameterized data on ea

  
I've got a report that has only one parameter, it determines the department (or departments) to base the report on, the parameter is set to allow for multiple values. The report returns only on page per department, so the report could be anywhere from one to a hundred pages, one page per department. I've included a text box in the report footer that displays the report name and the parameter value, the expression looks like this: =Globals!ReportName & " For Department " & Parameters!Dept.Value(0)    I know that in this example the zero inside of the parenthesis of the parameter value is what is returning the actual value when the report is rendered, and I understand that the zero is value in the array of parameter values. What I'm looking to do is adapt this expression so that the parameter value rendered on each page corresponds with the data (departement) displayed on the specific page. So using the example of the data, if the user selected three departments in the parameter drop down, then each page that displayed the different department’s information would also display that departments name in the page footer text box. I'm thinking that each time a page is rendered that there is a group or global variable that can be called to provide this dynamically but I can't seem to find the information. Appreciate any help, Dan

How to insert values into my table the data is coming from inline table valued function

  
Hi all,   i have table oi want insert values into my table the data is coming from inline table valued function how i can use the inline table valued function to insert datainto my table i have inline function which out puts 3 collumns of data how i can insert this data into my table i have the insert statment like below insert into tablename(c1,c2,c3,c4,c5) select ('abc',....................,'xyz') how i can use the out put put of my inline function to  to insert data into my columns c2,c3,c4. please help me out Thanks & Regards Sunil Yoganna

How do you add duplicate fields to a SSRS custom report and receive differtent output values.

  
I have built a custom report in SSRS 2008 using fields for supplier and customer.   I have added a Parent Row Group using the Supplier field for the group expression and used the Customer Details as my child details group. This returns a list of all customers for each supplier.   (Supplier | = Customer details ( Name, Dob etc.)   How would I add an additional Supplier field to the customer details returning only values for other Suppliers used by a customer, not the value of the Supplier listed in the Parent Group?

SSRS Report Parameter Auto selection

  
HI All    I have a report paramater 'ParamBranches' which list all branches say aa,bb,cc etc ... and another report parameter is 'ParamBranchStartswith' So when i type in 'a' in Branh Starts with paramter -  the 2nd parameter that is ParamBranches will be filled with "select ",  "aa"   As there is only one Branch starts with 'a' ,  Is there any way to autoselect the Branch 'aa'  in Branches list , rather than user manually selects 'aa'       Regards Sooraj

Struggling to assign the parameter value for the RDLC report, VS2010

  
 Struggling to assign the parameter value for the report, I saw so many helps in this forum. seems i have the same error comes again after i click the button. pls help what i miss in the below?   Following is my .XSD (DataSet) SELECT     [Order Details].OrderID, [Order Details].ProductID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount,                       CONVERT(money, ([Order Details].UnitPrice * [Order Details].Quantity) * (1 - [Order Details].Discount) / 100) * 100 AS ExtendedPriceFROM         Products INNER JOIN                      [Order Details] ON Products.ProductID = [Order Details].ProductID <div> <asp:Label ID="lblMessage" runat="server" Text="Label"></asp:Label> <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="OrderID" DataValueField="OrderID"> </asp:DropDownList> <asp:Button ID="Button1" runat="s
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