Is it possible to transform the format of a date value that is passed to the query? I am trying to create a report that interfaces with a SAP back-end, but the query uses a different format for date objects. I need to take the selected date and reformat it to "yyyy.mm.dd" (including the quotes). Is this possible? I can do it as a textbox...
Ok I'm working on a little project at the moment, the Report expects an int but the ReportParameter class only lets me have a value that's a string or a string[] How can I pass an int? thanks dan ...
I have a report that renders data returned from a stored procedure. Using profiler I can catch the call to the stored procedure from the reporting services. The report fails stating the report timed out yet I can execute the stored procedure from SSMS and it returns the data back in five to six seconds. Note, in the example test run o...
How do I configure SSRS/Windows Server 2003, so that I can setup email delivery via a remote SMTP server that requires username and password. I can configure SSRS with an SMTP address and other parameters, but nowhere is it possible to configure it with smtp username and password. I have hunted around, but can only find vague referenc...
Would it be possible to define layouts depending on the report type? ie. The layout size for PDFs would be different from the web layout. Let's say we publish the report to the web. The user has the option of exporting this custom report to PDF. We want to be able to specify how the report should look like when exported to PDF. ...
Hi Reporting Services 2000 Standard Edition (currently RTM but hope to have SP2 soon). I have a report which takes in a parameter - PlantID I'd like to email a pdf of this report every month to the 80 different plant managers So I have a table: PlantID ManagerEmail 1 [email protected] 2 [email protected] 3...
We have are relatively simple Reporting Services report that our users commonly export to Excel. I've noticed that the files produced by the Excel export seem unusually large. If I open one of these files and just click save, without making any changes, the file size reduces to about half of it's previous size. Has anyone else run into t...
Hi, We have a CGI based web report framework written in C/C++. The CGI client connects with proprietery code which in turn connects to database. We are looking for a better Java based replacement for CGI due to performance, maintenance and probably security factors. Can Jasper connect with the proprietery code? Or will Servlet be e...
I'm working on a report in SSRS (SQL Server Reporting Services) right now, and I'm having a problem getting a rectanlge I draw on the page in the report designer to grow. Basically, I've got a rectangle drawn, and then I put a text field inside of it. The contents of this text field can be either very short or very long, so I want it t...
I'm trying to change the background color of single cell be based on a string value and wanted to see this expression code. I was reading a similar question here, but this is not the exact same issue I'm trying to solve. ...
Hi, i am trying to setup SQL Reporting services on windows vista, iis7 but i keep getting this error when i try http://localhost/Reports/Pages/Folder.aspx **Server Error in '/Reports' Application. Request is not available in this context Description: An unhandled exception occurred during the execution of the current web request. Plea...
I have a user sign off report where it shows a users rights/access to the system which all fits nicely onto one page when I hit preview. However when I then go to print layout it shows me two pages with the second page only containg the footer. Any ideas please? ...
I have a report that is used by a windows service and a form application. So, I want to put embed the report in a DLL file that can be used by both. The problem is that if I try to set the ReportEmbeddedResource property of a ReportViewer control in my windows form app, it will search the windows form app for the resource, not the dll ...
Which perfoms better: Crystal Reports or SQL Server Reporting Services? ...
One of the many quirks of Reporting Services we've run across is the complete and utter lack of a CheckBox control or even something remotely similar. We have a form that should appear automatically filled out based on information pulled from a database. We have several bit datatype fields. Printing out "True" or "False" just looks si...
I'm having trouble with SQL Server 2008 (Express with Advanced Services) Reporting Services permissions. I'm running this on Vista Ultimate at home - standalone machine with no servers, no domain or active directory. When I go to the ReportServices site, I get this: The permissions granted to user 'localmachine\Scott' are insuffi...
The following doesn't work, but something like this is what I'm looking for. select * from Products where Description like (@SearchedDescription + %) SSRS uses the @ operator in-front of a parameter to simulate an 'in', and I'm not finding a way to match up a string to a list of strings. Help! ...
I am using the ReportViewer control from Visual Studio 2008 in Local Mode with objects as the data source. My classes are mapped to data tables in my database. In the objects, it loads related objects as needed. So it leaves the reference null until you try to use the property, then it tries to load it from the database automatically. Th...
I have a table and an associated chart contained within a 'list' object in SSRS 2005. I am using an expression to determine the visibility of the table and chart, however when the table and chart are not visible an ugly large blank space (where they would otherwise have been rendered) appears in the report. Is there any functionality t...
I have a need to determine what security group(s) a user is a member of from within a SQL Server Reporting Services report. Access to the report will be driven by membership to one of two groups: 'report_name_summary' and 'report_name_detail'. Once the user is executing the report, we want to be able to use their membership (or lack of m...