Showing posts with label alli. Show all posts
Showing posts with label alli. Show all posts

Friday, March 30, 2012

How to get the URL to access a report?

hi, all

I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report.

Basically it's something like this:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002

where Year is a parameter. Check the SQl Server Books Online for URL access.|||

Thanks.

More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||Hi,
How if i want to pass my reporting server login credential in the url?

How to get the URL to access a report?

hi, all

I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report.

Basically it's something like this:

http://servername/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&Year=2002

where Year is a parameter. Check the SQl Server Books Online for URL access.|||

Thanks.

More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx

|||Hi,
How if i want to pass my reporting server login credential in the url?

Friday, March 9, 2012

How to get publisher name , publication name and publish database?

Hi All:
i want to write a winform to search publisher name , publication
name and publish database from local sql sever dynamicly.(C#),
So anyone can give some hints of what's method or function to get
publisher name , publication name and publish database from local sql sever?
Thanks
nick
Check out "Introducing Replication Programming", "Replication Object", and
"Samples" in Books online.
Donna
"nick" wrote:

> Hi All:
> i want to write a winform to search publisher name , publication
> name and publish database from local sql sever dynamicly.(C#),
> So anyone can give some hints of what's method or function to get
> publisher name , publication name and publish database from local sql sever?
>
> Thanks
> nick
>
>