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'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 ...
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...
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 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...
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...
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:
...
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.
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...
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?
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'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...
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 ...
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...
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...
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...
SQL Reporting Services. SRS. Reports
How can I make the last column of a detail item underlined ? I don't want to underline every row, just the last one. I imagine I need some type of e...
I would like to know if there is any possibility in SSRS 2005 to make report with an comment text box so the user can write comments that appear in the report?
