Hi,
I am working with one example on SQL Server 2005 Reporting Services. I have a stored procedure with two parameters. I want to call this stored procedure from SQL Server Reporting Servic...
Hi,
How do I modify my query so I can pass a list of integers? Currently my query clause looks like:
WHERE c.ContractStatusID IN (@ContractStatusID)
and when i look in sql profiler t...
I am new to SSRS and have created three reports in VS2005 and all seems to work fine in preview mode and when referenced via the URL and reporting services. The URL is something like this:
...
I'm a new SQL Reporting user and could use some guidance.
Here is a simple explanation of my application: imagine a report which prints out a grade report for each of 10 students. Depending...
I'm trying to develop a report for a client. This client manufactures shutters for houses. This is a production Worksheet report (Cureently designed as a matrix report. Along the X-Axis is ...
Hi,
We prefer adding a line at the end of the table showing the date time of when the report was run. It looks something like:
Report run at: 2/25/2008 3:17 PM
When a user exports thi...
Hi,
I have a sql report that runs on a SQL 2005 reporting server. The business requirement is that the excel formulas be downloaded when the user downloads the report in excel format. It is o...
I am working on a police special investigation system. I need to generate 5 different reports based on selection data. There will be sometimes 40 or more parameters that will be passed but the...
I am publishing the SSRS report to users using http://localhost/ReportServer/myReportName. By default, this displays the report with PARAMETER tab at the top. I would like to collapse/hide the...
I am writing an SQR and extracting data from a PeopleSoft record and creating a text file. One of the fields is PS_LAST_NAME and I need to exclude the hyphen from the name and print a space i...
One of my text fields (update_action) once rendered in HTML ignores the carriage returns, tabs, etc. Do you have any advise, recommendations, samples, codes, etc. that would help me fix the pr...
I need to embed a barcode font in a report and export to a PDF to send to client.
This problem began following a server change from a box running sql server 2000 to a different box running sql server 2005. the server is running Server 2003 sp2. I have tried several sugges...
Hi!
I'm fairly new with Reporting Services, but I've worked with SQL and VB.Net for a number of years. In a SQL Server Reporting Services report, I've put the Report Title in the "Descrip...
Hi,
I have imported some Access reports into SSRS. The Access tables and queries were also converted to SQL Server. The converted reports work for the most part, but some of the reports u...
Does anyone know if there is a similar function to WhilePrintingRecords; in SQL Server Reporting services? If not, how can I force each record to be processes and outputted in SQL Server Repo...
I'm creating for a client a standard letter in SSRS 2005. As my client often needs to send out letters to foreign clients, there is up to 4 fields for the address in the database. When sending...
I need an expression that show a certain field based on a parameter input
--
=iif(Parameters!NetorGross.Value = "Net",Fields!EndbalanceNet.Value,
iif(Parameters!!NetorGross.Value = "Gross...
I have a report that I would like to have a comparison of values in two textboxes done to determine if one should be highlighted. The trick is that each produce a number with a percent. I can ...
My report has a detail section. I have attached an excel example of my data file. In Reporting services I have added an additional field to separate out correct value from the last three fie...
Hello -
I've developed a number of basica reports with drill down etc. and I've come across something I have NOOOO idea how to handle. Basically I have a report that can have a dynamic nu...
Whilst I believe that a date picker is available in SRS 2005, for a number of reasons, I am having to use 2003 and would like to be able to select dates in the report parameters via a date pic...
Hi, I have an rdl report file I created in SSRS 2005. The report has to logos included but when I deploy the rdl file to the CRM, those images does not appear in the report. Is it possible tha...
I have a list and inside the list is a number of subreports. Is there a way to restart numbering at the start of each new list item / subreport grouping?
Hello,
I don't need a solution, I just need a starting point.
When I run a report from SQL report manager I run it for a certain user (userid is a parameter for the report). I have a...
