[SUGGESTION] Upload reports as ZIP file

Hi all,
I have around 200 reports, and it is overkill to upload them to server
file by file. So I suggest, man could pack them to ZIP and upload one
ZIP file, or I am missing something ?
/branoYou can zip the files, upload and unzip. But you still need to upload it to
the Report Server. You can do it more or less automatically with a script.
You can read a suggestion on how to at
http://blogs.spipp.net/kaisa/archive/2005/12/13/1233.aspx .
There are also some references to a scripting tool called "Reporting
Services Scripter", which can be found at
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm
(Haven't tested it myself.)
Kaisa M. Lindahl
"Brano" <2ge@.2NOgeSPAM.us> wrote in message
news:245690956.20060118121838@.ble.com...
> Hi all,
> I have around 200 reports, and it is overkill to upload them to server
> file by file. So I suggest, man could pack them to ZIP and upload one
> ZIP file, or I am missing something ?
> /brano
>|||Hello Kaisa,
Wednesday, January 18, 2006, 1:41:28 PM, you wrote:
> You can zip the files, upload and unzip. But you still need to upload it to
> the Report Server. You can do it more or less automatically with a script.
> You can read a suggestion on how to at
> http://blogs.spipp.net/kaisa/archive/2005/12/13/1233.aspx .
thanks, I understood it.
> There are also some references to a scripting tool called "Reporting
> Services Scripter", which can be found at
> http://www.sqldbatips.com/samples/code/RSScripter/readme.htm
> (Haven't tested it myself.)
you should, it is very powerful app designed exactly for this.
Importing (deploying) is quite slow, but it is faster and more correct
as doing by hand.
Thanks for nice suggestion.
Best regards,
Brano mailto:2ge@.2NOgeSPAM.us

[SQL Server]Login failed for user

I am using Crystal Reports, VB.net, SQL Server 2000sp3, MDAC 8.0, and Windows XP. When I try to make a connection from a Crystal Report to SQL Server via an ODBC connection, I get the following message:

Details: 28000:[Microsoft][SQL Server Driver][SQL Server]Login failed for user domain/username

In the odbc, I specify SQL Server authentication and provide a username and password but these are being ignored. Why is Windows authentication being used in place of the SQL Server authentication that I specify in my odbc?

Thanks in advance,

MattThat's Crystal for you :)|||What version of Crystal Reports are you using?|||Originally posted by awsterling
What version of Crystal Reports are you using?

I am the version that came with Visual Studio .Net 2003. I don't know how to get the version number from it.

Thanks.|||Get ActiveReport from DataDynamics and you won't have to deal with these issues any more :)

[scheduling] SSIS Package fails, but scheduler reports success

I have an SSIS Package that executes a stored procedure. It turns out my stored procedure was missing.

However, the SQL Job Scheduler reported that step as success.

Can anyone tell me why?

`Le

Because your package is not exiting with an indication of success/failure.

Moved to the SSIS forum.

|||
when I run it through the command line, it indeed gives me an error code of (1).

But the Scheduler still tells me that it is successful.

`Le
|||You need to check the JOB action to take when a step fails -perhaps it is set to continue and report success.|||The step itself is trying to run a stored procedure that does not exist. The Sql schedule should report a failure, but it is not. It reports a success.

The Sql Server job says "quit with failure" when there is an error. There is clearly a different problem here.

`Le

|||

It is difficult to help you when you have all of the details and we don't. We can't see what you are doing and what happens, Your descriptions are incomplete and do not allow a good problem determination and resolution.

Please post the entire command line that you are having problems with, including any success/failure statements after it executes.

Is this being executed by the Windows Scheduler?

What version of SQL Server are you using?

|||

Arnie Rowland wrote:

It is difficult to help you when you have all of the details and we don't. We can't see what you are doing and what happens, Your descriptions are incomplete and do not allow a good problem determination and resolution.

Please post the entire command line that you are having problems with, including any success/failure statements after it executes.

Is this being executed by the Windows Scheduler?

What version of SQL Server are you using?

Thank you for your reply. I will attempt to be more detailed:

SQL SERVER: 2005
VISUAL STUDIO: 2005
SSIS File Name: Foo.dtsx
Configuration File Name: Config.dtsConfig

This config file has multiple steps, including one step that executes a Stored Procedure.

When I run this through a command line, I run it as:
dtexec.exe /FILE "\\MyServer\Foo.dtsx.dtsx" /CONFIGFILE "\\MyServer\Config.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

When it is run this way, process exits with error (1), because the Stored Procedure in question does not exist on the database. This is the correct error message.

When I run it through SQL SERVER 2005 SCHEDULER, I run it as a SSIS package, with the command line:
/FILE "\\MyServer\Foo.dtsx.dtsx" /CONFIGFILE "\\MyServer\Config.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

However, the package always exits with success.

|||if a task inside a SSIS Package fails doesn't mean that the whole package fails
and the sql agent step would only report an error if the whole package fails

so you could set the property 'Fail Package on failure' to TRUE ... in the task where you execute this stored procedure.

- paul
|||When I run the package via command line (dtexec.exe), I do get fail message:

DTExec: The package execution returned DTSER_FAILURE(1)

~Le

Re: Accessing the underlying sql query from the rdl file

Our client uses the report builder to generate reports for collection of employees. We would like to use the employee records in this report to perform some additional processing (such as the list of employees gets assigned to a particular group).

Programmatically, I can retrieve a byte stream from rs.GetReportDefinition( "\myClientEmpReport") and deserialize the stream into Report object (as define by ReportDefinition.xsd).

I can then manually drill down and retrieve the SematicQuery xml from the commandText field.

The problem is how to convert the SemanticQuery format into a T-Sql query that I can run against the view that the report model is based off of.

Is this possible?

Thanks,

Arjay

P.S. Running SQL 2005 Reporting Services, VC# 2005, ASP.Net 2.0.

After attempting to autogenerate serialization classes on the SemanticQuery xml with Xsd and XsdObjectGen, I ended up hand coding some classes that handled recursion. From there, I was able to regenerate the sql query by walking through the filter and grouping sections. While this isn't a generic solution, it works well for my needs because the model I need this for is a single datasource derived from a view.

As a feature request, it sure would be nice to be able get the query string from the reporting engine directly.

[Reports builder] operator * in a prompt list

Hi all, when i create a reports deploy on the Report server, i usually choose a filter prompted on Run. The lsit containt for example the list of my customers, but the list in empty like i want (like that, user can put a list from excel by copy-paste). But ... , if the want all the customers, what is the " * " operator to select all my records ?

Thanks for help

Erwan, France

Do you mean

In a drop down for a report parameter you want <all> to appear?

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[PROBLEM] : Using RS Web Services to Render Report containing Toggle Item

Hi,

I have two problems with Toggle Items when I render my Reports using the RS Web Service.

First, the URL when I click on the + / - image will redirect me to the Report Server URL

ex :

The page that display the report is at : http://localhost/report/default.aspx
If i click on one of the +/- image, it will redirect to something like this : http://localhost/ReportServer?/myreport&myparam=testvalue&rc:streamRoot=//&rc:section=0&rs:format=HTML4.0&rs:ShowHideToggleItem=44&rs:SnapShot:isnull=True

Is there a solution to this problem ? (with a replace ?)

Then, If in the Render Method, I put a valid ShowHideToggle ID, when the report renders, the selected toggle item won't be expanded ...

Here's a sample of my code :

string ShowHideToggle = null;

// The rs:ShowHideToggle parameter is valid, but it wont' change anything ...
if(HttpContext.Current.Request["rs:ShowHideToggle"] != null)

ShowHideToggle = HttpContext.Current.Request["rs:ShowHideToggle"];

bResult = oRS.Render(_sName, "HTML4.0", null, "<DeviceInfo><StreamRoot>/" + _sFolder +"/</StreamRoot></DeviceInfo>", _oParameters, null, ShowHideToggle , out sOptionalString, out sOptionalString, out _oParameters, out oOptionalWarnings, out sStreamIDs);

Encoding oEnc = System.Text.Encoding.UTF8;

string sHTMLFlow = oEnc.GetString(bResult);

// This way, it won't redirect to the Report Server URL but the "+/-" image won't diplay anymore ...
sHTMLFlow = sHTMLFlow.Replace(sReportServerUrl.Replace("/ReportService.asmx", "?"), "http://" + HttpContext.Current.Request["SERVER_NAME"] + HttpContext.Current.Request["SCRIPT_NAME"] + "?Report=");

Any Help would be appreciated :)
That thing is killing me :(

Thanks for your help

You didn't say what version of SRS you're using.
On RS 2000 - this is a known limitation - toggles will point back to the report server virtual directory.
On RS 2005 - if you use the Reporting controls from VS 2005 or the new reportexecution APIs, you will get server-side ASP.NET events for all interractivity in the report

Thanks
Tudor|||

Tudor

Would you be able to provide an example of how to use showHideToggle using the reportexecution APIs in RS 2005. I have been looking to see how to specify showHideToggle in place of the old Render call, but have not been able to find anything.

Any tips would be much appreciated.

Thank you.

mike

|||

Call LoadReport only when ShowHideToggle is null.

after the first Render save ReportExecutionService intance into the Session.set the objReportExecutionService to the object in the Session.

for the succeeding calls if ShowHideToggle is not null set objReportExecutionService.ToggleItem to the ShowHideToggle value. then call the render method again.That should just work.

|||Aldwin, I'm not sure what you mean here. Can you provide a code sample?

Thanks,
Paul

[2.0] web service method to list the reports ?

Hello,

I'd like to use the Reporting Services 2005 Web Service to list all the reports on the server, but I don't know which method to use ?
I found many web methods to do all sort of things but not to get a list of reports.

Any idea ?

Ok I found the method of the Reporting Web Service : ListChildren(...)

But when I make a call to the WS on my web app, I got the error :HTTP status 401: Access Denied.

My Web App use Form authentication.
My ASPNET user is member of the ReportinsServicesWebServiceUser role so it should work.

I try to use impersonation, but still the same result...

|||

Have you tried allowing anonymous access to the site in IIS and adding

service.Credentials = System.Net.CredentialCache.DefaultCredentials

in code?

|||

I tried this and it's ok !

There was another security problem with RS which make a DCOM access to NetMan component with Network Services account.

Weird but it seems ok now, thanks.