We're using CRM 4 and have a report that we would like to send out in pdf format attached to an email. However, the report name has to be changed every time because it is a guid. Is there a way to specify what the name is when the pdf is generated to eliminate the need to change it every time? ...
I have a SSRS field called dates. I calculated the difference between the last and beginning date using the following code: =Code.MinutesToHoursMinutes(DateDiff("n",FIRST(Fields!Date.Value), LAST(Fields!Date.Value, "grp_Order"))) The Code.MinutesToHoursMinutes is jsut a function that makes it Hours Minutes format. How do I now average...
I've installed SSRS on my development machine and everything works as expected - except anyone else who is logged on to my domain can view all of the reports by browsing to http://mymachine/reports. I find it a bit strange that the default behaviour is for everyone on the domain to have access to the reports. Am I doing anything wrong...
I have several reports that show no data. The problem is related to the parameters that are sent. There are reports that do show data, but are not sent parameters. The report is a different server to the database where the query is made. My question is why when you send me no parameters reports show information Stored procedures work we...
I have an SSRS report that's called up by a page with an ASP.Net ReportViewer object. The report takes parameters for filtering. Right now when the page is first called up, there are default values in the parameters and the viewer just takes off and renders a report with those settings. I thought this would be a nice time-saver, but m...
I am creating a report using SSRS for a phone number field in my database as a string value. I need to format a string value in phone number format (555) 555-1212. If the value is null, display nothing. For example, a table in my database has a phone number column and some values are NULL. I got a regex that formats the phone number ...
I have my report page size setting to 8.5” x 11” with .5” left and right margins. In the design mode, my tablix is wider than the 7.5” allowed page width due to the presence of some conditionally displayed columns. This is okay though as the total width of the displayed columns will never be greater than 7.5” when the report is run. I ha...
HI, Can you upload a file as part of sql server reporting service 2008 parameter? I would like to be able to upload a text file list contract ids and produce a report based on those contracts. e.g for these 100 contracts what date were they entered into the system. I could have a parameter field which takes a list of comma separated ...
I have a report that shows client names jsut in a list like so: ATK FLD FLD DB DB DB BL I already have them grouped and everything but I am wondering if there is a way to make it so I can have each client seperated by color, for example white then grey then white then grey etc. Right now I am using background color as the following: ...
Hi, We have a web application that launches ReportBuilder by simply calling ReportBuilder.application and connecting using SQL Server credentials. Unfortunately, this means that everyone who launches the application from the web app can run any report. We need a way of restricting the reports that can be run after ReportBuilder launch...
In SSRS I have the following code for one of my fields: (DateDiff("n",FIRST(Fields!Date.Value), LAST(Fields!Date.Value, "grp_Order"))) I now want to take an AVG of all these fields....How would I go about doing this without getting the nested aggregate error? ...
Let me specify the environment. The client has UI for entering orders in SQL Server database. A Windows Service one another machine is processing these orders from database at particular intervals. Sometimes the Windows service is stopped then orders piles up. To avoid that I have created a SQL Server Report which is run at an interval o...
I've got an instance of SQL Server 2008 Enterprise with Reporting Services installed also. I am hosting and administering this locally. My issue is that when I connect to the Report Manager web application I only get the Home|My Subscriptions|Help menu in the upper right hand corner. I am connecting using Windows Integrated Authentica...
Hi, I want to add a field to dataset from another dataset in ssrs?can anybody help me to solve this? Thanks in advance!!! ...
Hi everybody, I'm using a localreport object into an asp.net application. This report is fed by an array of object. So on the render of the report, some properties of the classe are called. Class ClassForReport { string Date { get{return _aDate.ToshortDateString();} } } Now the code for rendering and the problem: //first o...
I recieve [error in class Instance declaration for class TestClass:[BC30002] type 'TestClass' is not defiend. I get this in VS2005 IDE expression is =Code.M_TestClass.ReturnTheStr() Reference Mytest dll, CLASS TestClass INSTANCE M_Testclass DLL Code namespace MyTest { public class TestClass { public TestClass() : base()...
Hi All, I am trying to get this code to work in reporting services 2003: =switch( DateDiff("d", fields!WARRANTY_EXP!value,now()) > 765, "White", DateDiff("d", fields!WARRANTY_EXP!value,now()) > 365, "Yellow", DateDiff("d", fields!WARRANTY_EXP!value,now()) > 0, "Red", DateDiff("d", fields!WARRANTY_EXP!value,now()) < 0, ...
I have this statement =iif( ((Fields!lngCount2.Value-Fields!lngCount.Value)/Fields!lngCount.Value) > 0 and Fields!strSegmentName.Value ="Struggler" or Fields!strSegmentName = "Winback" or Fields!strSegmentName.Value = "Former", "Green" , iif( ((Field...
I am creating a report where the parameter selection = customer_name and the report is one page and has 5 tablix relating to the customer. What my team would like is to be able to select more than one customer at a time to save time; however they want a separate page per customer_name. Can this be done with multi-value parameter and if s...
Short and sweet version: Is there a single web service method that would return the names of all available reports, and each report's parameters? I have my web code (C#/MVC) connected to a SSRS web service, and I am able to retrieve reports through those services. I know I can get a list of available reports like this: var rService =...