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

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

Drill down on a dashboard subreport?

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server

I am creating a dashboard report My screen is divided into quarters and I have a graph in each quarter. Is it possible to use sub reports in each quarter that could be drilled down by the user.

For example the user could drill down on a bar chart graph in quarter 1, but the rest of the quarters remains static on the screen.

View Complete Post

More Related Resource Links

JIT and Run: Drill Into .NET Framework Internals to See How the CLR Creates Runtime Objects


There's lots to explore in the .NET Framework 2.0, and plenty of digging to be done. If you want to get your hands dirty and learn some of the internals that will carry you through the next few years, you've come to the right place. This article explores CLR internals, including object instance layout, method table layout, method dispatching, interface-based dispatching, and various data structures.

Hanu Kommalapati and Tom Christian

MSDN Magazine May 2005

KPI's Dashboard

In my current project, there are list of kpi's that needs to be displayed on a dashboard with red/green/amber etc and the Trend. This can be done in the following two ways 1) Creating KPI's in SSAS 2008 and display them using SSRS. The report will then be embedded on a sharepoint portal web page. 2) Creating KPI's using SSAS/Sharepoint Portal. The second option is obviously expensive since I cannot use sharepoint foundation. Could you please advise as what would be the best approach.

Show/hide dashboard items Sharepoint



I'm having a problem with trying to filter the appearence of items on a sharepoint site by having a dropdown list and filter according to the current value, The method i am using atm is by having javascript and by looping through all the <td> on page. This works for list views, But not for Performance point dashboard objects/web parts, +

Is there a way to somehow get the title of all performance point objects on a page, fill the dropdownbox show/hide depending on the selected item in the box?



display non measure, non dimension fields in drill down

Hi All, I created my fact table with more fields than just the foreign keys linking dimensions and the field(s) to be used as mesures.  I did this hoping that on drill down I would be able to see the extra fields so that the user would have access to detail information on the records making up the measure amount.  The extra fields do not appear on drill down.  How can I make them appear, or am I on the wrong track? Thanks for any help

SQL Server 2005 Performance Dashboard Reports user context

HI, We are planning on installing the Dashboard reports. But we'd like to know if the Dashboard is run under admin user or the login user who runs the Dashboard reports? Thanks! Kong

Linked Report Subreport- Error: Subreport could not be shown on SSRS 2008r2

I've got 2 folders: /Finance /Japan In the Finance folder I have a Sales report that has 3 subreports, and a salesregion parameter. I created a linked report in /Japan to /Finance/Sales, hide the salesregion parameter, and set the default to Japan, so they can only see their region's sales data. But when a Japan user runs the Sales report, they get Error: Subreport could not be shown because they do not have access to the /Finance folder. Any ideas?

Use Dashboard designer in Sharepoint Foundation 2010

Hi, I want to Install Dashboard Designer in Sharepoint Foundation 2010(WSS 4). I can only find articles on insatllation in Sharepoint Server 2010..like this one.. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx?wa=wsignin1.0 Can you please let me know how I can use Performance Point in Sharepoint Foundation?   Thanks  

VS2010 Reportviewer - subreport - web server

Hi all,I have ASP.NET web application(vs 2010). I'm trying to use subreport with reportviewer. The report is working with my machine, it returns both the main and sub report. But when I deplyed to web server, the main report display, but not the subreport and no error indicate. I did something like this with VS2005 and deployed to web server without any problems. Here is my coding:Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load      Dim ReportViewer1 As New ReportViewer        Dim rptDataSourceMain As New ReportDataSource("dsSRC", GetDataSet("p_SRC_completed_main").Tables(0))        With ReportViewer1            .ProcessingMode = ProcessingMode.Local            .AsyncRendering = False            .LocalReport.ReportPath = "content\SRC.rdlc"            .LocalReport.DataSources.Clear()            .LocalReport.DataSources.Add(rptDataSourceMain)        End With        ' HANDLE the sub-report        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource        ReportViewer1.LocalReport.Refresh

SSRS 2008 Having more than one subreport changes output

I have a master report which has a list control.  The list contains employee header information.  I have ticked the option to have a page break between each instance of a group on the details group properties page as i want each employee on a seperate page. There is no grouping on the list other than the default details.  I have two sub-reports which are linked to the main report by an employeeID.  When i add the first sub-report it displays the header and associated detail without a problem.  When i click on the next record it shows me the correct next employee header and the correct associated details.  However, when i add the second subreport to the list and review it, the first record shows okay, but when i click on next all the header information is gone - when i then click on previous to show the previously ok record - all the header for that record has now gone.  It doesn't matter which subreport i use as the first one on the master - it happens in exactly the same way as soon as i add the second subreport to the list control.  This is a vitally important report and i am now starting to get very frustrated as i cannot easily see a solution.  Your help would be most appreciated.  Barry  

