Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates successfully.

Here is the URL format I am trying: http://localhost/ReportServer?/FolderName/ReportName&rs:Command=render&Year=2006&Month=6&Day=9

Currently, my parameters are all set to null for default values. They are also not multivalued, not internal, not hidden, don't allow blank, and don't allow null. I have also looked through the valid values in the drop down box for each parameter and verified that the values I supplied in the URL do exist. Also, the data types for each parameter is Integer just like the data type found in the database.

In my opinion, this problem seems directly related to using an analysis services data source. After I was getting this problem, I created a sample report using SQL Server data source, used the same three parameters, and passed them in the URL. Everything on that report worked perfectly.

Please help, I've looked thorugh almost every piece of documentation regarding parameters for Reporting Services and still no luck. Thanks!!

Are you sure those are the names of the parameters and not the prompts?

You can view the parameter names in Report Manager.

|||These are the correct names of the parameters. The prompt names match the actual parameter names.|||

Can you post the portion of the RDL which defines the parameters?

Also make sure that the value you are assigning is really a proper value, and not the label for a proper value.

|||

Actually, I just figured out the problem...

When you are working with an analysis services data source, the parameter values are different from the values listed in the database.

For example, suppose you need the parameter CalendarYear. In the database the values are 2004, 2005, 2006, etc... However, in reporting services the parameter values are actually [DimensionName].[FieldName].&[value] ... or ..... [Date Dim].[CalendarYear].&[2006]

In case you are ever unclear of a parameter value for something, just go to the "Data" tab, click the Dataset for the parameter, ie. "CalendarYear". Then click out of the Design View. Finally, click the execute query button and observe the values listed in the parameter value column. These are the list of valid values which can be used.

As a side note, when adding these parameter values in a URL, you will need to escape the ampersand character in the value expression otherwise it won't work. For example, CalendarYear=[Date Dim].[CalendarYear].%26[2006]

I hope this helps everyone. I know I spent a lot of time working on this.

Thanks!!

|||i am not sure about the answer given above as the correct date time format to acess in url is

Code Snippet
YYYY-MM-DDTHH:MM:SS

And the report that is created above is defalut to query type that should not be right

bye
arya|||

I'm experiencing a similar problem, with a special character in the FieldName part of the parameter:

Someting like:

CalendarYear=[Date Dim].[Calendar ?Year].%26[2006]

I've already tried escaping the ? and characters:

CalendarYear=[Date Dim].[Calendar %abYear%bb].%26[2006]

Any ideas ?

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take one parameters in the URL to generate a detail report. when i pass parameter as

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=123

it works fine . But i want to send master report's parameter to detail at run time which is selected in master report, then i got an error

i want to use

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" &Parameters!p1.Value& "

but an error come i,e

" The path of the item '/UpdatedByClickTest/S,Parameters!p1.Value, "' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath)"

how can i pass parameter to remove this error?

plz any one help me i shall be thankfull to you

Hello Arshad,

Where are you trying to generate the URL?

If you just want to display a link, this will append your parajmeter to the URL:

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" + cStr(Parameters!p1.Value)

Hope this helps.

Jarret

|||

Thanks Jarret its working now i m using

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" & Parameters!p1.Value

now i want to use global server name becuase i will have to deploy reports to different servers e,g DEV, QA and Production

i m using code like

=Globals!ReportServerUrl & "?/UpdatedByClickTest/S&rs:Command=Render&P1="&Parameters!p1.Value

but its not working plz send me ur code.

|||

That should work, but not while you are designing the report. I tried what you posted and it worked when I deployed the report. When you deploy it to the server and run it from there, you should see the ReportServerURL showing correctly.

Jarret

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates successfully.

Here is the URL format I am trying: http://localhost/ReportServer?/FolderName/ReportName&rs:Command=render&Year=2006&Month=6&Day=9

Currently, my parameters are all set to null for default values. They are also not multivalued, not internal, not hidden, don't allow blank, and don't allow null. I have also looked through the valid values in the drop down box for each parameter and verified that the values I supplied in the URL do exist. Also, the data types for each parameter is Integer just like the data type found in the database.

