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
ADVERTISEMENT
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
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 19, 2014
I have downloaded MS's performance dashboard report and installed. I wanted these report should automatically send the performance report to my email.
View 1 Replies
View Related
Feb 13, 2007
Hello,
I have a report of processes which either go into a Log table or an Error log table. They also have start / finish datetimes and a timespan value. So I want to report the process elapsed time or the error condition, depending on which table the process finished up in.
I then compare the elapsed time to the timespan and then show either a red flag (errored) green flag(worked within timespan) or yellow flag(worked but ran over allotted time) depending on what happened.
Is this possible?
I think it would be easy for me to get the info I want into a dataset using .net code but how do you link that in with SSRS?
Any help appreciated,
Thanks.
View 1 Replies
View Related
Jun 27, 2007
I am looking for some examples of code for an appliction which will let run RS reports from a custom application. The user will choose the reports from a menu structure
We have an exiting application which we use to run crystal reports which we are going to be migrating to RS. We use custom web controls to capture the required parameter values for the reports, and hope to reuse the same controls (with minimal rework) to capture the parameters values for the RS reports.
What I am after is some code which will
a) let me run the report and display it. I don't want to display the report parameters in the URL etc as we generate some report parameter values based upon the user's ID and do NOT want them displayed back to the users
b) export the report to PDF, CSV etc depending upon the option chosen by the user.
The application will be developed in VS 2005 - VB. Does any one know of some links to some sample code
View 1 Replies
View Related
May 4, 2008
I am trying to build a report that allows a user to enter partial text that filters the values in a drop down
For examle;
Lets say I am selecting a value from a drop down for States and I want to type in FL to filter the collection down so that only Florida appears in the select list.
I know the above example wont work since I cannot actaully enter text into a drop down, however
I have also tried to seperate this functionality by creating one report parameter for entering the search text and another parameter that will display a filtered data set using the text entered in the first parameter.
Is this something that reporting services can handle ? If it is please provide a brief example.
Thanks
View 6 Replies
View Related
Aug 10, 2007
We have a custom assembly that worked fine with SSRS 2000. Now that we have upgraded to SQL 2005 we get an "Access is denied" error when attempting to deploy reports that reference this assembly. I could swear that when we first attempted it it worked. We decided to make a minor change to the assembly code and that's when the problem started, even though I've since reverted back to the original code to make certain that the minor change wasn't the issue. The assembly is in the proper folder - C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerin - and the reports are referencing the current version. I've searched high and low on the web for an answer but have found nothing even remotely helpful. All this code does is return a string...it's not doing anything that should require any additional security; and even then I doubt if there would be a problem when deploying.
The full text of the error is:
Error while loading code module: €˜Reporting, Version=1.0.2778.12272, Culture=neutral, PublicKeyToken=null€™. Details: Could not load file or assembly 'Reporting, Version=1.0.2778.12272, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Access is denied.
Any ideas? Anyone? I'm at my wit's end on this!
Thanks,
Mike
View 5 Replies
View Related
Dec 28, 2007
Any One has implemented Custom Subscriptions of Reports(Reporting Services 05)
View 4 Replies
View Related
Sep 21, 2015
I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client.
I added this custom Dll codelibrary.dll to my SSRS report. and the expression of one of the field asÂ
=codelibrary.codefunction.GetValue(1000) Â
codefunction is the class and GetValue is the method.
When I preview the report, I get the error "Error while loading code module:
'CodeLibrary,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null'. Could not load file or assembly 'CodeLibrary,Version1.0.0.0, Culture=neutral,PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified."
I am using VS2013, I have placed the custom library DLL in the path
C:Program FilesMicrosoft Visual Studio 12.0Common7IDEPrivateAssemblies
I have tested the custom library with a WPF application and it works fine.
I am not able to figure out what is causing this error.
View 4 Replies
View Related
Mar 8, 2007
Hi,
I am creating a custom transformation component, and a custom user interface for that component.
In
my custom UI, I want to show the custom properties, and allow users to
edit these properties similar to how the advanced editor shows the
properties.
I know in my UI I need to create a "Property Grid".
In
the properties of this grid, I can select the object I want to display
data for, however, the only objects that appear are the objects that I
have already created within this UI, and not the actual component
object with the custom properties.
How do I go about getting the properties for my transformation component listed in this property grid?
I am writing in C#.
View 5 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
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
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
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
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
Aug 14, 2007
Hi,
I've created a Custom Data Flow Component and added some Custom Properties.
I want the user to set the contents using an expression. I did some research and come up with the folowing:
Code Snippet
IDTSCustomProperty90 SourceTableProperty = ComponentMetaData.CustomPropertyCollection.New();
SourceTableProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
SourceTableProperty.Name = "SourceTable";
But it doesn't work, if I enter @[System:ackageName] in the field. It comes out "@[System:ackageName]" instead of the actual package name.
I'm also unable to find how I can tell the designer to show the Expression editor. I would like to see the elipses (...) next to my field.
Any help would be greatly appreciated!
Thank you
View 6 Replies
View Related
Apr 2, 2007
Hi,
I'm trying to enable Expression for a custom property in my custom data flow component.
Here is the code I wrote to declare the custom property:
public override void ProvideComponentProperties()
{
ComponentMetaData.RuntimeConnectionCollection.RemoveAll();
RemoveAllInputsOutputsAndCustomProperties();
IDTSCustomProperty90 prop = ComponentMetaData.CustomPropertyCollection.New();
prop.Name = "MyProperty";
prop.Description = "My property description";
prop.Value = string.Empty;
prop.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
...
}
In design mode, I can assign an expression to my custom property, but it get evaluated in design mode and not in runtime
Here is my expression (a file name based on a date contained in a user variable):
"DB" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + "\" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + ".VER"
@[User::varCurrentDate] is a DateTime variable and is assign to 0 at design time
So the expression is evaluated as: "DB189912189912.VER".
My package contains 2 data flow.
At runtime,
The first one is responsible to set a valid date in @[User::varCurrentDate] variable. (the date is 2007-01-15)
The second one contains my custom data flow component with my custom property that was set to an expression at design time
When my component get executed, my custom property value is still "DB189912189912.VER" and I expected "DB200701200701.VER"
Any idea ?
View 5 Replies
View Related
Aug 17, 2005
What I want to accomplish is that at design time the designer can enter a value for some custom property on my custom task and that this value is accessed at executing time.
View 10 Replies
View Related
Aug 16, 2006
I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime.
I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me?
This is what I did in the custom task
customProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName]
Any help on this will be very much appreciated.
Thanks
View 3 Replies
View Related
Nov 5, 2007
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
View 4 Replies
View Related
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 2 Replies
View Related