How to deploy dashboards made in dashboard designer to diferent site collections?

Hi I just migrated from sharepoint 2007 to 2010. We used to have performance point dashboards spread across libraries in subsites all across our primary site collection "Http://server:x" after I migrated I understand that I must migrate all performance point content to a new site or site collection made with the business intellingence template. I created a new site collection with this template (Http://server:x/sites/pps) and succesfully migrated all performance point content. Now I want to redeploy all the dashboards to their respective subsites in the  "Http://server:x" site collection so that everything looks exactly as it did when we where using SharePoint 2007. But when I try to deploy to a site I only get the option to deploy it to the ("Http://server:x/sites/pps") site collection and its respective libraries. I wish to manage all dashboard content centralized in (Http://server:x/sites/pps) but I want to deploy dashboards to libraries across  "Http://server:x" is this posible or how is Performance Point services supossed to work?   I also having trouble with DashBoard designer. I have everthing running on a Virtual Machine test enviroment. With windows server 2008 r2, 4 gb ram. Everything installed in one machine. And Suddently DashBoard Designer Crashes In the event log I get the error Dashboa

PerformancePoint Dashboard Problems

I am having a few problems with a dashboard I am trying to create. The first problem, is that I have an analytical chart, that was working correctly before. It is just a line graph with numbers on the y axis, and date on the x axis. When I created the chart, the database only had entries for four days, all of which showed up.  Today, I updated the table to where it has 15 days of data now, but only the original four entries still show up. Secondly, I have created a time intelligence filter. The filter itself works fine when I preview it. The formulas are correct, and my hierarchy is correct. The problem comes when I try to create the connection between the filter and the chart.  On my available fields under the filter, I have, "display condition, time, display value, member unique name, formula, and the name of my data source. I obviously want the time filter to change the time field on my chart.  I dragged "formula" down to the chart, selected Time PK Date as the "connect to," and set formula to the source Value. I believe those should be the correct settings, yes? well when I deploy the dashboard to my sharepoint site, I get this error: "Error running data source query. Contact the administrator for more details."   Since I am the administrator, I checked out the event logs, and was given these errors: --------------

Parameter passing from masterreport to subreport

what If I'm passing a parameter which is null ?? and if the parameter is an integer? My subreport query is : SELECT    ...FROM ... WHERE ... and (CRMAF_FilteredContact.ownerid = @ownerid  OR @ownerid IS NULL) ORDER BY CRMAF_FilteredContact.OwnerIDname When I try it with a null value in the subreport, it works fine, but when I try it from  the main report, so I tried to remove the ownerid parameter, I tried to put it at blank, I tried to put NULL but I've always an error, the report start fine but then, on the total, i've the error "error subreport could not  be shown". I've the error : [rsErrorExecutingSubreport] An error occurred while executing the subreport subreport3: One or more parameters required to run the report have not been specified. But then I don't know how to fixe it.  I put the @ownerid as blank, but obviously it doesn't like it. I've done that because i'm using the same sub report above but grouping with this parameter. How can I manage this ? Thanks a lot,  

Graph messes up subreport?!?

Hello all, I'm using the built in graphs in SSRS 05. The report has a graph on top and a subreport below. The subreport contains the detail for the graph this way it displays like a Data Table in Excel. The report is 18 pages, displaying one page per department. The parameter for the subreport is the department number. For some reson I get "Error: Subreport could not be shown" on six of the pages. The graph on top displays correctly though?.. If I delete the graph and render the report with only the subreport I do not get any errors. Any ideas on what could cause this? Thank you in advance - Lee

Formula on Main Report Using a Field from Subreport

Hi, I try to use a value coming from a cell which contain a subreport. I need to create a formula using this value. So I tried : =Code.CalcPct(CountDistinct(Fields!s_contactsvisited.Value), Globals!CALL_SubReport) But I've an error: [rsRuntimeErrorInExpression] The Value expression for the textbox textbox9 contains an error: Specified argument was out of the range of valid values. Thanks for you help,      

What is "semester" in Dashboard Designer?

I am setting time properties on an AS data source. When associating time members, I encountered "semester". Is this a 4-month period (Jan-Apr and so on)? Thanks 

How to read the value of textbox in table1 of subreport

I have a report which has subreport in it. the textbox5 has a countrows() function hooked and i want to =sum(Subreport1.table1.textbox5.value), is it possible. subreport control is pointing to childreport.rdlchildreport.rdl has - Table1 and textbox5 Thank you very much for the info.
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