Error when reading the Label field from Report Parameters

Hi there,

I am trying to fill a Textbox with the Label-Field from the Report Parameters. The Multi-Value-Option is checked and it is possible to select multi-values from the time hierarchy [Time].[Year - Half Year - Quarter - Month].

For example you can choose:
"Calendar 2007" ([Time].[Year - Half Year - Quarter - Month].[Year].&[2007-01-01T00:00:00])
"Quarter 4, 2006" ([Time].[Year - Half Year - Quarter - Month].[Quarter].&[2006-10-01T00:00:00])
and "April 2006" ([Time].[Year - Half Year - Quarter - Month].[Month].&[2006-04-01T00:00:00])

Now I want to fill a Textbox with the chosen parameter values by putting following expression as value of the textbox:

Parameters!TimeYearHalfYearQuarterMonthDate.Label ... with "TimeYearHalfYearQuarterMonthDate" as the name of the DataSet.

That gives an Error.

Can you please help me out?

Best regards
Claudio

Why are you using .Label? Either I don't fully understand your problem or you should be using:

Parameters!TimeYearHalfYearQuarterMonthDate.Value

|||First of all: .Value doesn't work either. Second: I am using Label, because I don't want the value like [Time].[Year - Half Year - Quarter - Month].[Year].&[2007-01-01T00:00:00] to be displayed, but the Label like Year 2007.
|||Hi there,

how can I fill a Textbox with the Report Parameters when using multi-values for them?

For example you can choose:

"Calendar 2007" ([Time].[Year - Half Year - Quarter - Month].[Year].&[2007-01-01T00:00:00])
"Quarter 4, 2006" ([Time].[Year - Half Year - Quarter - Month].[Quarter].&[2006-10-01T00:00:00])
and "April 2006" ([Time].[Year - Half Year - Quarter - Month].[Month].&[2006-04-01T00:00:00])

together. And I want a Textbox to show the Parameters used. Like Calendar 2007; Quarter 4, 2006; April 2006.

Please help me out with this issue!

Best regards
Claudio
|||

Hi,

In order to show all your selected parameters from a multi value param, i use this function:

join(Parameters!your-param.label, " ; ")

hope this helps.

Vinnie

|||Hi Vinnie!

Thank you very very much! It works!

Bye
Claudio
sql

Error using ntext and Image as output parameters

I am trying to use NText and Image data types as output parameters and I keep receiving an error. I can use TEXTPTR fucntion and put it into a varbinary(16) field but will that truncate the field?

Is there anyway around this where I can return the image datatype as an output parameter?

ThanksYou can return a image or ntext as a column in a result set, but I do not believe you can make it an output parameter.

error stored procedure parameters

Hi i'll get the following error

The SqlParameter with ParameterName 'xxxxx' is already contained by another SqlParameterCollection.

I'am trying to create an dataset in which data of the different connectionpoints are separated into different tables. Herefor i'm using an stored procedure.

Below you'll find part of the main function and the full function which will execute the stored procedure.

kind regards

main function

Dim Parameters As SqlParameter() = { _
New SqlParameter("@.ConnectionPointID", SqlDbType.NVarChar, 255)}

For x = 0 To myds.Tables("ConnectionPoints").Rows.Count - 1
connectionpointID = myds.Tables("connectionpoints").Rows(x).Item("Eancode")
Parameters(0).Value = connectionpointID
mydb.doStoredProcedure("SP_EDS_Dyomes_XML", Parameters,connectionpointID.ToString, myds)
Next

Public Overloads Function doStoredProcedure( _
ByRef Mycommand As SqlCommand, _
ByRef myds As DataSet, _
ByVal Table As String)

Dim myda As New SqlDataAdapter

Mycommand.CommandTimeout = 180
If Mycommand.Connection Is Nothing Then
Dim mydb As New Database
Mycommand.Connection = mydb.generateconnection
End If
If Mycommand.Connection.State = ConnectionState.Closed Then
Mycommand.Connection.Open()
End If
CheckParameters(Mycommand)
myda.SelectCommand = Mycommand

Try
myda.Fill(myds, Table)
Catch ex As Exception
Debug.Write(ex.Message)
End Try
myda.Dispose()
Mycommand.Dispose()

End FunctionMycommand.Dispose() will release the parameter you created, and make Parameters(0) nothing|||thanx|||No problem. Hope it works for you.

Error Starting Reporting Services in SQL Server 2005

Hi ,

I am trying to connect to Reporting Services through SSMS using the following parameters:

Server_Type: Reporting Services

Server Name : <Server_Name>

Authentication: Windows Authentication

Got the following error message:

TITLE: Connect to Server

Cannot connect to <Server_Name>

ADDITIONAL INFORMATION:

Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message:
--
<html><head><title>Server Application Error</title></head>
<body>
<h1>Server Application Error</h1>The server has encountered an error while loading an application during the processing of your request.
Please refer to the event log for more detail information. Please contact the server administrator for assistance.</body></html>
--. (Microsoft.SqlServer.Management.UI.RSClient)

Any help would be deeply appreciated,

Thanks a lot for your Time,

Regards,

Sundar

Hi,

Can you please post any relevant Event Log entries from the Application Tier server (the one on which TFS, SharePoint and SQL Server Reporting Services reside)? Please also examine the IIS log for any suspicious error messages and if you find any, please post them here.

|||

Hi,

In the Event Viewer Log, I got the following message :

The server failed to load application '/LM/W3SVC'. The error was 'The specified metadata was not found.

'.

For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

does this metadata have to do anything with text/xml format ?

Thanks in Advance for your Help,

Regards,

Sundar

|||

Hi,

It looks like your IIS metabase somehow got corrupted The metabase is indeed stored in XML format, you can find extensive info on the metabase here:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/6929e089-c495-4ac8-8db0-b069b349b7ba.mspx?mfr=true

"/LM/W3SVC" metabase entry corresponds to the WWW service:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/44a57859-8fbb-4238-a7b5-f10c34cf8fe8.mspx?mfr=true

Since IIS reports it can't load the metadata for the WWW service itself, you will most likely have to reinstall the IIS and everything on top of IIS (Windows SharePoint Services, TFS application tier, SQL Server Reporting Services and anything else that is hosted in IIS). Before doing that, though, consider posting your question in the IIS community, I hope someone will be able to assist you in fixing your metabase given the corruption is not fatal. If you have support incidents available, consider also contacting Microsoft Support and be sure to provide them with the maximum details of what happened before you started getting this nasty error message.

I apologize for not being more helpful - I am by no means an IIS expert. Hope the info above helps you to define the further direction of your support quest and good luck!

|||

Thanks for your reply,Buddy.

Will check with the IIS folks.

Regards,

Sundar

|||

Hi,

I re-installed IIS and then removed and re-installed .Net Framework 2.0 ..

Things finally worked my way !!

Thanks a lot for all your help !!

Regards,

Sundar