7
голосов
4ответов
15495 просмотров

New to SSRS - Where is the Report Designer

I just watched a video regarding the Report Designer. It said to go to Start, Programs, Microsoft SQL Server 2008, Reporting Services, and then select the Report Designer. I'm certain I installed everything, but I do not have this program. I have VS2008 Professional Version installed and SQL S...

0
голосов
2ответов
121 просмотров

Archiving Reports SQL 2005 Reporting Services

Is there a way to configure the Report Server to Archive the reports to the Report Server or to a path on the File System. I need to save the reports generated as .pdf files.

7
голосов
5ответов
14694 просмотров

SSRS: Relative URL Hyperlink

In SSRS 2008 I would like to create a relative path URL. Long story short I have a subscription that outputs a few thousand static HTML pages to a folder that is used as content for a website. In the past I have created full URLs to other pages on the site (sub-reports, really) using Text Box P...

0
голосов
1ответов
248 просмотров

How to use HTML entities in an SSRS report?

In a SQL 2005 Report Server Project, how do you put an HTML entity (such as & or Δ) in the value of a column's header Textbox?

1
голосов
1ответов
2914 просмотров

Is it possible to set page layout for an SSRS report using report parameters?

I'm using SSRS to generate reports in my app. My app calls the web service behind the scenes. In some cases I render the report using the ReportViewer web control, in other cases (if user is using Webkit based browser for example), I just allow them to download a pdf of the report. I set the r...

6
голосов
6ответов
9853 просмотров

Visual Studio 2005 doesn't support Sql Server 2008

I'm developing Reporting services on VS2005 and have to connect to SQL Server 2008. The following Error occurs: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later." I found on the net a patch for it, but it doesn't work (link to patch) "The upgrade ...

0
голосов
2ответов
634 просмотров

strange SQL server report performance problem related with update statistics

I got a complex report using reporting service, the report connect to a SQl 2005 database, and calling a number of store procedure and functions. it works ok initially, but after a few months(data grows), it run into timeout error. I created a few indexes to improve the performance, but the str...

0
голосов
1ответов
123 просмотров

Where is the displaytag of scheduled reporting?

So I have been making some reports and using displaytag to output these reports in html, csv, excel, pdf, etc. They are paginated, and take a simple object graph... and output excellent results everytime, with very little code. However, I need to use displaytag or its equivalent outside of a ...

1
голосов
2ответов
1614 просмотров

Report Server option on SQL Server Management Studio Express?

I want to connect to a SQL Server Reporting Services Report Server from SQL Server Management Studio Express. Unfortunately there is no "Report Server" option in the "Server Type" drop down. Am I missing something here?

2
голосов
1ответов
5153 просмотров

SSRS 2005 How-to: Headers for groups within groups?

It seems pretty straight forward to get what I want. The data details display correctly but I can't get the headers to cooperate. I have n number of clients with their activity in the report. I want the client name in the header, and then the column names below that. But I either get columns re...

0
голосов
2ответов
4437 просмотров

How to use Floor/Ceiling in a ReportModel expression field?

I'm working in an SSRS 2005 Report Model Project. I want to create an expression field on a ReportModel that does the same as this C# method: private static int GetClosestWholeNumberToward0(double delta) { return (int) (delta > 0 ? Math.Ceiling(delta) : Math.Floor(delta)); } I tried thi...

9
голосов
5ответов
12921 просмотров

Is there a way to put subreports in headers in SSRS?

I would like to use a sub report, since it gets used on many reports, in the header. However, sub reports won't go into the header and neither will field values. Although, parameters will go just fine. Any suggestions or references for how to bypass this?

1
голосов
1ответов
1356 просмотров

gaps between charts in Report Builder due to table beneath

This seems more of a SuperUser thing but I didn't see any Report Builder or SSRS tags there. Move if it's in the wrong place, please! When I create a report in Report Builder 2, I often have charts on top and then a table underneath. The problem I encounter is that some charts get shoved over ...

0
голосов
1ответов
106 просмотров

How to prevent items from going to another page in Reporting Services 2005

I currently have the following problem : i have two matrices in the same report, but the second keep going to a second page. In fact, at anytime, I would like all my documents to fit on one page only. The use of pages in html is just a pain, as it is in excel format, by the way. My question c...

1
голосов
1ответов
3745 просмотров

How can I trap "View Report" in ReportViewer (webforms) for SSRS?

I am using ReportViewer.WebForms in asp.net page. I have the parameter toolbar showing up where I can select a parameter, it does a postback to get the next parameter (dependent on the first), and so forth. When I click the View Report button there is a postback and the report will display fine....

