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...
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.
I have investigated about this topic. I found out that the PDF Rendering of Reporting Services did not support font embedding in 2000 and 2005 versions. I also found some discussions an...
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 am developing a report that displays the names of the account, but since there are 2000 accounts it takes lot of pages, so i want the report to print the names in 2 columns side by side,
i...
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'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,
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...
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...
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...
We are in the process of upgrading our PeopleSoft database platform from SQL Server 2000 to 2005. During our testing we ran into a problem with 2005 in that it requires the use of ANSI Standa...
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...
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 am trying to craft an expression in an SQL Report field. It is a group level calculation, counting specific records in the result. Basically the logic goes like this:
If field RATING has ...
i have a report where i need to put some running totals in the header of my . I am new to sql server reporting services. what is the best way to take this on?
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...
We use an alias DNS to indicate a location of our SQL repositories. The respositories were moved to a different location and the DNS pointed to that location. Now we get the above error when...
I need to embed a barcode font in a report and export to a PDF to send to client.
Hello
I have serveral users coming up with an error message when they try to view a report, and with an auto refresh report, after a 10min duration:
An error has occurred during report ...
Hi, I have created a report and this report has 3 subreports and the problem now is When I am exporting this Report to Excel The subreport links are being activated and when I click on the Lin...
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...
Hi ,
I have two input parameters orderid ,customerid. User can enter either orderid or customerid. I have created Stored Procedure for OR condition.Its working fine in sql server. Now iI have...
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...
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...
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...
