Where Do I Post Reporting Services 2005 Questions

How To Do Post-build Events In Reporting Services 2005

Does anyone know if it is possible to do Post-Build Events in Reporting Services? I am using Visual Studio 2005 Team Edition and creating Reports under the Business Intelligence Projects.

When creating C# projects, when you right click on the solution and go to properties there is a tab for Build Events at which point you can create Pre-build and Post-build events; however I am not finding this option available within a Reports project. Does anyone know if this is possible to do in Reporting Services?

Basically what I am trying to accomplish is, I am having to create multiple template files and there are multiple developers going to be working on this project and I would like to create a batch file of some sort that copies the template files that are created into the IDEPrivateAssembliesProjectItemsReportProject directory each time the project is built.

Thanks for any advice,
Flea

Cannnot Get The Method=POST Value After Calling The Reporting Services

I have two ASP pages. Page 1 has a button that when pressed, it will display page 2. Page 2 has a button that will call the reporting service (by a URL) . The button on page 1 has the "method=post" to pass a value to page 2. Page 2 wlll use this value as variable to the reporting service.

It works fine for the first time calling the report. But after that, I go back to page 1. When press the button on page 1 and go to page 2, it cannot get the value. Is that something wrong with the reporting services.

Questions About Reporting Services....

Hi all. I have many concerns on reporting services. Hope you help me alot explaining as I fully undestand it.

1. I am new in reporting services. Anybody can tell me the BIG difference of SQL SP1 and SP2?



2. Can anyone give the SHARED FUNCTION/ aggregate method not being supported by the aggregate functions. (These are the methods written in REPORT CODE)...



3.I have REPORTS(Business Intelligent Project) on my local machine hosted to the report services of the MACHINE SERVER. Then, reports are shown in REPORT VIEWER in my C# WINDOWS application project. My question is : How can other workstations run the same reports(Reports that I made)? We are using Team Foundation Server(TFS) to share the REPORTS and C# application project. I not yet tried to share the report, however I am expecting the report will work in other workstation. Is it?



4. Reporting services will only run in IIS, right? and you need first to RUN the SQL MANAGER, right? I have 10 workstations and 1 SERVER MACHINE. I made the SERVER MACHINE as the report server. Am I doing right? or Am I thinking the right idea/approach? Give me guidance on this...



5. What are the advantages of the reports being hosted to the reporting services? or shall i say, what is the difference of the crystal report to the reports hosted to the reporting services.



.:. Edit...(Added)

6. Can someone tell how to set the datasourcecredential in my c# windows application? I see the methods in MSDN but I really don't know how to use the methods.



7. How to set the reports directly to PRINT LAYOUT MODE if I preview it?



Thanks.
-Ron-

SQL Server Reporting Services Questions

I've installed SQL Server Reporting Services and designed few useful reports on local workstation, now I want to deploy those on the production reporting server.

I have the following questions:

1) We have some demo databases with the similar structure so the the same report would fit all the demos.
Is there any way to change the connecting string for the report programmatically without recreating report each time ? May be there is a way to pass database name to the report (encrypted) ? Is there any way to

2) I'd like to be able to protect those reports from unauthorised users ? Is there any way of doing that ? Is there any way to set up security on the base of folder anf for the whole group of reports ?

Thanks

Mikhail

Reporting Services To MS Word Questions

Hello

Where Should I Post Questions On Sql?

Reporting Services - A Couple General Questions

A couple questions about SQL Server Reporting Services:
 1. Can it be used for other data sources besides SQL Server (Oracle db, XML files, via APIs, etc.)?
2. Can it do ad hoc reporting? I like the "universes" that the SAP Business Objects product allows. Does Reporting Services have something like this, to provide a simplified view that non-technical business users can use to create their own reports? Or is Reporting Services just the equivalent to Crystal Reports?
 
(I wanted to post this in the general MSDN forum for SQL Server, but I can never log in there for some reason.)

High-level Reporting Services Questions.

Hello, we have a customer-facing ASP.NET web reporting application that allows the user to a). select a report b). make report settings (filter, sort, include/exclude columns), and c). run the report. An Oracle stored proc is used to return the data into a DataSet. Today the output is displayed in a bound, paginated DataGrid.

We€™d like to €˜plug-in€™ Reporting Services for improved formatting, grouping, matrix reporting, drilldown, graphics, etc.. I have read through the online docs, examples, and tutorials but have not found the exact (high-level) information I€™m looking for.


We need to keep our report settings page, Oracle SP architecture, etc... Is there a way to simply hand off a dynamically created DataSet to a report for display €“ like binding to the DataGrid? The data (query) would be specific to a report but columns can be selected/unselected for display.
In terms of deployment, is it necessary to install SQL Server in each environment (DEV-Integration, QA, PROD) to support Reporting Services? Since we are essentially an Oracle shop, this could be a tough sell. Is it possible to develop the report on a dev workstation (perhaps with SQL Server), and then publish to a web server where SQL Server is not installed?

These are obviously high-level questions - any help will be appreciated (examples, how-to's, etc..) €“ thanks in advance.
-Bill

Writing Reports/Extracting Data/Header Info/Reporting Services (2 Questions Really)

 I have a program where I have to do a weekly data upload of approx 1,500 records. I've written the sql, but need to know how I can add static header text to the SQL statement.the text I need in the header is Reportname(Static  string) + #rows (Rowcount of the sql,  int) + department (String static) I'm planning on writing it and saving it as a package, then schedule it to run every Friday at 5:00.  But I have been reading a little on Reporting Services and wonder if people think it' might be the way to go? Is it a whole new area of security issues? Or is it worth installing and learning? I will have more and more reports I need to write that will increase in complexity, and want to know if I want to keep writing querys by hand, or use reporting services. Thanks in advance! Dan 

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Hello,

I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?

Any help is appreciated

Few Questions Regarding SQL Reporting Service 2005. (PageBreak)

Hi,

During last year, I developed more than 200 Reports using SQL Reporting Service. It is really fantastic and in many ways it has reduced lot of work.

But still I am not able to find out solution of following issues,

1) Where to set portrait or landscape printing mode? It takes based on paper size, if 8.5 x 11 then portrait else landscape.
Now I want to set myself in report irrespective of page size then HOW TO DO IT?
2) I want to set Height, Width and Merge cells options based on Expression like many other things we do, ex. Font, Text Align, Visibility, etc€¦ HOW TO DO IT?
3) I am not able to find out option for Vertical Cell merging? Is it available or is there any trick?
4) If entire group or table can be printed within a page then it is fine but if page break occurs then I want to print Entire Group or Table on next page.
In many cases you can€™t allow page break like, Pay Slip of Salary, Purchase Order Month Wise Schedules, etc€¦
So some option should be there like €œInsert Page break if table or group is not able to fit on current page€? HOW TO DO IT?
5) Is there any way to know that there is page break in this Table or Group?
6) Can I Insert Page Break based on Expression?

Theses problems really create headache. There must be some solutions.

Kindly Help,

Nilesh

SQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue

Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks

Please Post Setup And Installation Questions In The Setup Forum

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

Analysis Services 2000 + Reporting Services 2005 + Parameters

Hi All,

I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?

Regards,
Joseph

Reporting Services 2005 And Analysis Services 2000

Hello,



i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??

thank you
regards
Andreas

Reporting Service Post Back Issues

I have developed a report in which I have two date parameters. when I deploy the report and view the report
I can see that for each date selection it is going for a postback. could you please advice me how can I solve this issue.

Visual Studio 2005 - Reporting Services 2005 Access Import Error

I am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.

Can We Install Reporting Services 2005 In A Machine In Which Is Not Installed SQL Server 2005

Hi,


Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?

Thanks

Problem - SQL 2005 Reporting Services Addin For Web Developer 2005 Express....

Hello,

I'm trying to make some reports using the sql 2005 reporting services addin for Visual Web Developer Express 2005. I download the add-in here. So far it installed "successfully". The problem i have is when i try to add a datasource to the report at "Report > Data Sources... " it gives me an error saying: "The system cannot find the file specified."

Another Error it gives is that when I try to drag a DataSet field from the Website Data Sources toolbox tab the visual web developer crashes :/.

An observation that I don't know if this is ok is when I create a new Data Source it creates an App_Code folder inside where my report is /Reports/ and there it saves the DataSet. Just an observation...


This is my development enviorment:

Laptop:

Windows Vista Home Premium (Up to date)
Microsoft Visual Web Developer 2005 with Service Pack 1
Reporting Add-In for Microsoft Visual Web Developer 2005 Express

Server:

Microsoft Windows Server 2003
IIS 6.0
ASP.NET 2.0
Microsoft SQL Server 2005 Express
Reporting Services for SQL Server 2005 Express


Here are some pictures of the erros:


Error 1

Error 2

Please could someone help me fix this?

Thanks in advance.

Reporting Services 2005 (VS 2005) Using Oracle 10g Stored Procedure

Hi,
I want to get data from Oracle 10g Stored procedure to Reporting Services 2005. I could pass a SQL text and get a record set, but I want to execute a store proc and get the record set.


1. Add New Data Source
2. Choose Type : Oracle and connection tested OK
3. { call Test_Package.Test_Procedure(?) } is it wrong... how to write???
There is an error in the query. ORA-00911: invalid character


Also make sure that you use the text-based generic query designer (2 panes !) instead of the visual query designer (4 panes) - you can switch between them through an icon on the toolbar in the data view of report designer.
Question : I tried many methods but unable to solve it...

create or replace
PACKAGE Test_Package
AS TYPE Test_Type IS REF CURSOR RETURN Test_Table%ROWTYPE;
END Test_Package;


create or replace PROCEDURE Test_Procedure (
Test_Cursor IN OUT Test_Package.Test_Type,
Test_Parameter IN Test_Table.ID%TYPE
)
AS
BEGIN
OPEN Test_Cursor FOR
SELECT *
FROM Test_Table WHERE Test_Table.ID >= Test_Parameter;
END Test_Procedure;

The below site gave some example but i could not solve it... any suggestions greatly appreciated...

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=357121&SiteID=17


http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/bbc613c4529ed3cd/696624ec4ba70937?q=oracle+stored+procedures

Integration Services :: Post To A Web Service Using SSIS

I have a table is SQL server database A that is my source.

I have another database B which is accessed via webservice call.(its a CRM server basically).

My intention is to transfer data from A to B while B is accessible only via web service. I need to Trasnfer the data from the source database A to the destination Database B by calling the webservice.

Is there a way where I can retrieve whole set of rows in source table in preexecute(), And transfer the data to Database destination B by calling the webservice?

New To Reporting Services 2005

I'm using Report Builder to create a new report. The problem I'm having is that once I choose a Field from an Entity in the Entities list I can only choose Fields from that Entity. For example, I have two Entities, one called Customers and the other called Delivery. Within the Customer Entity I have several Fields that I want to add to my report, say First Name and Last Name. From the Delivery Entity I have a Status Field which I'd like to include but because I have no way to get back to my Entities list, without removing the Fields from my Report, I can't include that Field.

If I remove the Fields from my report, the Entities list then populates with both the Customers and Delivery Entities, THEN I can choose my Delivery Entity and select the Status Field. But I can't get back to the Customer Entity. I keep going back and forth.

I'm not exactly sure what I'm doing wrong, or if there is a more efficient manner to accomplish what I'm trying to do.

Thanks.

Reporting Services 2005

What is the best option to monitor user accesses to published reports? IT department wants to have an idea about the need (value and time) of produced reports.

Regards,

Vitor Mota

Reporting Services In 2005

Hi,

SQL 2005 Reporting Services

Hello All,



I am getting the following error while I am connecting SQL 2005 reporting services through local and outside



http://localhost/reports

http://servername/reprots



I configured through all the stems through reproting services configuration

You advise/suggestion is greately appriciated.



Ven



---------------------------------------



Server Error in '/Reports' Application.
--------------------------------------------------------------------------------

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowElementMissing(String element) +41
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1104
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32

[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.Global.get_Configuration() +4
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

SQL Reporting Services 2005 With CLR

Hi,

I am trying to use reporting services 2005 with a VB SQL stored procedure that i created in visual studio using CLR.

The stored procedure was created successfuly in SQL server but while linking the report to the stored procedure, i am receiving the following message
"An error occurred while retrieving the parameters in the query.
The stored procedure 'mysp' doesn't exist.

 

Thanxs in advance

 

 

 

 

Sql Reporting Services 2005

I have a sql server 2000 database and sql server reporting services 2000 installed on it i want to install 2005 sql reporting services on sql server 2000 Is Sql server reporting services 2005 works fine with sql server 2000 and what are the settings that i have to perform.

Reporting Problems W/ MS SQL Server 2005 Reporting Services Step By Step To MS

I am trying to learn Reporting Services using the title "MS SQL Server 2005 Reporting Services Step by Step" by Stacia Misner and Hitachi Consulting, published in 2006. I am experiencing problems with some of the exercises. I got as far as Chapter 4 when I followed directions to create a SQL statement to define a query string for a dataset. Pg 80:



select * from vProductProfitability

where year = 2003 and

MonthNumberOfYear = 1



The view vProductProfitability does not exist in the tutorial database that came with the book, rs2005sbsDW. The result of this query is the basis for the entire chapter on developing basic reports and I'm being denied a learning opportunity because the view does not exist. In short, I'm stuck.



I have tried to find somewhere at Microsoft to place this question and get some answers so I can continue thru the tutorial. To no avail. Does anyone have any suggestions?



BTW, the solution that came in the CD is also wrong because the query noted above is also in the solution.



This humble grasshopper seeks wisdom.



Respectfully Submitted,



Dave Matthews

Atlanta, GA

aka FlooseMan Dave

SQL Server 2005 And Reporting Services

Why doesn't SQL Server 2005 need IIS for its http readiness while its Reporting Services do? Thanks.

How To Enable SQL 2005 Reporting Services?

SQL was installed w/o reporting previously by the other admin. How do i enable the reporting now?

SQL 2005 Reporting Services Location

My first installation of SQL 2005 requires the use of Reporting Services. Is Reporting Services always installed on the same server as SQL Server 2005 or do I have the option of having it run outside of the database server? If I have this option, is this something that Microsoft recommends? I'm concerned with having IIS and SQL Server on the same server, however if that's the new 2005 best practice then there's not much I can do about it.

Thanks, Dave

Installing Reporting Services 2005

Hi there

We've got 2 servers: one is dedicated database server (NSWNOFUSQD01) and the other one is application/web server (NSWNOFUAPA01).

We've installed the SQL server Database Services, Notification Services, Integration Services and Workstation components, Books Online and development tools into NSWNOFUSQD01 (databases server).

We leave Reporting Service cause we don't want to install the application on this box but we want to install onto different box but the reporting database need to install into NSWNOFUSQD01. So we've tried to install the reporting services into NSWNOFUAPA01 - app server. But while installing it we don't have an option to tell that the database is pointing to different server?!?!.

Any ideas? Are missing step here? I saw these environment working - web instaaling on the app server and database installing on database server.

Thanks