Interactive Dashboard With Subreports
Sep 14, 2007
I am trying to create a dashboard that is split into the five main focus areas of Customer, Finance, Management, People and Innovation. Each focus area has a main report and a series of subreports (within a panel). I use the €˜Jump to report:€™ property at the domain level €“ which works well.
My problems arise when dealing with the subreports. For example, in the €˜People€™ focus area €“ the panel contains 4 subreports covering; contractor vs. fte trends, gender balance trends, compliance trends and investment trends.
Ideally I would like to have four €˜tabs€™ which when clicked would show the relevant subreport. I know this can be done via a full report refresh, but it looks clumsy and is more complex and costly to maintain.
I am happy for any method that might change the €˜Subreport€™ property dynamically or set the visibility of the objects. I want to avoid using the toggle capability as this could result in two or more subreports conflicting and being visible at the same time.
View 2 Replies
ADVERTISEMENT
Nov 19, 2007
Hello All,
I have a subreport that has interactive sort on one of the columns in a table. The interactive sort works well when i run the subreport. But when i run the parent report that contains the subreport then the interactive sorting does not work.
Has anyone come across this issue, any help will be greatly appreciated.
Thanks a lot!
Mohit
View 16 Replies
View Related
May 21, 2008
Hey guys,
How to do dashboards in ssrs,
plz help me
View 4 Replies
View Related
Aug 7, 2007
Hi Everybody,
I am new to MSRS, just want to ask, can we create a dashboard on MSRS. Which will have tabs on top for different analysis.
Thanks in advance,
Siddharth Rai.
View 2 Replies
View Related
Jun 7, 2007
Hi ,
I want to build a reporting dashboard. Can anyone guide me to books/docs/articles of how to build up a report dashboard using sql 2005 reporting services.
I am not planning to use those real jazzy reports. Just some simple charts, bar graphs and statistics shown. The client wants a simple but a professional looking UI.
Can anyone guide me..
Thanks.
View 5 Replies
View Related
Dec 28, 2006
I€™m not sure if this is the right topic for this particular forum but here goes anyway€¦
Okay, admittedly, I am not really familiar with MS SQL Server (I€™m Oracle, actually) but I am investigating a possible implementation on a relatively small scale. I am sure that MS SQL Server will handle all the database functions I need and will leave plenty of room for future growth. That really isn€™t the issue. What I am trying to figure out is how the Digital Dashboard I€™ve read about works. Of particular concern is the apparent connection between the Dashboard and Share Point. My first question is this: Is Share Point required to use the Digital Dashboard?
My next question is actually a bit easier€¦ Is there a sample site I can access that shows some of the capabilities of a Digital Dashboard implementation? I€™d like to make sure that the kinds of displays I am trying to build are actually available using this feature€¦
Thanks in advance for your assistance!
View 4 Replies
View Related
Apr 28, 2008
What Micorsoft product can I use to acces Hyperion Essbase 7.1.2 and provide a dashboard solution?
View 1 Replies
View Related
Jun 22, 2007
We have several reporting services reports that have been formatted specifically for dashboards displays, ie. with charts, kpis, tables, etc.
Currently I am using MOSS 2007 dashboards to display these reports on a large flat-screen display in our area, but only using a Web Page webpart to display. Because these reports contain a lot of information, it is more ideal to show a single report at a time, and after a few seconds display a second report, etc, similar to a powerpoint slide show.
My question is, how can this be accomplished? Can the Reporting Services web parts do this? Can a custom web page be built to flip between different reports on a timed interval dynamically? Can transition effects (fade, wipe, etc) be used between report views?
The important point here is that the dashboard/reports are displayed on a central monitor, so these dashboards are not designed to be interactive (i.e. people viewing, changing, filtering, printing, etc.) - only viewing in a browser.
Thanks!
Kory
View 1 Replies
View Related
Mar 24, 2008
Hi Folks,
I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?
Is there anyother resources avilable to develop this dashboard reports? thanks in advance..
Thanks,
Senthil
View 11 Replies
View Related
Apr 29, 2008
My company is looking to implement a dashboard solution for Hyperion Essbase 7.1.2. The inclination is towards using Micrsofts BI for doing the same. However we are in admist of deciding on which MS BI products(SSAS or SSRS or SSIS) supports the Essbase 7.1.2 version in terms of connectivity and performance. I know SSRS supports Hyperion system 9BI+ but not sure about the backward compatibility.I would greatly appreciate if GURUS could shed some light into this.
Thank you
View 2 Replies
View Related
Apr 29, 2008
My company is looking to implement a dashboard solution for Hyperion Essbase 7.1.2. The inclination is towards using Micrsofts BI for doing the same. However we are in admist of deciding on which MS BI products(SSAS or SSRS or SSIS) supports the Essbase 7.1.2 version in terms of connectivity and performance. I would greatly appreciate if GURUS could shed some light into this.
Thank you
View 4 Replies
View Related
May 13, 2007
I have installed the reports for the performance dashboard and really like it!
However, I'd like to be able to clear the stats in order to run specific procedures etc and see the most inefficient parts in the specific procedure. The documentation says like this about it:
The lifetime of the DMV data depends on the lifetime of the plan in cache. You can determine how long the plan has been cached, and thus the time frame over which these resources have been consumed, by looking at the Plan Cached column
What Plan Cashed column? Can someone explain to me how to clear the stats?
Regards Andreas
View 3 Replies
View Related
Jun 6, 2007
Hi I have installed Sql 2005 Express with Advanced Services Edition.
I can't find the server dashboard that comes with the full Sql 2005 version.
That gives you information like top 10 queries etc.
Should I have installed the Toolkit version instead or have I missed off features on this install or does it not come with Server dashboard.
thanks for any advice
Sammy
View 1 Replies
View Related
Dec 7, 2006
I have a page with three Web parts;
1. Filter Web Part that uses a BDC-driven list of clients
2. Part showing RDL's from a doclib
3. Report viewer Web Part
I can use the Filter part to supply a parameter value to 3. when I select an RDL manually, I can set the Viewer connections to get the Report Definition from 2. But I can't get both options to work at the same time. The reports in 2. all have the same Parameter so there shouldn't really be a problem.
Looking forward to any suggestions or a way to provide feedback on the CTP (RS SharePoint Addin).
TIA.
Ed
View 8 Replies
View Related
Nov 4, 2015
Getting Cannot PIN SSRS Chart...Server Error: The item "Dashboard deleted 9e0c7443-406d-4435-aaf3-8c7d5a47b7db" cannot be found. (rsItemNot Found).Yet, the list in the drop down populates the list of dashboards from Power BI (loading).Dashboard in Power BI works fine.
View 2 Replies
View Related
Jul 20, 2015
Currently i have set of queries which i run for data extraction and result pasted in Excel table so that my pivot table and Chart gets populated along with the summary in Excel file.
I would like to automate this thing and want to know if i can achieve excel output for dashboard on a click of button.
View 2 Replies
View Related
Mar 3, 2008
Hi Gurus,
We are planning to user SQL server 2005 reporting services in our project, for this we are doing a Proof of concept exercise to evaluate if SSRS 2005 will be good for our project.
For this we are trying if we can make dashboard or composite reports (combine 4-5 reports to create one report).
Also if we can make this dashboard ad-hoc. As we are already using the Ad-Hoc reporting capability of SSRS 2005 we wanted to check if dashboards can also be created using Ad-hoc reporting feature.
Please let me know if you any information or pointers for this.
Thanks in Advance.
Regards,
-Gaurav
View 1 Replies
View Related
Jul 22, 2015
We want to create interactive dashboards using SSRS 2008 R2. We currently has Report Server installed in Native mode. I see that we can build some good dashboards using SSRS, SharePoint 2010 and PerformancePoint. But I wanted to find out if we can build that level of dashboard using just SSRS. We are still convincing the management for getting SharePoint license. In case if they don't agree for the Sharepoint license, can we build some good dashboards just using SSRS?
View 5 Replies
View Related
Nov 8, 2007
I need to create a simple dashboard report that will be displayed on a large screen.
My problem is that there can be potentially more records than the screen can display.
Based on how i size my report the report can be a single page with a scroll bar or mutliple pages.
My question is: Is there any way of automatically looping through pages or to automatically scroll down through the records in SSRS
If anyone has any experience of something like this or suggest a work around in SSRS could you please let me know
Thanks in advance
Brunzire
View 3 Replies
View Related
Jun 25, 2015
We have created a chart in SharePoint 2013 with performance point dashboard designer. We want to change Title of chart. For more  information please check attached image.
View 2 Replies
View Related
Dec 27, 2007
Hi
I have a subreport to which I am passing values. Now my requirement is only if there are records to be displayed the
report should be displayed or else the report should not be displayed. Is there anyway I can do this. I know
that there are expression for the visibilty tab in sub reports properties. But how do I set it up.
Thanks
Sai
View 1 Replies
View Related
Feb 21, 2007
Here's my dilema. Our organization has two db servers. One is Oracle and the other is SQL Server. Oracle contains our HR information on all employees and SQL Server contains information on various projects that we are undertaking. The HR system (Oracle) contains Employee ID's, Names, addresses, phone numbers, etc. SQL Server has information about the varous projects and Employee ID's of who is assigned to those projects. I have a report that has two data sources (one to each server) and two datasets (each populated from the two datasources). I would like to have a single table that displays the project and the name of the person who's assigned to that project. This would be achieved by linking the tables on similar information, which is the Employee ID. I've received responses in various news groups etc. saying this can be done by using subreports and query parameters but it's never explained how to go about it. Kind of like, I can tell you what you use to fly to the moon, but I can't tell you how to actually go about building the rocket that gets you there. :)
Is the functionality that I'm looking for possible in SSRS 2005??
Thanks,
James
View 3 Replies
View Related
Jun 4, 2007
Hi,
I have a strange problem.
I have developed a report with 2 subreports in the main report.
I am talking about a visual studio environment.
when i test the report and run it local the report works fine. I see my report (multiple pages) with on each page
my subreports included.
When i deploy the report to my reportserver, all goes well and i don't get any error.
When i access the report on my reportserver and i run it, all goes well.
But, on my second and third page of my report, the subreports don't show (Error: Subreport could not be shown).
Does anybody has a explanation for this ?
Greetings
Vincent
View 1 Replies
View Related
Dec 27, 2007
Hi
I have a main report and sub report. The subreport has some fields like SYS, LOC, MSG etc.
But the report should display the values filtered basis on system. i.e. I must have a sub report
for SYS1 , SYS2 , SYS3 and so on. I can create a sub report for each system. But I want to create only subreport and
call them from the main report. How do I do this?
Thanks
Sai
View 5 Replies
View Related
May 25, 2007
I have a main report and I plan to use a drop-down box to select one of four different sub-reports, at a time, based on the selection. These subreports are all based on their different data-sets, due to too complicated conditions which could not be accomodated in a single SQL select. In addition, there are about 9 different filters which are common to all the four sub-reports. These data filters are in drop-down boxes and get populated through their own datasets. I have created and tested the subreports.
My problem is bringing these subreports together in the main report and making them visible based on their selection or otherwise in the main report. Can I use the same parameter I am using to select the subreports, in the drop-down box in the main report, to be passed down to the subreports ? HOW (could someone provide sample code of the lif or IIF statements) ? How does the main report know which dataset to switch to ? And how do I make visible or invisible the individual reports ?
Any help, suggestions and code samples explaining things would be appreciated.
View 4 Replies
View Related
Jul 10, 2007
Hi all!
I need to create a report with a number of subreports. The problem is that those subreports might be different for each datarow.
Is it possible to set the report name for the subreport in some dynamic manner, e.g. extract it from the data?
View 7 Replies
View Related
Jun 18, 2007
Hi!
I have a report (A) that has a list where a subreport (B) is displayed. This subreport includes nested sub-reports (C) which have other nested subreports (D) (globally there are 3 levels of subreports). When I try to preview report A in Visual Studio I get the "Object not set to an instance of an object" but when I try to preview report B everything is ok. I have RS SP1 installed and I have already tried to include a dummy query in the subreports so that they always have a result....
Does any one had a similar error?
Thank you in advance
csr
View 1 Replies
View Related
Feb 12, 2007
Hello colleagues,
I have the following issue:
I am trying to create a report with subreport this way:
1) create report
2) create subreport. Set parameter @AccountName in the SQL query (...WHERE account.name = @AccountName) and in the parameters collection - AccountName, data type string
3) place the subreport into the report and set parameters AcountID = =Fields!name.Value, so that the WHERE clause in the subreport should filter the content according to the field Fields!name.Value.
So far, I suppose this should work. Nevertheless, I get this result in Visual Studio .net:
An error occurred while executing the subreport €˜subreppp€™: An error has occurred during report processing.
Cannot read the next data row for the data set DatasetXYZ.
When I publish the reports into our CRM, I get the main report but the subreports shows: "#Error: The subreport could not be shown".
What can I do to make this work properly?
Any help would be VERY appreciated as I have already wasted several hours with this issue.
Thank you a lot!
Ravie.
View 6 Replies
View Related
Feb 15, 2007
Hi All,
I am new to Rs2005. I have 4 seperate reports, r1, r2, r3, r4,.....etc. I want these reports to be called in sequence in a Master report. I want to make all 4 reports 1 big report. Can this be done, and if so can somebody please point me in the correct direction. Many Thanks in advance.
Kenny
View 20 Replies
View Related
Aug 21, 2007
Hi,
1. Can we acess Datasets from main report to sub report in SSRS 2005?
2. While i preview the report main report and navigate to the sub report the "Back to Parent Report" icon is displayed in the toolbar of the sub report but when i deployed and viewed in Internet explorer it cannot see the "Back to Parent Report" icon. Whether i have do any settings while deployment?
Any help would be appreciated
Thanks
Dinesh
View 1 Replies
View Related
Feb 6, 2007
Is it possible to set up a subreport so that I can determine which report it displays based on parameters? From what I've seen, the report that a subreport displays must be hardcoded... Anyone got any workarounds?
View 1 Replies
View Related
Nov 30, 2004
Hi everybody,
I've got a quick question.....hopefully :)
I have two reports based on two different stored procedures, they both need the user to enter a begining and end date as parameters.
I would like to have one main report and add my two other reports as subreports.
The problem I have by doing that is it asks for the parameters for the first subreport and then for the second and these parameters are the same for each subreport.
Could someone tell me how to have the parameters asked only once ?
Thank you all any help will be greatly appreciated.
Seb
View 1 Replies
View Related
Aug 21, 2007
I have a main report that calls subreports. When a subreport has enough data such that it will not fit into the remaining area of the current page the renderer inserts a page break leaving alot of ugly white space. Is there any way to sop this behaviour? This seems like a very basic thing.
View 17 Replies
View Related