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


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

sql profiler doesn't show mdx report parameter values

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

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.


View Complete Post


More Related Resource Links

SSRS Report based on SSAS Cubes doesn't show NULL values correctly

  
I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?  

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.

 


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.


fetching values from multiple tables to show on crystal report

  
Can somebody guide me to make crystal report showing values from multiple tables?

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

Linq to XML query doesn't show data with null values...need it to!

  

I've got a web service that returns xml from a linq query.

If i have fields 'name' and 'title' my linq query will return results that have data in both 'name and 'title' fields.

How can I get linq to return a query when both fields are populated, and when only the name field contains data?

Here's what I've got:

        [WebMethod]
        public XmlDocument GetUsersByDate()
        {
            StringBuilder sb = new StringBuilder();
            XmlWriter writer = XmlWriter.Create(sb);

 

            var SelectedUsers = (from u in db.Users
                                 select "<UserName>" + u.UserName + "</UserName><x>" + u.Title + "<x>").ToList();

            writer.WriteStartDocument();
  &

Drilldown report export to excel doesn't show Grouping

  

Hi,
I am using SSRS 2008 + VS 2008, reports are server side, i have a drilldown report that shows subreport in drill down but when i export it in excel it doesn't show grouping it display the drilldown data as it is, there is no +/- sign beside every grouped item just like in drill down.

Please let me know how to resolve it, thanks.

 


Adi

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.


gridview help on each dynamic row solve this show values based on all columns

  
<asp:GridView style="Z-INDEX: 101; LEFT: 1px; POSITION: absolute; TOP: 183px" id="Gridview1" runat="server" Width="613px" Height="127px" ForeColor="Teal" Font-Size="12pt" Font-Names="Palatino Linotype" Font-Bold="True" Visible="False" BorderColor="Transparent" AutoGenerateColumns="false" CellSpacing="2" GridLines="None" OnRowCreated="Gridview1_RowCreated" SelectedIndex="5" ShowFooter="true" OnRowDataBound="Gridview1_RowDataBound"><Columns>  <asp:TemplateField HeaderText="ItemCode"><ItemTemplate> <asp:DropDownList id="DropDownList1" tabIndex=16 runat="server" AutoPostBack="True" DataValueField=" ItemCode " DataTextField=" ItemCode" ></asp:DropDownList></ItemTemplate></asp:TemplateField>  <asp:TemplateField HeaderText="ItemName"><ItemTemplate> <asp:DropDownList id="DropDownList2" tabIndex=16 runat="server" AutoPostBack="True" DataValueField="ItemName" DataTextField="ItemName" ></asp:DropDownList> </ItemTemplate> </asp:TemplateField>  <asp:TemplateField HeaderText="Category"&

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.
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