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

Interactive Sort Does Not Work With SubReports

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

Dashboard In Ssrs

May 21, 2008



Hey guys,

How to do dashboards in ssrs,

plz help me

View 4 Replies View Related

Dashboard On MSRS

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

Reporting Dashboard

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

Digital Dashboard Question

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

DashBoard Solutionusing Micrsoft BI

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

Using RS Reports In A Custom Dashboard

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

How To Create Dashboard Reports Using SSRS?

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

DashBoard Solution For Hyperion Essbase 7.1.2.

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

Dashboard Solution For Hyperion Essbase 7.1.2

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

Resetting Stats For Performance Dashboard

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

Sql 2005 Express Advanced And Server Dashboard

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

Building A Report-dashboard In WSS 3.0 Integrated Mode

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

Reporting Services :: Cannot Pin SSRS To Power BI Dashboard Using CTP 3.0

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

SQL Server 2014 :: Making Dashboard In Excel From Queries?

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

Adhoc DashBoard In SQL Server Reporting Service 2005

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

Reporting Services :: Create Dashboard With SSRS 2008 R2 Native Mode?

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

Dashboard (Question) Reports In SSRS (automatic Scolling Or Automatically Loop Through Pages)

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

Reporting Services :: How To Change Title Of Chart In Performance Point Dashboard Designer

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

Subreports

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

(SubReports) Is It Possible To...

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

Subreports Problem

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

Subreports Programatically

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

SubReports Not Working

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

Dynamic Subreports

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

Nested Subreports

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

Trying Subreports - Does Not Work

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

Master And SubReports

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

SSRS SubReports

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

Dynamic Subreports... Is It Possible?

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

Subreports And Stored Procedures

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

Page Break And Subreports

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







Copyrights 2005-15 www.BigResource.com, All rights reserved