[web Service] Rename a Report

i try to rename a report with web services.
i used ReportingService2005.SetProperties Method but when
i try with
Property.Name = "Name";
Property.Value = "myNewName"
i can't update the report name => RS2005 say the property 'name' is readonly
this method is ok with property "description"
How todo to rename report ?On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> i try to rename a report with web services.
> i used ReportingService2005.SetProperties Method but when
> i try with
> Property.Name = "Name";
> Property.Value = "myNewName"
> i can't update the report name => RS2005 say the property 'name' is readonly
> this method is ok with property "description"
> How todo to rename report ?
There are a couple of different ways to do it. Either change it in the
Properties tab in the Report Manager -or- change it at the file level.
So programmatically (option 2), you could do something like this in a
stored prcoedure that the report is using, etc:
exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||i wouldlike use Webservice ..... ( i create a soft that manage reporting
services 2005 with webservices )
"EMartinez" wrote:
> On Mar 16, 3:55 am, jeff <j...@.discussions.microsoft.com> wrote:
> > i try to rename a report with web services.
> >
> > i used ReportingService2005.SetProperties Method but when
> > i try with
> > Property.Name = "Name";
> > Property.Value = "myNewName"
> > i can't update the report name => RS2005 say the property 'name' is readonly
> > this method is ok with property "description"
> >
> > How todo to rename report ?
> There are a couple of different ways to do it. Either change it in the
> Properties tab in the Report Manager -or- change it at the file level.
> So programmatically (option 2), you could do something like this in a
> stored prcoedure that the report is using, etc:
> exec xp_cmdshell 'rename c:\OriginalReportName.rdl NewReportName.rdl'
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>

[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 :)

[SQL 2005 Express] Question on Business Intelligence Development Studio (VS2005)

I am trying to create a report using BI Development Studio.

In Pivot Table, I can change the presentation of the data area to align with row or column, just like this:
http://img164.imageshack.us/img164/2055/untitledsi4.png

However, I can't seem to do that in BI Development Studio while designing the report. Does any of you know how to change the presentation of the data area of a report?

This is how it looks like now, the data area is sticking to the COLUMN, but I need them to stick with ROW so that I can handle more columns...
http://img103.imageshack.us/img103/4066/untitlednc8.pngmanage to resolve it by inserting just 1 details, then insert "Add ROW" at the details. This thing doesn't come with the Wizard. :D

[SBS2003 Premium R2] Reporting services problem

Hi!
When I try configure report data source to connect to database on another
SQL Server 200 i receive message:
The feature: "Remote access to report data sources and/or the report server
database" is not supported in this edition of Reporting Services.
What can I do with thiss message?
Please help me
Best regards
AdamOn Jun 29, 1:57 am, "Adam Kobylinski" <akobylin@.NO_SPAM.op.pl> wrote:
> Hi!
> When I try configure report data source to connect to database on another
> SQL Server 200 i receive message:
> The feature: "Remote access to report data sources and/or the report server
> database" is not supported in this edition of Reporting Services.
> What can I do with thiss message?
> Please help me
> Best regards
> Adam
If you are running SQL Server 2005 Express Edition (w/Advanced
Services), this is one of the limitations. Otherwise, you will want to
open the local SQL Server Surface Area Configuration tool and select
Surface Area Configuration for Services and Connections -> View by
Instance -> MSSQLSERVER (or the local instance name) -> Database
Engine -> Remote Connections and make sure that it is set to: Local
and remote connections. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||User "EMartinez" <emartinez.pr1@.gmail.com>
> On Jun 29, 1:57 am, "Adam Kobylinski" <akobylin@.NO_SPAM.op.pl> wrote:
>> Hi!
>> When I try configure report data source to connect to database on another
>> SQL Server 200 i receive message:
>> The feature: "Remote access to report data sources and/or the report
>> server
>> database" is not supported in this edition of Reporting Services.
>> What can I do with thiss message?
>> Please help me
>> Best regards
>> Adam
>
> If you are running SQL Server 2005 Express Edition (w/Advanced
> Services), this is one of the limitations. Otherwise, you will want to
> open the local SQL Server Surface Area Configuration tool and select
> Surface Area Configuration for Services and Connections -> View by
> Instance -> MSSQLSERVER (or the local instance name) -> Database
> Engine -> Remote Connections and make sure that it is set to: Local
> and remote connections. Hope this helps.
>
Unfortunately it doesn't work, i already have remote connections selected,
SQL server 2000 on other computer is Standard Edition and i can connect
remotely from other applications.
Have you any idea?
Regards
Adam

