0
голосов
3ответов
1995 просмотров

Sql Reporting Services 2005 продолжают длинную строку из одного текстового поля в другое текстовое поле

У меня есть отчет SQL Reporting Services 2005, который включает текстовое поле на первой странице. Строковый ввод для текстового поля может быть очень большим и включать символы новой строки. Размер текстового поля фиксирован, и на вторую страницу отчета включается еще одно текстовое поле для об...

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

Я хочу использовать службу отчетов SQL Server в приложении Windows на .NET?

Я новичок в ssrs, я хочу получить немного информации от вас. Могу ли я использовать ssrs в приложении Windows в .net, если да, то сообщите мне, пожалуйста? Заранее спасибо

2
голосов
4ответов
1864 просмотров

Принуждение таблицы служб SQL Reporting Services 2005 к отображению определенного количества строк

У меня есть отчет SQL Reporting Services 2005, который включает таблицу на первой странице.У меня достаточно места на первой странице, чтобы показать первые 5 пунктов из списка.Если имеется более 5 элементов, я хочу, чтобы список продолжился до другой таблицы на второй странице отчета. Я такж...

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

Группировка служб Reporting Services

Я новичок в службах отчетов и немного запутался. на снимке экрана вы можете увидеть, что я сделал. Ссылка на снимок экрана http://img219.imageshack.us/img219/8283/19206721.png У меня есть две группы: внутренняя - по имени сотрудника, а внешняя - по месяцу. Теперь я хочу посчитать, наприм...

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

Параметры каскадирования подписок на основе данных

Я пытаюсь настроить подписку на основе данных, и она работает нормально, кроме случаев, когда 2 параметра настроены на получение динамических значений вместо статических. Структура в основном Param1 -> читать из базы данных Param2 -> читать из базы данных Param3s -> читат...

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

Как ссылаться на функцию VB в группировке служб Reporting Services

Доброе утро, Я использую Reporting Services 2005 для создания одноразового отчета, в котором записи группируются в соответствии с полем PLANCODE. Я создал следующую функцию VB: Function PayorGroup (ByVal ipc as String) as String set ipc = PLANCODE Select Case ipc Case 'M01' to 'M99' PayorG...

3
голосов
2ответов
6479 просмотров

Службы отчетов sql - программная установка источника данных?

У меня есть несколько отчетов, развернутых как RDL для SSRS. Из-за высоких требований безопасности пароли базы данных меняются очень часто. Это стало огромной задачей - идти в ногу с изменениями и вносить изменения в десятки и десятки отчетов. Это приводит к моему вопросу ... Можно ли програм...

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?

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...

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
голосов
3ответов
3989 просмотров

Using the Visual Studio XML Editor on RDL files

When using Visual Studio to edit Reporting Services *.rdl files, the default designer used is from the "Microsoft SQL Server Reporting Services Designers" installed product. When viewing the RDL code, this code is displayed as plain text and I want to take advantage of the XML Editor in visual s...

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
голосов
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ответов
2722 просмотров

SQL reporting services report not showing date in correct format

i have built a reporting services report off SQL server 2005 and am having trouble getting the date to format correctly in a stand-alone textbox. The code i am using is as follows: ="Date: " & FormatDateTime(Parameters!date.Value, 2)) -- According to MSDN it should work off my systems cul...

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

SSRS 2005 Parameter Based Security

I work for company A. Company A has a sister company B. Both companies A and B use the same ERP database. I have created an SSRS 2005 report that can be used by both companies. It has a CompanyID parameter that determines whether to display data for company A or company B. For most reports this ...

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

SSRS Parameter Issue with ReportViewer

I have a Winforms application that uses the ReportViewer control to display SSRS reports. I have one report with many parameters that must be set by the user. I specifically set one of the parameters to have no default value so that the parameter prompts would display in the report viewer prior...

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

How to stop Reporting Services Blocking requests?