1
голосов
2ответов
2695 просмотров

CRM_URL Report Parameter is incorrect

I am building custom reports in Microsoft CRM and am using the CRM_URL parameter to created drill downs. However, the URL coming in is ***http://**myserver.com/org/CRMReports...* but it should be **https://**myserver.com/org/CRMReports... My understanding is that this value is dynamically passe...

1
голосов
3ответов
2786 просмотров

Sending SSRS credentials via C# application

I am currently working on a C# application for my company that goes out to our SSRS server, runs specific reports, formats the excel reports in the application, and then spits them out to a location. The application is working as intended and there is just one little annoyance. Every time a speci...

1
голосов
2ответов
5748 просмотров

PDF Export issue in Reporting Services

I have come across an error when exporting a report to PDF in Reporting Services 2008. The error message is; Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack tr...

0
голосов
1ответов
55 просмотров

Resources for Analysis Server and Reporting Services

What are the best resources for Analysis Server and Reporting Services in your opinion? Community based or otherwise.

0
голосов
1ответов
119 просмотров

Server Name not valid in Connect to Server: Reporting Services

I'm trying to step through the Data-Driven Report Subscription setup, but I can't get past Step 2 of Part 2. I get no options for Server name other than "browse", which only turns up two instances on the local network. I tried the alias I use when connecting to the Database Engine (via the SQL ...

1
голосов
2ответов
1431 просмотров

Parameter to select the chart type to be displayed on web

I'm looking for a parameter which allows a user to select the chart type (X-Y scatter plot, bar plot, line plot etc.) from a drop down menu on a website which is interfaced with SQL Server Reporting Services. Is there any such parameter available? If not then are there any other means to accomp...

0
голосов
1ответов
765 просмотров

Parameters in SSRS

I am trying to develop a report in SQL Server Reporting Services using parameters. I have no problem creating the parameters and running the reports, but I always have to select an item from each of the parameters to make it run. Can I have the option to leave one of the parameters blank and st...

1
голосов
1ответов
473 просмотров

Report with sub-report not generating in Reporting Services 2005

This is my first attempt at employing sub reports and my overall experience with reporting services is minimal (edits to existing reports, creation of some basic reports). I have added a sub report to a an existing report. The sub report returns in about 1 second when tested separately. The que...

0
голосов
1ответов
996 просмотров

Reporting services subreport column sorting failing

I am working on a SSRS 2008 reporting solution and I am running into a problem with a subreport not interactively sorting columns with the asp.net report viewer control. The report itself is completely functional when it is not used as a subreport, but once I add it to another report as a subrepo...

2
голосов
1ответов
4905 просмотров

SSRS- charts colour coding

I have SSRS solution for SQL 2005 and 2008. I am showing output in the form of chart- column chart with each column representing different database. Is there a way to display each column in different color? Regards Manjot

1
голосов
2ответов
3055 просмотров

How can I display two rows worth of data on one line side-by-side in Report Designer?

I am using SQL Server Reporting Services 2005, and I'm developing a report in Report Designer/Business Intelligence Studio. Right now I have a normal-looking table that displays data like this: ---------------- | A | B | C | ---------------- | A1 | B1 | C1 | ---------------- | A2 | B2 | C2 | ...

0
голосов
2ответов
4829 просмотров

Blank Web Service Identity, SSRS, Configure Report Server

I am currently setting up a Sql Server Reporting Services onto a Windows 2000 server with IIS5 and SQL Server 2005. The only thing I cannot get to configure is the Web Service Identity, in that the ASP .NET Service Account is blank and is read only. I have tried adding the ASP account (machinena...

0
голосов
1ответов
282 просмотров

Displaying Aggregates Across Overlapping Ranges in a Reporting Services Matrix

I'm having a problem displaying the values for a range of dates in a matrix row. I would like to have a matrix display the following data: Trial Existing Total Yesterday 3 1 4 This Week 5 3 8 Last Week 18 5 23 Month to Date 26 9 35 La...

0
голосов
1ответов
845 просмотров

Debugging Paging in Sql Reporting Services

I'm working on my first significant Sql Reporting Services project and am having problems with paging. Most of the reports are already working. What is happening is that I"m getting different numbers and locations of page breaks between Web Reportviewer, PDF and Word documents. The word is the...

2
голосов
2ответов
12827 просмотров

SQL Server 2008 - The report manager URL shows a page without Properties tab

I have SQL Server 2008 Developer Edition and I'm facing the following issues with the Reporting Services. When I open the Report Manager URL (I get it from the Reporting Services Configuration Manager) in a browser, it shows me a SQL Server Reporting Services page with a folder icon on top left...