Well, I have a table called Resource(ResourceId,ResourceName) and a table Session (SessionId, StartDateTime,EndDateTime,ResourceId) I have a line chart that shows the count of sessions for a given month for each resource. so it will be something like Count Month resourceid resourcename 10 Jan-2006 2 ResourceA 9 Jan-2006 ...
We have a ton of SSRS2005 reports, which I intend to transfer to our new SSRS 2008 server. I'd rather not do this manually... Actually, we've got some SSRS2000 reports on a third server as well, so if anyone knows of a tool or technique for doing all these transfers I pay in upvotes! ;) ...
Hi all, What I want to do is render a SSRS 2008 report as HTML (actually MHTML) and send that as the body in an email. Has anyone done this? I've almost got it (I think) but I seem to have a encoding problem. The email shows up as what looks like some sort of base64 encoding. Like this: MIME-Version: 1.0 Content-Type: multipart/relat...
I'm creating a simple report from Microsoft Dynamics CRM. When I pull in the following dataset: SELECT FQD.productidname , FQD.NEW_PRICEBREAKS , FQD.NEW_WEEKSARO , ltrim(rtrim(FP.NEW_PRODUCTNAME)) AS NewProductDesc , FQD.productdescription , FQD.quoteid , FQD.quantity , FQD.productiddsc , FQD.bas...
I'm working on a Microsoft Dynamics CRM Quote with a separate header report and sub report. The sub-report has a detail grid of what is quote, a terms and conditions statement which amounts to a large block of text, and other items. When the report shows on screen, the Quote looks just like I intended. However, when I export to Word ...
I have a report that shows or hides columns in a group based on a header cell. SSRS makes this pretty easy and is kind enough to place a little plus/minus icon in the toggling cell. I want to HIDE this plus/minus icon when there is only one column of data in the subgroup, because it shows that one column by default so expanding the gro...
I have a table that I'm using to show details from the line items of a quote. I want to hide a particular row depending on the value of the field in it. The expression I've tried is to set the row visibility to: =IIF(isnothing(First(Fields!NEW_PRICEBREAKS.Value, "QuoteDetail")),true,false) When I run the query from the dataset "Null"...
In SQL Server Reporting Services, how would I get calculate the last day of the current month? ...
we have upgraded to SSRS 2008 R2 from a SSRS 2008 instance. This was an upgrade in-place and so the reports and datasources were brought over to the new instance. from the application side (asp.net), we use the SSRS Webservice (ReportService2005.asmx) to makes calls such as ListChildren, GetPolicies to handle some application specific ...
I have to add a listbox/dropdownlist to a report in a Visual Studio Business Intelligence project, allowing users to filter a DataSet by the Id of the entity chosen in the listbox. I heard this was possible, but there is no option to add a listbox in the Toolbox in Visual Studio, and looking at the Report Definition on microsoft.com, the...
Hi, I'm opening an SSRS2008 report using the http://server/reportserver/... syntax, outputting directly a PDF copy. This report has several parameters. The problem is that, despite making changes to the report, and clearing the browser's temporary files cache.. if I request the same report (i.e. same parameters) - the old report is re...
Hi I have to put drill down option for some part of Data. My requirement is..I have 50 suppliers and i have to show top 10 suppliers as normal and for remaining 40 suppliers i have to put drill down option in ssrs report 2008 Please help. ...
I have SSRS 2008 set-up on a server. All works fine except that if left inactive for a length of time the next time a request is made to the server it takes a long time for it to service it. I think this is to do with the worker process being shutdown after being idle for a certain length of time. However, as SSRS 2008 isn't managed t...
I'm writing reports on SQL Server Reporting Server that have a number of hours grouped by, say, user, and a total calculated based on the sum of the values. Currently my query runs a stored proc that returns the hours as in HH:MM format, rather than decimal hours, as our users find that more intuitive. The problem occurs when I try and...
I have a (parent) report that has a list. The details group of this list contains one sub-report. So basically if the list has 10 records (rows) the sub-report is executed 10 times. The problem seems to be with interactive sorting in the Sub-Report. It has 4 columns with interactive sorting enabled. When I run the parent report and try ...
I'm using ASP.NET 4.0 Visual Studio 2010 RC version Sql Server Report Services (SSRS) ReportViewer and are aware that columns only display on PDF export - not the preview. I want to use a matrix embedded in a table on a page that has multiple columns. I've done some testing and frustratingly found that if you have a tablix with at leas...
Hi Experts, Is it possible to change order of records/groups in a result-set from a query using Group By? =>I have a query: SELECT Category, Subcategory, ProductName, CreatedDate, Sales From TableCategory tc INNER JOIN TableSubCategory ts ON tc.col1 = ts.col2 INNER JOIN TableProductName tp ON ts.c...
In the SSRS 2008 versions of my reports, I placed the headers for my tablix groups into the report header. Using expressions in hidden tablix columns, I set custom code variables which I then referenced in the header (my headers are concatenations of several report items, so i can't directly reference the report items). This worked fin...
Folks, I have a really odd behavior here: I have a SQL Server 2008 Reporting Services report which gets grouped and sorted dynamically. One of the column in my data set which I display is called LanguageId and I was trying to get a grouping going by this LanguageId field. I checked, double-checked and triple-checked the data being retur...
I have a table with the following columns and data Category Item Price Tax A I1 1.00 .01 A I2 2.22 .02 B I3 3.33 0.3 I want to group on Category and have the details below such as: Category/Item Price Tax A I1 1.00 .01 I2 2.22 .02 B I3 3.33 .03 I want the category to have its own row then the detail rows below with the item in th...