We are using Reporting Services 2005 on SQL 2005 and when a report is running then Reporting Services seems to block for that user. e.g. navigating in /Reports/Pages/Folder.aspx will wait until the report finishes before displaying anything. I have had a look at the rsreportserver.config file but...

2
голосов
4ответов
6949 просмотров

How can I change the source of a Data Source View and the Report Models based on it to a different database?

I have a number of reports deployed to a SQL Server 2005 Reporting Services server. They were all developed using the same Report Model (SDML) that references the same Data Source View (DSV) that points to a test database filled with mostly dummy data. Now, I would like to make those reports pull...

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

Creating subscribtion with Reporting services 2005

I have created a dynamic subscribtion. All work well, but if I create the subscrbtion on any month say like July 09, and select that I get the report of previous month on monthly basis. Now In month of August I will receive the report for the data of July 09 which is correct but after that in Sep...

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

Dynamically update one parameter based on the value of another

We have a report in SSRS 2005, where in we wanted to update one parameter(which is not linked to any other report parameters or dataset) based on the value of another report parameter(which is the selected value from a dataset). Can anyone let me know how to achieve this functionality?

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

Reporting Services Interactive Sort problem

I have a set of reports defined for Reporting Services in SQL 2005. I'm rendering the reports using the ReportViewer control inside an ASP.NET 3.5 application. In all the reports I have a chart and a table where interactive sorting is implemented. The sorting works perfectly when I test it on the...

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

Unable to load client print control from ASP.NET Website?

The other day we installed SQL Server 2005 SP3 on our reporting server. Since that point our ASP.NET 3.5 website, which uses the Report Viewer web control, is giving the error message "Unable to load client print control" whenever someone tries to print. The reports and printing work fine if ...

3
голосов
4ответов
1158 просмотров

Can I pre-process data before passing it off to SSRS 2005?

We are considering migrating to Sql Server 2005 Reporting Services. Many of our existing reports require pre-processing of the data before rendering it. For example, we have a query for a report that returns GPS coordinates (Latitude and Longitude) from a stored procedure, but before passing off...

13
голосов
4ответов
22365 просмотров

SSRS with Custom Web UI

Is it possible to create a custom Web front-end to run SSRS reports from? We have an existing cross-browser web front-end for gathering reporting inputs (for a non-SSRS platform) that we would like to see continue with SSRS instead. It includes domain-specific UI controls that have been develop...

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

Problem in SSRS with Matrix headings for non-data fields

Hi I have been working on a large matrix which displays the results of a stored procuedre with date fields for the dynamic columns. Prior to the dynamic columns i have several other columns of identifiers for the data. The problem i have is when i try and add column headings (in the tableheading ...

4
голосов
2ответов
5242 просмотров

How to force a textbox to split, rather than move to a second page in SSRS 2005 (PDF Export)?

This question is a follow up to my original question, I've done a bit more reseach, i narrowed a problem down quite a bit. I've also uploaded a sample .rdl to illustrate the problem I've got the following report setup: a header (image in the body), two textboxes, and a footer. First textbox has a...

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

Programmatically Add User to Report Server (SSRS 2005)

I would like to be able to programatically add a user to the report server by creating some stored procedure that accepts user_id and does inserts into ReportServer..Users and other associated tables. I am having trouble doing this (especially the column ReportServer..Users.Sid). Has anyone bee...

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

How to keep List contents on the first page? (SSRS 2005 - PDF Export)

I've got the following report setup: 1. Letterhead (not in the header, since i only want it on the first page) 2. List control with some data when i export the report to PDF, and the contents of the List are less that one full page - my letterhead is displayed on the first page (the rest of the p...

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

How can I control the subreport layout?

My business analysts have created 7 reports (using Report Builder) they want merged into a MEGA-report. I've been trying to do this by wrapping them all in subreports (which you can't use in Report Builder 1.0). While all reports show up, the layouts are all over the place. The subreports seem to...