In my opinion, this problem seems directly related to using an analysis services data source. After I was getting this problem, I created a sample report using SQL Server data source, used the same three parameters, and passed them in the URL. Everything on that report worked perfectly.

Please help, I've looked thorugh almost every piece of documentation regarding parameters for Reporting Services and still no luck. Thanks!!

Are you sure those are the names of the parameters and not the prompts?

You can view the parameter names in Report Manager.

|||These are the correct names of the parameters. The prompt names match the actual parameter names.|||

Can you post the portion of the RDL which defines the parameters?

Also make sure that the value you are assigning is really a proper value, and not the label for a proper value.

|||

Actually, I just figured out the problem...

When you are working with an analysis services data source, the parameter values are different from the values listed in the database.

For example, suppose you need the parameter CalendarYear. In the database the values are 2004, 2005, 2006, etc... However, in reporting services the parameter values are actually [DimensionName].[FieldName].&[value] ... or ..... [Date Dim].[CalendarYear].&[2006]

In case you are ever unclear of a parameter value for something, just go to the "Data" tab, click the Dataset for the parameter, ie. "CalendarYear". Then click out of the Design View. Finally, click the execute query button and observe the values listed in the parameter value column. These are the list of valid values which can be used.

As a side note, when adding these parameter values in a URL, you will need to escape the ampersand character in the value expression otherwise it won't work. For example, CalendarYear=[Date Dim].[CalendarYear].%26[2006]

I hope this helps everyone. I know I spent a lot of time working on this.

Thanks!!

|||i am not sure about the answer given above as the correct date time format to acess in url is

Code Snippet
YYYY-MM-DDTHH:MM:SS

And the report that is created above is defalut to query type that should not be right

bye
arya|||

I'm experiencing a similar problem, with a special character in the FieldName part of the parameter:

Someting like:

CalendarYear=[Date Dim].[Calendar ?Year].%26[2006]

I've already tried escaping the ? and characters:

CalendarYear=[Date Dim].[Calendar %abYear%bb].%26[2006]

Any ideas ?

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates successfully.

Here is the URL format I am trying: http://localhost/ReportServer?/FolderName/ReportName&rs:Command=render&Year=2006&Month=6&Day=9

Currently, my parameters are all set to null for default values. They are also not multivalued, not internal, not hidden, don't allow blank, and don't allow null. I have also looked through the valid values in the drop down box for each parameter and verified that the values I supplied in the URL do exist. Also, the data types for each parameter is Integer just like the data type found in the database.

In my opinion, this problem seems directly related to using an analysis services data source. After I was getting this problem, I created a sample report using SQL Server data source, used the same three parameters, and passed them in the URL. Everything on that report worked perfectly.

Please help, I've looked thorugh almost every piece of documentation regarding parameters for Reporting Services and still no luck. Thanks!!

Are you sure those are the names of the parameters and not the prompts?

You can view the parameter names in Report Manager.

|||These are the correct names of the parameters. The prompt names match the actual parameter names.|||

Can you post the portion of the RDL which defines the parameters?

Also make sure that the value you are assigning is really a proper value, and not the label for a proper value.

|||

Actually, I just figured out the problem...

When you are working with an analysis services data source, the parameter values are different from the values listed in the database.

For example, suppose you need the parameter CalendarYear. In the database the values are 2004, 2005, 2006, etc... However, in reporting services the parameter values are actually [DimensionName].[FieldName].&[value] ... or ..... [Date Dim].[CalendarYear].&[2006]

In case you are ever unclear of a parameter value for something, just go to the "Data" tab, click the Dataset for the parameter, ie. "CalendarYear". Then click out of the Design View. Finally, click the execute query button and observe the values listed in the parameter value column. These are the list of valid values which can be used.

As a side note, when adding these parameter values in a URL, you will need to escape the ampersand character in the value expression otherwise it won't work. For example, CalendarYear=[Date Dim].[CalendarYear].%26[2006]

