Report Parameter Length

We are planning on passing in an XML document as a report parameter but have
not been able to determine if there is a maximum parameter length. Does SQL
Reporting Services 2000 have a maximum parameter length?
Thanks.I can only partially answer your question... If you are passing the parameter
via URL then you are constrained by the max URL length ( might be 255 I
think)..
YOu can pass the info INSIDE the HTML which removes the URL restriction...
There are examples in Books on line - search for URL under Reporting Services
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"RobinB" wrote:
> We are planning on passing in an XML document as a report parameter but have
> not been able to determine if there is a maximum parameter length. Does SQL
> Reporting Services 2000 have a maximum parameter length?
> Thanks.

Report Model with XML datasource

Is there a way to create a Report Model with XML / WebService as datasource?

I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer.

JDee,

Here's a link for setting the Report Service XML datasource. I hope this works for you.

http://msdn2.microsoft.com/en-us/library/ms345334.aspx

Ham

|||I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not.|||RS 2005 supports only SQL Server (2000 and up), Analysis Services 2005 and starting with SP2 Oracle as data sources.|||Yes, from my understanding models are generated from relational data sources. I believe XML can represent relational database (http://www.w3.org/XML/RDB.html). I think a data provider which supplies XML as data source would be a neat feature in the upcoming versions.

Report Model with XML datasource

Is there a way to create a Report Model with XML / WebService as datasource?

I am able to generate reports that connect to a WebService through Report Designer, but unable to find similar functionality in Model Designer.

JDee,

Here's a link for setting the Report Service XML datasource. I hope this works for you.

http://msdn2.microsoft.com/en-us/library/ms345334.aspx

Ham

|||I'm interested in the same possibility. As far as I've understood, it's possible to generate models only from relational data sources. It would be a great surprise for me if not.|||RS 2005 supports only SQL Server (2000 and up), Analysis Services 2005 and starting with SP2 Oracle as data sources.|||Yes, from my understanding models are generated from relational data sources. I believe XML can represent relational database (http://www.w3.org/XML/RDB.html). I think a data provider which supplies XML as data source would be a neat feature in the upcoming versions.

Report mdoel

Hi,
Is there any way of leveraging the new report model / ad hoc functionality
when reporting from xml data sources? Everything seems to be based around if
your data is actually in an xml format. Is this at all possible?
More specifically would it be possible if the xml data source was in fact a
web service?
I realise this is kind of quirky, it's just that I'm using RS to report off
a web service and now I'm wondering is there any way I coudl allow users to
simply build their own reports.
Any help / pointers would be much appreciated...
Thanks,
PhilXML data sources do not seem to be supported for model generation.
If you go to Report Manager, Data Sources, and look at the properties of a
SQL data source, you'll see a Generate Model button at the bottom. I thought
that if you had an XML data source, you would be able to generate a model
from there as well, however, that button disappears when the data source is
XML type.
"Phil Aldis" wrote:
> Hi,
> Is there any way of leveraging the new report model / ad hoc functionality
> when reporting from xml data sources? Everything seems to be based around if
> your data is actually in an xml format. Is this at all possible?
> More specifically would it be possible if the xml data source was in fact a
> web service?
> I realise this is kind of quirky, it's just that I'm using RS to report off
> a web service and now I'm wondering is there any way I coudl allow users to
> simply build their own reports.
> Any help / pointers would be much appreciated...
> Thanks,
> Phil

Report Manager Error

When I try to open the report manager (SQL Server 2005), I get an error that
says "Response is not well-formed XML - Error". This is the first time that
I have see this error, has anyone else seen it? Any idea about how to fix
it? I tried deleting the Report and Report Server directories in IIS and
recreating them using the Reporting Services Configuration tool, but this did
not make the error go away. I see the same error in the Business
Intelligence Developement Studio when I try to deploy reports. Any ideas
would be helpful. Thank you.
--
LaurieTOn Oct 10, 8:41 am, LaurieT <Laur...@.discussions.microsoft.com> wrote:
> When I try to open the report manager (SQL Server 2005), I get an error that
> says "Response is not well-formed XML - Error". This is the first time that
> I have see this error, has anyone else seen it? Any idea about how to fix
> it? I tried deleting the Report and Report Server directories in IIS and
> recreating them using the Reporting Services Configuration tool, but this did
> not make the error go away. I see the same error in the Business
> Intelligence Developement Studio when I try to deploy reports. Any ideas
> would be helpful. Thank you.
> --
> LaurieT
Do you have SP2 installed? If not, you will want to start there. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:41 am, LaurieT <Laur...@.discussions.microsoft.com> wrote:
> When I try to open the report manager (SQL Server 2005), I get an error that
> says "Response is not well-formed XML - Error". This is the first time that
> I have see this error, has anyone else seen it? Any idea about how to fix
> it? I tried deleting the Report and Report Server directories in IIS and
> recreating them using the Reporting Services Configuration tool, but this did
> not make the error go away. I see the same error in the Business
> Intelligence Developement Studio when I try to deploy reports. Any ideas
> would be helpful. Thank you.
> --
> LaurieT
It seems like my previous response was not posted.
If you haven't already, you will want to install SP2 for SQL Server
2005. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant