Can report be created with code (XML, SQL, ActiveX?) using the new Reporting Services for SQL Server 2000?
I have to create a report and save it in Excel format. By default the report is saved as - *.rdl. but the web report server has an option of saving it as excel or pdf etc formats. Is there a way to do this automatically? ie by code and not manually
Please help
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
I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
Thanks to anyone who can help.
-- Mark
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
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
Yes folks that's right, I said SQL 2000 RS.
I have used SQL 2005 reporting services for quite sometime and now one of our clients wants the SQL 2005 reports that I developed. There's only one catch: they only have SQL 2000.
Is there any way to deploy my reports to their server on SQL 2000?
I have seen this done by someone else but cant seem to find how to do it...basically I have a sytle sheet which I want to use on all the Reporting Services reports, to so they all look the same....
Thanks
I am trying to get SQL 2000 reporting services up and running, and am trying to get a condensed explanation of what I need to do, and any other software I may need to purchase.
I have already installed the Reporting Services, and after reading the help, it seems that I have to install MS Visual Studio 2003 in order to design the reports. Is this true.
Anyone that can give me some help in getting this up and running - I would be grateful.
Thanks so much - Joe
Could someone assist me in setting up Data Driven Subscriptions for Reporting Services 2000?
Thank you in advance.
Ken
Hi
I have used Reporting Services 2000 to create a template, and works in a mail merge sort of way, creating a delivery note for each order.
The problem I have is, if an order goes over two pages.. I need a easy way to present this, so that the user knows to send two pages.... Obviously, the correct way would be to page it in some way but from what I understand, RS 2000 would page the whole documents (ie all orders) and there is no way of paging in respect to a group (ie order no)
The next option is to have cont. at the bottom of page 1 (if there are more than 1 page), does any1 know how to do this? cos of obviously on the screen it will always be 1 page???
I hope I make some sense... any help would be great....
Thanks in advance :)
When i save a report as a web archive page breaking for the report is not enabled ?The entire data is displayed in a single page even if paging properties are enabled for the report.
View 1 Replies View RelatedI am trying to figure how to programmatically pass parameters to the report in SQL Reporting Services using web service API and then send this report to the printer. I found code in C# on how to print and it does work very well. I am hoping to add report parameters to this module. Any ideas, samples or help would really be appreciated.
here is the code for printing
using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.Drawing.Printing;
using System.IO;
using System.Web.Services.Protocols;
using PrintReport.reportserver;
using System.Runtime.InteropServices; // For Marshal.Copy
namespace PrintReport
{
/// <summary>
/// A simple console application that demonstrates one way to
/// print Reporting Services reports to a printer.
/// </summary>
class app
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main(string[] args)
{
PrintExample pe = new PrintExample();
// The name of the printer should be added here;
// this could be a local or network printer.
pe.PrintReport(@"\jacc-fs120S2500 PCL IT");
}
}
class PrintExample
{
ReportingService rs;
private byte[][] m_renderedReport;
private Graphics.EnumerateMetafileProc m_delegate = null;
private MemoryStream m_currentPageStream;
private Metafile m_metafile = null;
int m_numberOfPages;
private int m_currentPrintingPage;
private int m_lastPrintingPage;
public PrintExample()
{
// Create proxy object and authenticate
Console.WriteLine("Authenticating to the Web service...");
rs = new ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
}
public byte[][] RenderReport(string reportPath)
{
// Private variables for rendering
string deviceInfo = null;
string format = "IMAGE";
Byte[] firstPage = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
Byte[][] pages = null;
// Build device info based on the start page
deviceInfo =
String.Format(@"<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>", "emf");
//Exectute the report and get page count.
try
{
// Renders the first page of the report and returns streamIDs for
// subsequent pages
firstPage = rs.Render(
reportPath,
format,
null,
deviceInfo,
null,
null,
null,
out encoding,
out mimeType,
out reportHistoryParameters,
out warnings,
out streamIDs);
// The total number of pages of the report is 1 + the streamIDs
m_numberOfPages = streamIDs.Length + 1;
pages = new Byte[m_numberOfPages][];
// The first page was already rendered
pages[0] = firstPage;
for (int pageIndex = 1; pageIndex < m_numberOfPages; pageIndex++)
{
// Build device info based on start page
deviceInfo =
String.Format(@"<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage></DeviceInfo>",
"emf", pageIndex+1);
pages[pageIndex] = rs.Render(
reportPath,
format,
null,
deviceInfo,
null,
null,
null,
out encoding,
out mimeType,
out reportHistoryParameters,
out warnings,
out streamIDs);
}
}
catch (SoapException ex)
{
Console.WriteLine(ex.Detail.InnerXml);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
Console.WriteLine("Number of pages: {0}", pages.Length);
}
return pages;
}
public bool PrintReport(string printerName)
{
this.RenderedReport = this.RenderReport("/SampleReports/Company Sales");
try
{
// Wait for the report to completely render.
if(m_numberOfPages < 1)
return false;
PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = printerName;
PrintDocument pd = new PrintDocument();
m_currentPrintingPage = 1;
m_lastPrintingPage = m_numberOfPages;
pd.PrinterSettings = printerSettings;
// Print report
Console.WriteLine("Printing report...");
pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);
pd.Print();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
// Clean up goes here.
}
return true;
}
private void pd_PrintPage(object sender, PrintPageEventArgs ev)
{
ev.HasMorePages = false;
if (m_currentPrintingPage <= m_lastPrintingPage && MoveToPage(m_currentPrintingPage))
{
// Draw the page
ReportDrawPage(ev.Graphics);
// If the next page is less than or equal to the last page,
// print another page.
if (++m_currentPrintingPage <= m_lastPrintingPage)
ev.HasMorePages = true;
}
}
// Method to draw the current emf memory stream
private void ReportDrawPage(Graphics g)
{
if(null == m_currentPageStream || 0 == m_currentPageStream.Length || null ==m_metafile)
return;
lock(this)
{
// Set the metafile delegate.
int width = m_metafile.Width;
int height= m_metafile.Height;
m_delegate = new Graphics.EnumerateMetafileProc(MetafileCallback);
// Draw in the rectangle
Point destPoint = new Point(0, 0);
g.EnumerateMetafile(m_metafile,destPoint , m_delegate);
// Clean up
m_delegate = null;
}
}
private bool MoveToPage(Int32 page)
{
// Check to make sure that the current page exists in
// the array list
if(null == this.RenderedReport[m_currentPrintingPage-1])
return false;
// Set current page stream equal to the rendered page
m_currentPageStream = new MemoryStream(this.RenderedReport[m_currentPrintingPage-1]);
// Set its postion to start.
m_currentPageStream.Position = 0;
// Initialize the metafile
if(null != m_metafile)
{
m_metafile.Dispose();
m_metafile = null;
}
// Load the metafile image for this page
m_metafile = new Metafile((Stream)m_currentPageStream);
return true;
}
private bool MetafileCallback(
EmfPlusRecordType recordType,
int flags,
int dataSize,
IntPtr data,
PlayRecordCallback callbackData)
{
byte[] dataArray = null;
// Dance around unmanaged code.
if (data != IntPtr.Zero)
{
// Copy the unmanaged record to a managed byte buffer
// that can be used by PlayRecord.
dataArray = new byte[dataSize];
Marshal.Copy(data, dataArray, 0, dataSize);
}
// play the record.
m_metafile.PlayRecord(recordType, flags, dataSize, dataArray);
return true;
}
public byte[][] RenderedReport
{
get
{
return m_renderedReport;
}
set
{
m_renderedReport = value;
}
}
}
}
Thanks
Tom
Hi there,
I have installed SQL Server 2000 Reporting Services with the default names for the virtual directories , (ReportServer and Reports). Is there any way i can change the name of these directories by running a script or some thing.
Also is there a way to use the Cascaded Style Sheet used in my ASP.NET application for the reports.
Thanks
We had someone leave work and he was responsible for the reports for our company. He used SQL 2000 w/ Reporting Services. The connection to the report server was tied to his userid and password. Since his account was disabled the website will not connect to the reporting database because it was tied to his account. Is there a way to reset the connection creditions? I looked on the server and I can't find the Reporting Services Admin Tool.
Thanks..
Hi
i am working in vs.net 2005 (c#.net & asp.net), my application need reporting functionality, for that i am using Sql Reporting Services 2000 in vs.net 2005, and i am not able to generate the report, can any pls tell me how to use sql reporting services 2000 in vs.net 2005 and configuration setting etc...
it would really help more to build my applications in sophisticated way
kinds regards
sy
I am intalling SQL 2000 Reporting Services on my Development Machine. Win Xp, VS .Net 2005 & VS .Net 2003. I do have ASP .NET 1.1 & 2.I am frustated even though I have ASP .NET 1.1 installed it kept complaining that it is not installed. I also tried registering ASP .NET 1.1 version through Visual Studio command Prompt.
Still it is complaining that I don't have ASP .NET 1.1
What I have to do?
Please help me.
Thanks in advance.
Sai
Hello there.
i would like to install Report Services on visual studio 1.1 version
using sql server 2000. i currently have sql server 2005 and visual
studio 2.0 and there is no problems and so i remember how that
works.
With sql server 2000 i saw a link to a trial version of reporting services that i can download and install but after 120 days it's no good. I think that provides the gui interface to install reporting
services like the 2005 version except less robust. But i'm wondering with the proper service packs of sql server 2000 installed if i can
bypass download.
Can somebody help me how to install reporting services with sql server 2000, pre-req and software i need. I currently have the
developer's edition of sql server 2000 already.
Please contact me at clalbert@flash.net
I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.
When I try to run the SP (on server X), I get the following message:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITYNETWORK SERVICE'.
Hi All,
I am a newbie to SQL 2000 Reporting Services. I have been given a task on installing SQL 2000 Reporting services on our servers. We have one database server (SQL 2000) with SP3a. We have one web server with IIS 5.1 and ASP.NET 1.1 installed.
I plan to install the Report Server database on the SQL 2K DB server; but I want to install the Report Server on the web server with IIS. Is that possible ? If yes can you please describe in detail how can I do it ?
The other question I am having is from where can I download SQL 2000 Reporting Services (DEV edition or ENT edition). Is this something available online ?
Please help, as this is very important for the project given to me.
Thank you all in advance
is there a reporting services configuration tool for 2000 that comes with the non-trial version as the trial version did not install this tool - maybe it did not do so because i had the 2005 version already installed. ???
View 1 Replies View Related
I would like to have an option of selecting the rows in my reports designed using reporting services 2000.
I would like to have a check box inside the table. when the user viewing the report he can select the rows using this checkbox and print only the selected table rows.
can anyone help how to implement this logic in ms reporting services 2000?
i have now ordered my sql server 2000 reporting services non-evaluated edition. My new question involves installing it after i installed 2005 edition.
It seems that as long as i have a web home for my report projects
(2005), the server can hold output from the 2000 and 2005 versions.
But i'm wondering if i delete my 2005 version, and just have the 2000
version - will the web home for the 2000 version look the same
and it seems at least on the 2000 trial version level, there is no configuration options menus that really make it easy to establish a web
home server. ????
Please get back to me on clalbert@flash.net
Charles Albert
thanks
Hello,
I'd like to display the first character of a string in a text field in Reporting Services 2000. First I check to see if the field is blank, if it is then do nothing. If the field is not blank, then display the first character.
IIF(LEN(Fields!ALADD2.Value) = 0, "", Fields!ALADD2.Value.SUBSTRING(0,1))
The text box displays #Error when the string is empty. Any ideas as to what I'm doing wrong? Thanks in advance.
i'm looking for a configuration tool that will configure my report and report server for sql server 2000 independent of sql server 2005
reporting services if any. reporting services 2005 has a configuration tool to set its own.
What i mean is way before reporting services 2005 people installed
2000 reporting services and they had to configure report and report
server so that results can be shown up via an intranet web browser
mechanism. Does reporting services 2000 offer this and if not
how is it done?
I know i can use the report server/report of 2005 to hold 2000 reports and i know how to setup a side-by-side installation using
2005 but i want to know documentation about the original way.
thank you
Hi All
I am new to SQL server Reporting services and its configurations. I have installed and set up the SQL Server 2000 Reporting services in Windows 2003 Server. I have two websites up and running in the IIS excluding the default website. I have made the neccessary settings to enable one of the non- defualt website to run the reporting services. However when i run http://Servername/reports, The properties tab is not available. Is there any rights issues that i miss out? Please enlighten me. Thnx
A customer of mine, running Reporting Services 2000, has a linked report situation. The report is landscaped and prints ok from the base report. If the same User tries to print the Linked version of same report it prints as Portrait. The user has Admin privileges. I am told another customer is having the same trouble.
Does anyone have any idea as to the problem?
Mick
Hi,
I am using Windows XP PRO and trying to Install SQL SERVER 2000 Reporting Services.
I have already installed SQL SERVER 2000 developer Edition, sql server service pack 3, VS.NET 2003 and .NET frame work 1.1.
I downloaded the SQL Server 2000 Reporting Services Evaluation Edition. I expected that there are both Server Component and Client Components which are available to install because evaluation edition support all features of Enterprise Edition. However I only saw the Client Components available during setup. Where can I find the Server Components to install? I appreciate very much if I can get advice from any of you.
Thanks,
Jane
hi,
our reporting services DB moved and I need to tell the report manager where to find it
isn't it in a config file somewhere, i can't find it?
do i have to reinstall?
Does anyone know if it's possible int sql 2000 reporting to change the color of an alternating item, similar to a datagrid in asp.net?
View 1 Replies View RelatedHow can I get the 2000 and 2005 versions of SQL Server Reporting Servicesboth working on my development laptop ?????I have ASP.NET 1.1 and 2.0 installed on my laptop.I have Visual Studio 2003 and 2005 installed on my laptop.I have my default website configured for ASP.NET 2.0.I have the developer edition of SQL Server 2000 installed on my laptop asinstance RMK006 in the MSSQL folder. I have the developer edition of SQLServer installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.I have the corresponding versions of SQL Server Reporting Services installedon my laptop.I have the Reports web site and the Reports web site and ReportServer website configured to ASP.NET 1.1I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006configured to ASP.NET 2.0Entering http://localhost/reports$rmk0062005 in my web browser works fine.Entering http://localhost/reportserver in my web browser generates thefollowing error:Reporting Services Error--------------------------------------------------------------------------------The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline HelpBad Data.--------------------------------------------------------------------------------Microsoft Reporting ServicesEntering http://localhost/Reports in my web browser generates the followingerror:The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline Help Bad Data.The only way I can seem to get 2000 Reporting Services working is to do thefollowing:- run C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspn et_regiis.exe -u- uninstall 2000 Reporting Services- run C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_regiis.exe -i- install 2000 Reporting ServicesBut once I've done that Visual Studio 2005 etc no longer work.The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio2005; the application is based on a SQL Server 2000 database and needs toinvoke SQL Server 2000 Reporting Services to run reports.What am I doing wrong?ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT ISLOSING PATIENCE !!!!!
View 1 Replies View RelatedTo Whom It May Concern:There is a piece of software that was needed to be installed to authorreports in Reporting Services for SQL 2000. That piece of software isVisual Studio .NET 2003. I do not have that piece but I am able toget the beta version of Visual Studio .NET 2005 from Microsoft. Willthat work for the installation and consequently the authoring part ofReporting Services? If not, could someone help me?Thank you in advance!Josh
View 1 Replies View RelatedHi,
I have a report that works fine when i deploy it in the development environment, but when i deploy the same report on the production server pointing to the same data source as the development environment; the images doesn't show up. I do see broken image X on all the images.
I searched the internet but couldn't find a solution to solve this problem. Any help on this will be appreciated.
Thanks,
Chaitanya
Hi friends, i have some questions about Reporting Services 2005:
Can i use RS 2005 with a SQL 2000 Database?
Can i create a report with RS 2005 (with a SQL 2K Database) a show it in a webform?
What do i need to install (in the webserver and in the Database server) in order to start designing reports in RS 2005 against a SQL 2K DB?Thanks in advance.
Regards
Eduardo