[rsRuntimeErrorInExpression] The Value expression for the textbox

Hey All,
I am hoping that I will get a speedy response to this problem. I am working
in RS in SQL 2005. I have a report that has 6 parameters, 3 of these are
multivalue. They work fine, with the following exception:
I'm trying to set an expression in a text box on the report, to display back
to the users which parameters they selected prior to viewing the report.
This works fine for non-multivalue parameters. But, with the multivalue
parameters, I keep getting an error about the '&' not being valid. The
report builds fine, it only errors when I try to preview the report.
Here's the expression in my textbox:
="Report Parameters Entered:" & vbCrLf & "Retailer: " &
Parameters!Retailer.Value & vbCrLf & "Month/Year: " & Parameters!Month.Value
& "/" & Parameters!Year.Value & vbCrLf & "Store(s): " &
Parameters!StoreID.Value & vbCrLf & "Super Categories: " &
Parameters!SuperCategory.Value & vbCrLf & "Managed Indicator: " &
Parameters!Managed.Value
If I change the parameters in this to .IsMultiValue (for the ones that are
multivalue), the report runs fine. But, the actual values selected are not
returned. What shows up in the report is 'True' for each of the multivalue
parameters (because they are multivalue and I'm using the IsMultiValue?).
Anyway, if anyone knows of a work around for this, or if I am just way off
base...PLEASE let me know as soon as possible.
Thanks so much for your response!
SandiMaybe this tip helps?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=481987&SiteID=1
Kaisa M. Lindahl Lervik
"SandiB" <SandiB@.discussions.microsoft.com> wrote in message
news:C87FE985-C985-4C3F-B047-53338EFF7A41@.microsoft.com...
> Hey All,
> I am hoping that I will get a speedy response to this problem. I am
> working
> in RS in SQL 2005. I have a report that has 6 parameters, 3 of these are
> multivalue. They work fine, with the following exception:
> I'm trying to set an expression in a text box on the report, to display
> back
> to the users which parameters they selected prior to viewing the report.
> This works fine for non-multivalue parameters. But, with the multivalue
> parameters, I keep getting an error about the '&' not being valid. The
> report builds fine, it only errors when I try to preview the report.
> Here's the expression in my textbox:
> ="Report Parameters Entered:" & vbCrLf & "Retailer: " &
> Parameters!Retailer.Value & vbCrLf & "Month/Year: " &
> Parameters!Month.Value
> & "/" & Parameters!Year.Value & vbCrLf & "Store(s): " &
> Parameters!StoreID.Value & vbCrLf & "Super Categories: " &
> Parameters!SuperCategory.Value & vbCrLf & "Managed Indicator: " &
> Parameters!Managed.Value
> If I change the parameters in this to .IsMultiValue (for the ones that are
> multivalue), the report runs fine. But, the actual values selected are
> not
> returned. What shows up in the report is 'True' for each of the
> multivalue
> parameters (because they are multivalue and I'm using the IsMultiValue?).
> Anyway, if anyone knows of a work around for this, or if I am just way off
> base...PLEASE let me know as soon as possible.
> Thanks so much for your response!
> Sandi|||Thanks so much! This worked perfectly!
"Kaisa M. Lindahl Lervik" wrote:
> Maybe this tip helps?
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=481987&SiteID=1
> Kaisa M. Lindahl Lervik
> "SandiB" <SandiB@.discussions.microsoft.com> wrote in message
> news:C87FE985-C985-4C3F-B047-53338EFF7A41@.microsoft.com...
> > Hey All,
> >
> > I am hoping that I will get a speedy response to this problem. I am
> > working
> > in RS in SQL 2005. I have a report that has 6 parameters, 3 of these are
> > multivalue. They work fine, with the following exception:
> >
> > I'm trying to set an expression in a text box on the report, to display
> > back
> > to the users which parameters they selected prior to viewing the report.
> > This works fine for non-multivalue parameters. But, with the multivalue
> > parameters, I keep getting an error about the '&' not being valid. The
> > report builds fine, it only errors when I try to preview the report.
> >
> > Here's the expression in my textbox:
> >
> > ="Report Parameters Entered:" & vbCrLf & "Retailer: " &
> > Parameters!Retailer.Value & vbCrLf & "Month/Year: " &
> > Parameters!Month.Value
> > & "/" & Parameters!Year.Value & vbCrLf & "Store(s): " &
> > Parameters!StoreID.Value & vbCrLf & "Super Categories: " &
> > Parameters!SuperCategory.Value & vbCrLf & "Managed Indicator: " &
> > Parameters!Managed.Value
> >
> > If I change the parameters in this to .IsMultiValue (for the ones that are
> > multivalue), the report runs fine. But, the actual values selected are
> > not
> > returned. What shows up in the report is 'True' for each of the
> > multivalue
> > parameters (because they are multivalue and I'm using the IsMultiValue?).
> >
> > Anyway, if anyone knows of a work around for this, or if I am just way off
> > base...PLEASE let me know as soon as possible.
> >
> > Thanks so much for your response!
> >
> > Sandi
>
>|||'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities.Sync\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.Sync.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\ISOJC111\ISOJC\bin\Debug\ISOJC.vshost.exe', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\10.2.3600.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\CrystalDecisions.Enterprise.Framework\10.2.3600.0__692fbea5521e1304\CrystalDecisions.Enterprise.Framework.dll', No symbols loaded.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\CrystalDecisions.Enterprise.InfoStore\10.2.3600.0__692fbea5521e1304\CrystalDecisions.Enterprise.InfoStore.dll', No symbols loaded.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportSource\10.2.3600.0__692fbea5521e1304\CrystalDecisions.ReportSource.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\10.2.3600.0__692fbea5521e1304\CrystalDecisions.Shared.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\10.2.3600.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.WinForms\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.WinForms.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic.PowerPacks\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.PowerPacks.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Deployment\2.0.0.0__b03f5f7f11d50a3a\System.Deployment.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
The thread 0x12ac has exited with code 0 (0x0).
The thread 0x1650 has exited with code 0 (0x0).
The thread 0xdc has exited with code 0 (0x0).
'ISOJC.vshost.exe' (Managed): Loaded 'C:\ISOJC111\ISOJC\bin\Debug\ISOJC.exe', Symbols loaded.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Remoting\2.0.0.0__b77a5c561934e089\System.Runtime.Remoting.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.ProcessingObjectModel\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.ProcessingObjectModel.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'ISOJC.vshost.exe' (Managed): Loaded 'expression_host_10e7fe2ca2834f48ab7700ebecf77268', No symbols loaded.
Warning: The Value expression for the textbox ?textbox27? contains an error: Input string was not in a correct format. (rsRuntimeErrorInExpression)
The thread 0x1730 has exited with code 0 (0x0).
Warning: The Value expression for the textbox ?textbox27? contains an error: Input string was not in a correct format. (rsRuntimeErrorInExpression)
The thread 0x380 has exited with code 0 (0x0).
Warning: The Value expression for the textbox ?textbox27? contains an error: Input string was not in a correct format. (rsRuntimeErrorInExpression)
The thread 0xd24 has exited with code 0 (0x0).
The thread 0x17ec has exited with code 0 (0x0).
The thread 0x133c has exited with code 0 (0x0).
The program '[5820] ISOJC.vshost.exe: Managed' has exited with code 0 (0x0).
From http://www.google.co.in/search?q=rsRuntimeErrorInExpression&hl=en&start=10&sa=N
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

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

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt?

Our program report the error like this:

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

How does this error happen?

How can I fix it?

We use the SqlServer 2005.

Thanks

This occurs when you issue a new query before you've finished consuming the results from your previous query. Most often people are trying to issue subqueries when a JOIN statement in the original would suffice. Otherwise, you can use a different connection to make the subquery or look into MARS (multiple active result sets) for SQL Server 2005.

I don't think this is SSIS-related and should be moved to a different forum.
|||

I have never used ODBC SQL server driver from within SSIS ; I always use either SQL server ole db or .NET provider SQL client data provider.

have you tried one of these yet?

|||

the operation occours this error is just a [update] sentence.

Does this error can be caused by mutil-thread or other reasons?

Thanks a lot

|||I used vc++ and ADO.|||vc++ and ado , then this is probably not SSIS related, you should look in another forum or newsgroup.

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

Our program report the error like this:

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

I used VC++ and ADO.

How does this error happen?

How can I fix it?

Does this can be caused by mutil-thread?

We use the SqlServer 2005.

Thanks

This is caused by you have a opening result set open against the same connection. For example, you execute a SqlCommand to select all rows from a table, while the result set is not drained, you try to execute another SqlCommand using the same connection, you will hit this error message.

To solve this, you have two choices:

a. Make sure you read the rest data from the pending result set before you send the next SqlCommand.

b. Use MARS (Multiple Active ResultSet) connection setting to enable multiple active result set in a connection. See http://msdn2.microsoft.com/en-us/library/ms345109.aspx

for more details.

Thanks!

Ping

|||

Refer to MARS, http://msdn2.microsoft.com/en-us/library/ms345109.aspx.

It is seems that the SQL SERVER 2005 has already fixed it, isn't it?

Thanks

|||

If I'm reading your error message correctly, the issue is that you're using a pre-SQL 2005 driver. Although the SQL 2005 Server understand MARS, you'll need to use the SQL 2005 driver in order for your application to be able to use it.

You'll need to connect using the "SQL Server Native Client" driver instead of the "SQL Server" driver.

Hope this helps!

~Warren

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

Our program report the error like this:

[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.

I used VC++ and ADO.

How does this error happen?

How can I fix it?

Does this can be caused by mutil-thread?

We use the SqlServer 2005.

Thanks

This is caused by you have a opening result set open against the same connection. For example, you execute a SqlCommand to select all rows from a table, while the result set is not drained, you try to execute another SqlCommand using the same connection, you will hit this error message.

To solve this, you have two choices:

a. Make sure you read the rest data from the pending result set before you send the next SqlCommand.

b. Use MARS (Multiple Active ResultSet) connection setting to enable multiple active result set in a connection. See http://msdn2.microsoft.com/en-us/library/ms345109.aspx

for more details.

Thanks!

Ping

|||

Refer to MARS, http://msdn2.microsoft.com/en-us/library/ms345109.aspx.

It is seems that the SQL SERVER 2005 has already fixed it, isn't it?

Thanks

|||

If I'm reading your error message correctly, the issue is that you're using a pre-SQL 2005 driver. Although the SQL 2005 Server understand MARS, you'll need to use the SQL 2005 driver in order for your application to be able to use it.

You'll need to connect using the "SQL Server Native Client" driver instead of the "SQL Server" driver.

Hope this helps!

~Warren

[Feature Request] Jump to Report (Choice of report to the user)

I am trying to build a report with a "jump to report" (with all the
applicable parameters) effect in a table.
But based on user's choice - I somehow want to let them choose which
report they can jump on.
How may I present them the choices?
One idea I had was to create a dummy report that stores all the
parameters, and then provide different report options...You might want to use jump to url instead. Here is an idea: You have a
report that shows the values you want to have the user select from. Just
show it in a table. Have one of the fields (could be an extra field that
says, Detail ... or something like that. Make it blue and underlined. Then
set the advanced properties and use the jump to URL setting the appropriate
parameters. Depending on how complicated it is you might want to create code
behind that assembles the URL string for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Harsh" <harsh.vb@.gmail.com> wrote in message
news:1e70ecdd.0411130826.3d172549@.posting.google.com...
>I am trying to build a report with a "jump to report" (with all the
> applicable parameters) effect in a table.
> But based on user's choice - I somehow want to let them choose which
> report they can jump on.
> How may I present them the choices?
>
> One idea I had was to create a dummy report that stores all the
> parameters, and then provide different report options...|||In Jump to dialog box, where it asked the name of the report to jump to, do
an
IIF(Fields!xxx.Value = "A", "AReport", IIF(Fields!xxx.Value = "B",
"BReport", "")
"Harsh" wrote:
> I am trying to build a report with a "jump to report" (with all the
> applicable parameters) effect in a table.
> But based on user's choice - I somehow want to let them choose which
> report they can jump on.
> How may I present them the choices?
>
> One idea I had was to create a dummy report that stores all the
> parameters, and then provide different report options...
>

[CR6] Can I use "SELECT FROM WHERE"?

Hi, sorry for my english :-\

I'm working on Crystal Report 6.0
I have 2 tables that are not in join, but I need a field with a "where" condition.
Example:
TableA:
fldDescription

TableB:
fldCode
fldDesc

I have a formula field which should show TableB.fldDesc, using a code in TableA.fldDescription
I extract 2 char in TableA.fldDescription:
strMyField = Trim (Mid ({TableA.fldDescription},2 , 2));

Now I must show TableB.fldDesc where TableB.fldCode = strMyField.
How can I do this? I have no join between this tables, I tried to put in the formula field "Select TableB.fldDesc where TableB.fldCode = strMyField" but it doesn't work.

Could you help me, please?How are TableA and TableB related? Do you even need any data from TableA?

"Select TableB.fldDesc where TableB.fldCode = strMyField"

If this were VB, you would have to do it like this:

"Select TableB.fldDesc where TableB.fldCode = '" & strMyField & "'"

In other words, you would have to concatenate the variable into the string you're using for your select statement. Also, you would need to put the string in single quotes (as shown in Red) to tell your database that it's a string. (These examples are derived from VB 6 and SQL Server 7, so you may need to adjust them accordingly).

I don't use Crystal Reports for direct database access. I let VB do all the data gathering and I just pass the data itself to Crystal for displaying. I'm not sure what the correct syntax is for Database SQL Statement within Crystal Reports, but I hope that my examples might give you a starting point to figure out your problem.

Good Luck!

[BUG]Some JPEGs not showing correctly in PDF-Export

Hi,

we've some pictures from broken machines, they are taken with a digital camera and should be showed within a report.
But some Pictures don't display correctly:
I want to add this image.
In PreviewMode or if exporting to Tif-Images everything looks fine, but if I export to PDF the Image looks like this (resized, but it also looks so if I don't resize it).

If I open the file in Paint.net and save it again everything is okay.. But its strange for the users that this picture shows up correctly everywhere except the PDF-Export. So they say its a problem of PDF export and not of the image..

Does anybody have a similar issue and a solution for this problem?
It doesn't matter if I retrieve the jpeg from a database or from disk, this problem always occurs.
I tried this with and without SP1-> same problem..

Any help would be appreciated
I found the problem by hex-editing the PDF..
Some picutures ( like the one in the link above) get marked as grayscale though they are RGB!!
If you manually change
/XObject /Subtype /Image /ColorSpace /DeviceGray /BitsPerComponent 8 ....
to
/XObject /Subtype /Image /ColorSpace /DeviceRGB /BitsPerComponent 8 ....
and open the PDF the images are okay!

So, thats the bug, but who can give me a solution?
(Editing the PDF afterwards is no solution ;))
|||I analysed the files, the problem seems to occur if the Huffman table marker (FFC4) Header shows up prior the Start of frame marker (FFC0)!
I don't know if the jpegs aren't "well formed" if huffman table marker comes first but other programs process them correctly..

If I manually move the start of frame marker to some position prior the Huffman table marker the pictures show up correctly (the pdf says /DeviceRGB)..
|||We also have noticed this problem, though I don't know my way around Jpeg files well enough to verify the frame sequencing problem you identified above.

I do not believe that we saw this problem until I applied SQL Server 2005 Service Pack 1 last week.

Do you have the service pack applied?
|||

We are also having the same problem and we do have SP1 installed on SQL 2005. Is there still no fix for this issue ? Please help.

|||I've reported that as Bug, take a look at:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109

MS Comment:
This is a duplicate of https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=152109. It has been fixed for the upcoming Service Pack 2.

It's a duplicate of itself;) But they seem to fix it..

[Bug] Jump to report from a Table (second page on HTML)

This seems like a bug:
I created a "jump to report" action on a TABLE in my report.
It works fine. But - when the table becomes long, and exceeds one
page on the HTML viewer, the "Jump to report" doesn't work anymore.
It keep throwing up blank pages.
Has anyone else encountered this?One question, is this from the IDE or from a deployed report. I have had a
variety of funky oddities that are only in the IDE, the deployed report
works fine.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Harsh" <harsh.vb@.gmail.com> wrote in message
news:1e70ecdd.0411130717.8685260@.posting.google.com...
> This seems like a bug:
> I created a "jump to report" action on a TABLE in my report.
> It works fine. But - when the table becomes long, and exceeds one
> page on the HTML viewer, the "Jump to report" doesn't work anymore.
> It keep throwing up blank pages.
> Has anyone else encountered this?

[Bug] Deadlock: Wait Type CXPACKET with CLUSTERED INDEXES

Our site has experienced a dead lock issue with a query that uses parallel
processing. Anyone know how to report this to Microsoft?
When running a load for one of our datamarts we have a query that uses 12
threads of execution, we have several queries like this but only 1 which
locks up. Half way to 3/4 of the way through execution many of threads stop
and are waiting with a type CXPACKET, CPU utilizations grinds to halt and the
query never returns. It ran this entire weekend, Friday 11:30 PM to Monday
9:00 AM.
Our workaround, believe it or not, was to change the primary key's on a
couple lookup tables from CLUSTERED to NON-CLUSTERED. This fixed the problem
and still allows us to use parallel execution and we did not have to resort
to OPTION (MAXDOP 1)
There is clearly some kind of bug with SQL Server and the creation and
execution of the query plan. How do I get a solid core dump and log of the
server and submit a bug report to MS so they can fix this.
AdamAdam,
If you are up-to-date on service packs and not just encountering
http://support.microsoft.com/kb/293232/, the best way to report this is
probably to open a case with Microsoft Product Support (PSS). This
doesn't sound like the kind of problem that can easily be distilled down
to a reproducible Query Analyzer script.
If the problem is caused by a bug, there's a good chance the support
incident will be free, but whether or not there will be a fix in the
short term is hard to say. But changing indexes to nonclustered isn't a
very convenient workaround, and PSS might be able to find a better
workaround. There are occasional newsgroup reports of this situation,
and you can browse recent threads here to see if there is a better
workaround:
http://groups-beta.google.com/groups?q=CXPACKET+sqlserver&start=0&scoring=d&hl=en&
Steve Kass
Drew University
Adam wrote:
>Our site has experienced a dead lock issue with a query that uses parallel
>processing. Anyone know how to report this to Microsoft?
>When running a load for one of our datamarts we have a query that uses 12
>threads of execution, we have several queries like this but only 1 which
>locks up. Half way to 3/4 of the way through execution many of threads stop
>and are waiting with a type CXPACKET, CPU utilizations grinds to halt and the
>query never returns. It ran this entire weekend, Friday 11:30 PM to Monday
>9:00 AM.
>Our workaround, believe it or not, was to change the primary key's on a
>couple lookup tables from CLUSTERED to NON-CLUSTERED. This fixed the problem
>and still allows us to use parallel execution and we did not have to resort
>to OPTION (MAXDOP 1)
>There is clearly some kind of bug with SQL Server and the creation and
>execution of the query plan. How do I get a solid core dump and log of the
>server and submit a bug report to MS so they can fix this.
>Adam
>|||Thanks Steve, I will go the PSS route.
"Steve Kass" wrote:
> Adam,
> If you are up-to-date on service packs and not just encountering
> http://support.microsoft.com/kb/293232/, the best way to report this is
> probably to open a case with Microsoft Product Support (PSS). This
> doesn't sound like the kind of problem that can easily be distilled down
> to a reproducible Query Analyzer script.
> If the problem is caused by a bug, there's a good chance the support
> incident will be free, but whether or not there will be a fix in the
> short term is hard to say. But changing indexes to nonclustered isn't a
> very convenient workaround, and PSS might be able to find a better
> workaround. There are occasional newsgroup reports of this situation,
> and you can browse recent threads here to see if there is a better
> workaround:
> http://groups-beta.google.com/groups?q=CXPACKET+sqlserver&start=0&scoring=d&hl=en&
>
> Steve Kass
> Drew University
> Adam wrote:
> >Our site has experienced a dead lock issue with a query that uses parallel
> >processing. Anyone know how to report this to Microsoft?
> >
> >When running a load for one of our datamarts we have a query that uses 12
> >threads of execution, we have several queries like this but only 1 which
> >locks up. Half way to 3/4 of the way through execution many of threads stop
> >and are waiting with a type CXPACKET, CPU utilizations grinds to halt and the
> >query never returns. It ran this entire weekend, Friday 11:30 PM to Monday
> >9:00 AM.
> >
> >Our workaround, believe it or not, was to change the primary key's on a
> >couple lookup tables from CLUSTERED to NON-CLUSTERED. This fixed the problem
> >and still allows us to use parallel execution and we did not have to resort
> >to OPTION (MAXDOP 1)
> >
> >There is clearly some kind of bug with SQL Server and the creation and
> >execution of the query plan. How do I get a solid core dump and log of the
> >server and submit a bug report to MS so they can fix this.
> >
> >Adam
> >
> >
>|||On Mon, 20 Dec 2004 12:59:05 -0800, "Adam"
<Adam@.discussions.microsoft.com> wrote:
>Our workaround, believe it or not, was to change the primary key's on a
>couple lookup tables from CLUSTERED to NON-CLUSTERED. This fixed the problem
>and still allows us to use parallel execution and we did not have to resort
>to OPTION (MAXDOP 1)
I believe it.
You don't happen to use any little lock hints in your query, do you?
I recently had some queries hang up because the programmer had
helpfully specified tablockx, and this turned out to be
counterproductive.
J.

[bug?] Hidden parameters

Hello,
I have troubles with hidden parameters. What am I doing:
1) define a report parameter based on a dataset's field (a dataset is
"Stored proc." type, the procedure returns the only string value -- if it is
important)
2) Build & deploy a solution, run the report from Report manager -- it's ok
3) run the report from Report manager, click on "Properties" tab, choose
"parameters":
Has Default - leave checked on
Default Value - (Query Based)
Null - (none)
Prompt User - leave checked on
Prompt String - I cleared this textbox
4) run the report again:
Reporting Services Error
Default value or value provided for the report parameter 'MyParam' is not a
valid value. (rsInvalidReportParameter) Get Online Help
Refresh button on RM or the IE's same button don't change this error message
5) Properties -> Parameters -> Prompt String: type a former prompt string
6) run the report: it works ok, however the aforementioned parameter acts
like it doesn't have Default Value anymore.
What have I do to hide param properly?
(MS RS sp1)
Microsoft SQL Server Reporting Services Version 8.00.878.00
Thanks,
Lucy.Does it have list of available values?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lusy Crown" <evesq@.uk2.net> wrote in message
news:OBEtp5laEHA.3892@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have troubles with hidden parameters. What am I doing:
> 1) define a report parameter based on a dataset's field (a dataset is
> "Stored proc." type, the procedure returns the only string value -- if it
> is
> important)
> 2) Build & deploy a solution, run the report from Report manager -- it's
> ok
> 3) run the report from Report manager, click on "Properties" tab, choose
> "parameters":
> Has Default - leave checked on
> Default Value - (Query Based)
> Null - (none)
> Prompt User - leave checked on
> Prompt String - I cleared this textbox
> 4) run the report again:
> Reporting Services Error
> Default value or value provided for the report parameter 'MyParam' is not
> a
> valid value. (rsInvalidReportParameter) Get Online Help
> Refresh button on RM or the IE's same button don't change this error
> message
> 5) Properties -> Parameters -> Prompt String: type a former prompt string
> 6) run the report: it works ok, however the aforementioned parameter acts
> like it doesn't have Default Value anymore.
> What have I do to hide param properly?
> (MS RS sp1)
> Microsoft SQL Server Reporting Services Version 8.00.878.00
> Thanks,
> Lucy.
>|||Yes. From query. Same to "default".
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:%2300zztpaEHA.3352@.TK2MSFTNGP12.phx.gbl...
> Does it have list of available values?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Lusy Crown" <evesq@.uk2.net> wrote in message
> news:OBEtp5laEHA.3892@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > I have troubles with hidden parameters. What am I doing:
> >
> > 1) define a report parameter based on a dataset's field (a dataset is
> > "Stored proc." type, the procedure returns the only string value -- if
it
> > is
> > important)
> > 2) Build & deploy a solution, run the report from Report manager -- it's
> > ok
> > 3) run the report from Report manager, click on "Properties" tab, choose
> > "parameters":
> > Has Default - leave checked on
> > Default Value - (Query Based)
> > Null - (none)
> > Prompt User - leave checked on
> > Prompt String - I cleared this textbox
> > 4) run the report again:
> >
> > Reporting Services Error
> > Default value or value provided for the report parameter 'MyParam' is
not
> > a
> > valid value. (rsInvalidReportParameter) Get Online Help
> >
> > Refresh button on RM or the IE's same button don't change this error
> > message
> >
> > 5) Properties -> Parameters -> Prompt String: type a former prompt
string
> > 6) run the report: it works ok, however the aforementioned parameter
acts
> > like it doesn't have Default Value anymore.
> >
> > What have I do to hide param properly?
> >
> > (MS RS sp1)
> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> >
> > Thanks,
> > Lucy.
> >
> >
>|||To summarize, error rsInvalidReportParameter happened because same stored
procedure was used for available values and default value, and this stored
procedure returned unique result for every call.
Report Server was executing this stored procedure twice (1st time for
available values and 2nd time for default value) and was unable to match
default value with available value.
Solution is not to set available values.
Also because you just wanted to have read-only parameter, it is enough to
leave prompt blank, and Report Desinger would set parameter properties
during Deploy procedure.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lusy Crown" <evesq@.uk2.net> wrote in message
news:OAYt06paEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Yes. From query. Same to "default".
>
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:%2300zztpaEHA.3352@.TK2MSFTNGP12.phx.gbl...
>> Does it have list of available values?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Lusy Crown" <evesq@.uk2.net> wrote in message
>> news:OBEtp5laEHA.3892@.TK2MSFTNGP10.phx.gbl...
>> > Hello,
>> >
>> > I have troubles with hidden parameters. What am I doing:
>> >
>> > 1) define a report parameter based on a dataset's field (a dataset is
>> > "Stored proc." type, the procedure returns the only string value -- if
> it
>> > is
>> > important)
>> > 2) Build & deploy a solution, run the report from Report manager --
>> > it's
>> > ok
>> > 3) run the report from Report manager, click on "Properties" tab,
>> > choose
>> > "parameters":
>> > Has Default - leave checked on
>> > Default Value - (Query Based)
>> > Null - (none)
>> > Prompt User - leave checked on
>> > Prompt String - I cleared this textbox
>> > 4) run the report again:
>> >
>> > Reporting Services Error
>> > Default value or value provided for the report parameter 'MyParam' is
> not
>> > a
>> > valid value. (rsInvalidReportParameter) Get Online Help
>> >
>> > Refresh button on RM or the IE's same button don't change this error
>> > message
>> >
>> > 5) Properties -> Parameters -> Prompt String: type a former prompt
> string
>> > 6) run the report: it works ok, however the aforementioned parameter
> acts
>> > like it doesn't have Default Value anymore.
>> >
>> > What have I do to hide param properly?
>> >
>> > (MS RS sp1)
>> > Microsoft SQL Server Reporting Services Version 8.00.878.00
>> >
>> > Thanks,
>> > Lucy.
>> >
>> >
>>
>|||How do you not set available values...in report designer report params
dialog, my parameter has a name, 'tick', has the non-queried available values
radio button clicked and the list to the right is completely blank, as I want
it to be. This parameter is unique everytime a report is executed and cannot
be selected from a list of existing values...but I'm still getting the
following error when I call the web service render method...
+ System.SystemException {"The value provided for the report parameter
'tick' is not valid for its type. --> The value provided for the report
parameter 'tick' is not valid for its type. --> The value provided for the
report parameter 'tick' is not valid for its type."} System.SystemException
"Lev Semenets [MSFT]" wrote:
> To summarize, error rsInvalidReportParameter happened because same stored
> procedure was used for available values and default value, and this stored
> procedure returned unique result for every call.
> Report Server was executing this stored procedure twice (1st time for
> available values and 2nd time for default value) and was unable to match
> default value with available value.
> Solution is not to set available values.
> Also because you just wanted to have read-only parameter, it is enough to
> leave prompt blank, and Report Desinger would set parameter properties
> during Deploy procedure.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Lusy Crown" <evesq@.uk2.net> wrote in message
> news:OAYt06paEHA.1764@.TK2MSFTNGP10.phx.gbl...
> > Yes. From query. Same to "default".
> >
> >
> > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > news:%2300zztpaEHA.3352@.TK2MSFTNGP12.phx.gbl...
> >> Does it have list of available values?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Lusy Crown" <evesq@.uk2.net> wrote in message
> >> news:OBEtp5laEHA.3892@.TK2MSFTNGP10.phx.gbl...
> >> > Hello,
> >> >
> >> > I have troubles with hidden parameters. What am I doing:
> >> >
> >> > 1) define a report parameter based on a dataset's field (a dataset is
> >> > "Stored proc." type, the procedure returns the only string value -- if
> > it
> >> > is
> >> > important)
> >> > 2) Build & deploy a solution, run the report from Report manager --
> >> > it's
> >> > ok
> >> > 3) run the report from Report manager, click on "Properties" tab,
> >> > choose
> >> > "parameters":
> >> > Has Default - leave checked on
> >> > Default Value - (Query Based)
> >> > Null - (none)
> >> > Prompt User - leave checked on
> >> > Prompt String - I cleared this textbox
> >> > 4) run the report again:
> >> >
> >> > Reporting Services Error
> >> > Default value or value provided for the report parameter 'MyParam' is
> > not
> >> > a
> >> > valid value. (rsInvalidReportParameter) Get Online Help
> >> >
> >> > Refresh button on RM or the IE's same button don't change this error
> >> > message
> >> >
> >> > 5) Properties -> Parameters -> Prompt String: type a former prompt
> > string
> >> > 6) run the report: it works ok, however the aforementioned parameter
> > acts
> >> > like it doesn't have Default Value anymore.
> >> >
> >> > What have I do to hide param properly?
> >> >
> >> > (MS RS sp1)
> >> > Microsoft SQL Server Reporting Services Version 8.00.878.00
> >> >
> >> > Thanks,
> >> > Lucy.
> >> >
> >> >
> >>
> >>
> >
> >
>
>