I hope this helps everyone. I know I spent a lot of time working on this.

Thanks!!

|||i am not sure about the answer given above as the correct date time format to acess in url is

Code Snippet
YYYY-MM-DDTHH:MM:SS

And the report that is created above is defalut to query type that should not be right

bye
arya|||

I'm experiencing a similar problem, with a special character in the FieldName part of the parameter:

Someting like:

CalendarYear=[Date Dim].[Calendar ?Year].%26[2006]

I've already tried escaping the ? and characters:

CalendarYear=[Date Dim].[Calendar %abYear%bb].%26[2006]

Any ideas ?

sql

problem or bug in sqlxml 3.0

Im using Sqlxml 30 with sql 2000 and Visual studio 2003.
if I generate my xmldata file manaually it works fine, However if i
generate it using VisualStudio
using dataset.writexml with ignoreSchema method i get an invalid xml
file.The result is that sql xml creates an empty sql table !
The only difference in the xml file is the following :
<ds xmlns="http://www.tempuri.org/Ds.xsd">
..
</ds>
I presume the xmlns is the namespace stuff but why should its presence
break SQLXML.
Any ideas how to generate the file from the dataset object without this
attribute ?Obviously i am new to this stuff, im trying to get used to using Bulkload
Colin|||You might be able to solve the problem by specifying an annotated schema
that includes the same namespace in the Execute method. If you post your
XML, schema, and code maybe someone can help you out.
Cheers,
Graeme
_____________________
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group
www.contentmaster.com
"Colin Robinson" <colin@.rem_doubleclicksystems.co.uk> wrote in message
news:%23ZNMx1q8FHA.3804@.TK2MSFTNGP12.phx.gbl...
> Obviously i am new to this stuff, im trying to get used to using Bulkload
> Colin
>|||my actual files are two large to post here; but find below the code in
dotnet that should be self explanatory. as i say it works if I edit these
files to look like the Sqlxml samples:
Any assistance would be appreciated here:
'This creates my XML AND XSD files from a dataset dspos
'Me.DsPOS.WriteXml(SaveFileDialog.FileName,
XmlWriteMode.WriteSchema) 'writes with inline schema
'DsPOS.WriteXml("C:\Documents and
Settings\Administrator\Desktop\Updateser
ver.xml", XmlWriteMode.IgnoreSchema)
'writes without inline schema
'Me.DsPOS.WriteXmlSchema(SaveFileDialog.FileName.Replace("xml",
"xsd")) ' Creates the xsd file
'should now have everything i need for sqlxml so ...
'This should bulk load into an existing db named testdb creating the
tables as required
Dim objbl As New Object
objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
objbl.ConnectionString = "Provider=SQLOLEDB;Data
Source=(local);Persist Security Info=True;User ID=sa;Initial Catalog=Testdb"
objbl.ErrorLogFile = "C:\Documents and
Settings\Administrator\Desktop\error.log"
objbl.ErrorLogFile = "C:\Documents and
Settings\Administrator\Desktop\Tposerror
.txt"
objbl.CheckConstraints = False
objbl.XMLFragment = False
objbl.SchemaGen = True
objbl.SGDropTables = True
Try
'test with hardcoded filenames
objbl.Execute("C:\Documents and
Settings\Administrator\Desktop\TposSchem
a.xsd", "C:\Documents and
Settings\Administrator\Desktop\Updateser
ver.xml")
Catch ex As Exception
MsgBox(ex.Message)
End Try
objbl = Nothing
MsgBox("Complete")|||Hi Colin
Do you still have a problem? If so let me know and I will get somebody to
look into it.
Best regards
Michael
"Colin Robinson" <z@.x.com> wrote in message
news:%23it6zn28FHA.1188@.TK2MSFTNGP12.phx.gbl...
> my actual files are two large to post here; but find below the code in
> dotnet that should be self explanatory. as i say it works if I edit these
> files to look like the Sqlxml samples:
> Any assistance would be appreciated here:
>
> 'This creates my XML AND XSD files from a dataset dspos
> 'Me.DsPOS.WriteXml(SaveFileDialog.FileName,
> XmlWriteMode.WriteSchema) 'writes with inline schema
> 'DsPOS.WriteXml("C:\Documents and
> Settings\Administrator\Desktop\Updateser
ver.xml",
> XmlWriteMode.IgnoreSchema) 'writes without inline schema
> 'Me.DsPOS.WriteXmlSchema(SaveFileDialog.FileName.Replace("xml",
> "xsd")) ' Creates the xsd file
> 'should now have everything i need for sqlxml so ...
> 'This should bulk load into an existing db named testdb creating
> the tables as required
> Dim objbl As New Object
> objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
> objbl.ConnectionString = "Provider=SQLOLEDB;Data
> Source=(local);Persist Security Info=True;User ID=sa;Initial
> Catalog=Testdb"
> objbl.ErrorLogFile = "C:\Documents and
> Settings\Administrator\Desktop\error.log"
> objbl.ErrorLogFile = "C:\Documents and
> Settings\Administrator\Desktop\Tposerror
.txt"
> objbl.CheckConstraints = False
> objbl.XMLFragment = False
> objbl.SchemaGen = True
> objbl.SGDropTables = True
> Try
> 'test with hardcoded filenames
> objbl.Execute("C:\Documents and
> Settings\Administrator\Desktop\TposSchem
a.xsd", "C:\Documents and
> Settings\Administrator\Desktop\Updateser
ver.xml")
> Catch ex As Exception
> MsgBox(ex.Message)
> End Try
> objbl = Nothing
> MsgBox("Complete")
>
>|||thanks its still a problem.
must be something to do with the namespaces in the file headers. when i
execute it it does not error. i think its just not finding valid data to
create even though the xml is well formed.
Colin
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uItNInQAGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Colin
> Do you still have a problem? If so let me know and I will get somebody to
> look into it.
> Best regards
> Michael
> "Colin Robinson" <z@.x.com> wrote in message
> news:%23it6zn28FHA.1188@.TK2MSFTNGP12.phx.gbl...
>|||The problem was in the headers, I trashed the dotnet headers and replace
with the example header for bulkinsert schema. Did an edit replace to change
the xs: attributes to XSD: and it worked fine inserting 20,000 records in 7
seconds into a new table. Beating dts on the same box
Someone should get the ado net team to talk to the Sqlxml team to export the
xsd in a standard way across microsoft products! Especially relevant with
dotnet and sql being so closely coupled.
"Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
news:%23zBglxFDGHA.812@.TK2MSFTNGP10.phx.gbl...
> thanks its still a problem.
> must be something to do with the namespaces in the file headers. when i
> execute it it does not error. i think its just not finding valid data to
> create even though the xml is well formed.
> Colin
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:uItNInQAGHA.1124@.TK2MSFTNGP10.phx.gbl...
>|||Hi Colin
Ahh, good. The problem is that the prefixes should have a namespace uri
associated. The semantics is carried with the namespace URI and not the
prefix (ie xs, xsd).
Thanks for getting back to us with what your problem was though.
Best regards
Michael
"Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
news:%235BWvIKDGHA.3748@.TK2MSFTNGP10.phx.gbl...
> The problem was in the headers, I trashed the dotnet headers and replace
> with the example header for bulkinsert schema. Did an edit replace to
> change the xs: attributes to XSD: and it worked fine inserting 20,000
> records in 7 seconds into a new table. Beating dts on the same box
> Someone should get the ado net team to talk to the Sqlxml team to export
> the xsd in a standard way across microsoft products! Especially relevant
> with dotnet and sql being so closely coupled.
> "Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
> news:%23zBglxFDGHA.812@.TK2MSFTNGP10.phx.gbl...
>|||Michael.
Can you explain that in more detail then i could probably understad why i
had to make these changes manually. and may be able to overload writeXML
method to generate myself a valid XSD
if i read what you are saying correctly as long as dotnet produces a valid
url/Prefix pair you have a valid xsd. but not one that is compliant with
SQLXML !!!
next questions become
Is there a published resourse of these schemes.
Are there any conversion utils to convert one to the other.
why doesnt MS use the same one for all its products even if its not industry
standard.
and finally It would still be better if some sort of error message pointed
to the problem.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uy4VN3ODGHA.1816@.TK2MSFTNGP11.phx.gbl...
> Hi Colin
> Ahh, good. The problem is that the prefixes should have a namespace uri
> associated. The semantics is carried with the namespace URI and not the
> prefix (ie xs, xsd).
> Thanks for getting back to us with what your problem was though.
> Best regards
> Michael
> "Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
> news:%235BWvIKDGHA.3748@.TK2MSFTNGP10.phx.gbl...
>|||Hi Colin
You said yourself that you

That means that the generated XSD was fine, but then you changed it. By
doing so you seem to have lost some namespace prefix declarations...
An XML document <mynick:foo xmlns:mynick="uri"/> is the same as
<yournick:foo xmlns:yournick="foo"/> since the namespace prefix only servers
as an alias to the URI.
Every XML Schema however should work to some extend with SQLXML Bulkload
(especially once you have added your annotations).
Best regards
Michael
"Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
news:%23Exe0FsDGHA.2956@.TK2MSFTNGP14.phx.gbl...
> Michael.
> Can you explain that in more detail then i could probably understad why i
> had to make these changes manually. and may be able to overload writeXML
> method to generate myself a valid XSD
> if i read what you are saying correctly as long as dotnet produces a valid
> url/Prefix pair you have a valid xsd. but not one that is compliant with
> SQLXML !!!
> next questions become
> Is there a published resourse of these schemes.
> Are there any conversion utils to convert one to the other.
> why doesnt MS use the same one for all its products even if its not
> industry standard.
> and finally It would still be better if some sort of error message
> pointed to the problem.
>
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:uy4VN3ODGHA.1816@.TK2MSFTNGP11.phx.gbl...
>

problem or bug in sqlxml 3.0

Im using Sqlxml 30 with sql 2000 and Visual studio 2003.
if I generate my xmldata file manaually it works fine, However if i
generate it using VisualStudio
using dataset.writexml with ignoreSchema method i get an invalid xml
file.The result is that sql xml creates an empty sql table !
The only difference in the xml file is the following :
<ds xmlns="http://www.tempuri.org/Ds.xsd">
...
</ds>
I presume the xmlns is the namespace stuff but why should its presence
break SQLXML.
Any ideas how to generate the file from the dataset object without this
attribute ?
Obviously i am new to this stuff, im trying to get used to using Bulkload
Colin
|||You might be able to solve the problem by specifying an annotated schema
that includes the same namespace in the Execute method. If you post your
XML, schema, and code maybe someone can help you out.
Cheers,
Graeme
_____________________
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group
www.contentmaster.com
"Colin Robinson" <colin@.rem_doubleclicksystems.co.uk> wrote in message
news:%23ZNMx1q8FHA.3804@.TK2MSFTNGP12.phx.gbl...
> Obviously i am new to this stuff, im trying to get used to using Bulkload
> Colin
>
|||my actual files are two large to post here; but find below the code in
dotnet that should be self explanatory. as i say it works if I edit these
files to look like the Sqlxml samples:
Any assistance would be appreciated here:
'This creates my XML AND XSD files from a dataset dspos
'Me.DsPOS.WriteXml(SaveFileDialog.FileName,
XmlWriteMode.WriteSchema) 'writes with inline schema
'DsPOS.WriteXml("C:\Documents and
Settings\Administrator\Desktop\Updateserver.xml", XmlWriteMode.IgnoreSchema)
'writes without inline schema
'Me.DsPOS.WriteXmlSchema(SaveFileDialog.FileName.R eplace("xml",
"xsd")) ' Creates the xsd file
'should now have everything i need for sqlxml so ...
'This should bulk load into an existing db named testdb creating the
tables as required
Dim objbl As New Object
objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
objbl.ConnectionString = "Provider=SQLOLEDB;Data
Source=(local);Persist Security Info=True;User ID=sa;Initial Catalog=Testdb"
objbl.ErrorLogFile = "C:\Documents and
Settings\Administrator\Desktop\error.log"
objbl.ErrorLogFile = "C:\Documents and
Settings\Administrator\Desktop\Tposerror.txt"
objbl.CheckConstraints = False
objbl.XMLFragment = False
objbl.SchemaGen = True
objbl.SGDropTables = True
Try
'test with hardcoded filenames
objbl.Execute("C:\Documents and
Settings\Administrator\Desktop\TposSchema.xsd", "C:\Documents and
Settings\Administrator\Desktop\Updateserver.xml")
Catch ex As Exception
MsgBox(ex.Message)
End Try
objbl = Nothing
MsgBox("Complete")
|||Hi Colin
Do you still have a problem? If so let me know and I will get somebody to
look into it.
Best regards
Michael
"Colin Robinson" <z@.x.com> wrote in message
news:%23it6zn28FHA.1188@.TK2MSFTNGP12.phx.gbl...
> my actual files are two large to post here; but find below the code in
> dotnet that should be self explanatory. as i say it works if I edit these
> files to look like the Sqlxml samples:
> Any assistance would be appreciated here:
>
> 'This creates my XML AND XSD files from a dataset dspos
> 'Me.DsPOS.WriteXml(SaveFileDialog.FileName,
> XmlWriteMode.WriteSchema) 'writes with inline schema
> 'DsPOS.WriteXml("C:\Documents and
> Settings\Administrator\Desktop\Updateserver.xml",
> XmlWriteMode.IgnoreSchema) 'writes without inline schema
> 'Me.DsPOS.WriteXmlSchema(SaveFileDialog.FileName.R eplace("xml",
> "xsd")) ' Creates the xsd file
> 'should now have everything i need for sqlxml so ...
> 'This should bulk load into an existing db named testdb creating
> the tables as required
> Dim objbl As New Object
> objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
> objbl.ConnectionString = "Provider=SQLOLEDB;Data
> Source=(local);Persist Security Info=True;User ID=sa;Initial
> Catalog=Testdb"
> objbl.ErrorLogFile = "C:\Documents and
> Settings\Administrator\Desktop\error.log"
> objbl.ErrorLogFile = "C:\Documents and
> Settings\Administrator\Desktop\Tposerror.txt"
> objbl.CheckConstraints = False
> objbl.XMLFragment = False
> objbl.SchemaGen = True
> objbl.SGDropTables = True
> Try
> 'test with hardcoded filenames
> objbl.Execute("C:\Documents and
> Settings\Administrator\Desktop\TposSchema.xsd", "C:\Documents and
> Settings\Administrator\Desktop\Updateserver.xml")
> Catch ex As Exception
> MsgBox(ex.Message)
> End Try
> objbl = Nothing
> MsgBox("Complete")
>
>
|||thanks its still a problem.
must be something to do with the namespaces in the file headers. when i
execute it it does not error. i think its just not finding valid data to
create even though the xml is well formed.
Colin
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uItNInQAGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Hi Colin
> Do you still have a problem? If so let me know and I will get somebody to
> look into it.
> Best regards
> Michael
> "Colin Robinson" <z@.x.com> wrote in message
> news:%23it6zn28FHA.1188@.TK2MSFTNGP12.phx.gbl...
>
|||The problem was in the headers, I trashed the dotnet headers and replace
with the example header for bulkinsert schema. Did an edit replace to change
the xs: attributes to XSD: and it worked fine inserting 20,000 records in 7
seconds into a new table. Beating dts on the same box
Someone should get the ado net team to talk to the Sqlxml team to export the
xsd in a standard way across microsoft products! Especially relevant with
dotnet and sql being so closely coupled.
"Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
news:%23zBglxFDGHA.812@.TK2MSFTNGP10.phx.gbl...
> thanks its still a problem.
> must be something to do with the namespaces in the file headers. when i
> execute it it does not error. i think its just not finding valid data to
> create even though the xml is well formed.
> Colin
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:uItNInQAGHA.1124@.TK2MSFTNGP10.phx.gbl...
>
|||Hi Colin
Ahh, good. The problem is that the prefixes should have a namespace uri
associated. The semantics is carried with the namespace URI and not the
prefix (ie xs, xsd).
Thanks for getting back to us with what your problem was though.
Best regards
Michael
"Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
news:%235BWvIKDGHA.3748@.TK2MSFTNGP10.phx.gbl...
> The problem was in the headers, I trashed the dotnet headers and replace
> with the example header for bulkinsert schema. Did an edit replace to
> change the xs: attributes to XSD: and it worked fine inserting 20,000
> records in 7 seconds into a new table. Beating dts on the same box
> Someone should get the ado net team to talk to the Sqlxml team to export
> the xsd in a standard way across microsoft products! Especially relevant
> with dotnet and sql being so closely coupled.
> "Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
> news:%23zBglxFDGHA.812@.TK2MSFTNGP10.phx.gbl...
>
|||Michael.
Can you explain that in more detail then i could probably understad why i
had to make these changes manually. and may be able to overload writeXML
method to generate myself a valid XSD
if i read what you are saying correctly as long as dotnet produces a valid
url/Prefix pair you have a valid xsd. but not one that is compliant with
SQLXML !!!
next questions become
Is there a published resourse of these schemes.
Are there any conversion utils to convert one to the other.
why doesnt MS use the same one for all its products even if its not industry
standard.
and finally It would still be better if some sort of error message pointed
to the problem.
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uy4VN3ODGHA.1816@.TK2MSFTNGP11.phx.gbl...
> Hi Colin
> Ahh, good. The problem is that the prefixes should have a namespace uri
> associated. The semantics is carried with the namespace URI and not the
> prefix (ie xs, xsd).
> Thanks for getting back to us with what your problem was though.
> Best regards
> Michael
> "Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
> news:%235BWvIKDGHA.3748@.TK2MSFTNGP10.phx.gbl...
>
|||Hi Colin
You said yourself that you
[vbcol=seagreen]
That means that the generated XSD was fine, but then you changed it. By
doing so you seem to have lost some namespace prefix declarations...
An XML document <mynick:foo xmlns:mynick="uri"/> is the same as
<yournick:foo xmlns:yournick="foo"/> since the namespace prefix only servers
as an alias to the URI.
Every XML Schema however should work to some extend with SQLXML Bulkload
(especially once you have added your annotations).
Best regards
Michael
"Colin Robinson" <colin@.Doubleclicksystems.co.uk.nospam> wrote in message
news:%23Exe0FsDGHA.2956@.TK2MSFTNGP14.phx.gbl...
> Michael.
> Can you explain that in more detail then i could probably understad why i
> had to make these changes manually. and may be able to overload writeXML
> method to generate myself a valid XSD
> if i read what you are saying correctly as long as dotnet produces a valid
> url/Prefix pair you have a valid xsd. but not one that is compliant with
> SQLXML !!!
> next questions become
> Is there a published resourse of these schemes.
> Are there any conversion utils to convert one to the other.
> why doesnt MS use the same one for all its products even if its not
> industry standard.
> and finally It would still be better if some sort of error message
> pointed to the problem.
>
>
> "Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
> news:uy4VN3ODGHA.1816@.TK2MSFTNGP11.phx.gbl...
>

Problem in Web Reporting

Hi,

I'm using CR 9 RDC objects with ASP to publish the reports in the web. Works fine.

The problem is while trying to generate a complex report which takes few mins to open, I can't open other reports at the same time. No error in Creating the report object. But raises

"Crystal Report job Failed. A Free license coundn't be obtained in the allocated"

in the statement

session("oRpt").ReadRecords

If you have any idea please help me

Thanks.Hi ,
Could you please take a look at the problem I have posted today ( under Crystal Reports + ADO title ., It is a strange problem I am facing and hav'ent been able to find a solution so far , I noticed that you have helped quite a few guys in Crystal reports- hence this message to you !
Thanks for any help !