Showing posts with label url. Show all posts
Showing posts with label url. Show all posts

Wednesday, March 28, 2012

How to assign Data Source in URL path

I have to use one report with several databases. So I've created several
Shared Data Source objects with different database's names in connection
strings. And now how can I switch between these Data Sources ?Dynamic (expression-based) datasource connection strings are not supported
in the current release. See this previous post for a workaround:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=e86a6f2d-3d5e-4dd7-9356-71236347236f
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"IBug" <IBug@.discussions.microsoft.com> wrote in message
news:4F0E598C-4CCF-44D8-800F-7045029DB499@.microsoft.com...
> I have to use one report with several databases. So I've created several
> Shared Data Source objects with different database's names in connection
> strings. And now how can I switch between these Data Sources ?|||"Ravi Mumulla (Microsoft)" wrote:
> Dynamic (expression-based) datasource connection strings are not supported
> in the current release. See this previous post for a workaround:
I have not to change CONNECTION STRING - I would like to assing/bind
different shared data source OBJECTs to the report. Really the problem is:
clients have some divisions base on different databases. The databases are
the same and the user has to run the report on one of these databases. If I
can not change connection string in data source object (as you said) and can
not assing/bind another data source object to the report - what have I do ?
Copy hundreds reports for each databases ? It's not great idea.|||The queries themselves can be expressions as long as they return the same
resulting field lists.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"IBug" <IBug@.discussions.microsoft.com> wrote in message
news:CD967DBC-6AD5-4596-9569-2E0E1AA3DE16@.microsoft.com...
> "Ravi Mumulla (Microsoft)" wrote:
>> Dynamic (expression-based) datasource connection strings are not
>> supported
>> in the current release. See this previous post for a workaround:
> I have not to change CONNECTION STRING - I would like to assing/bind
> different shared data source OBJECTs to the report. Really the problem is:
> clients have some divisions base on different databases. The databases are
> the same and the user has to run the report on one of these databases. If
> I
> can not change connection string in data source object (as you said) and
> can
> not assing/bind another data source object to the report - what have I do
> ?
> Copy hundreds reports for each databases ? It's not great idea.sql

Monday, March 12, 2012

How to add link in a report as a button?

Hi,

I want to add a link in a report, possibly a url link or a link to other report. One way of doing this is to go to properties of textbox and then update the jump to option.

But how to do this through a click of a button, inside the report?

I am having Microsoft Visual Studio 2005, designer's version.

thanks

You can use the Action property of a textbox and format that as a standard link (underlined).

For a 'button', I believe you'd have to make an image per button and then use an image control, and again leveraging the action property.

There may be custom controls out there that will make the button for you and you'd just set the caption.. but I don't know for sure.

Wednesday, March 7, 2012

How to add an image dynamically using an URL

I need to generate a report which (1)using a dataset to get the path
and file names of a group of GIF images from a database table, and (2)
dynamically construct an URL for each images, and finally (3) using the
URLs to dynamically add the images into the report pages.
Since I have millions of images stored in a virtual directory, I cannot
add them all into my report project.
Thanks in advance if anybody have any solution and can share it with
me!
TommyYou will need SP1 of RS 2000 which supports retrieving "external" images
through http://. Check section 4.1.4 of the SP1 readme for details.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tommy" <qtao@.doe.k12.de.us> wrote in message
news:1114002588.814601.73710@.g14g2000cwa.googlegroups.com...
>I need to generate a report which (1)using a dataset to get the path
> and file names of a group of GIF images from a database table, and (2)
> dynamically construct an URL for each images, and finally (3) using the
> URLs to dynamically add the images into the report pages.
> Since I have millions of images stored in a virtual directory, I cannot
> add them all into my report project.
> Thanks in advance if anybody have any solution and can share it with
> me!
> Tommy
>

How to add a URL to a ASP page into the Reporting Services folder

I want to add the URL to a ASP page into the Reporting Services Folder.
We are sort of using the Reporting Services as a portal to our other
reporting applications. I want to include the URL to a ASP page in a
reporting services folder not sure how to do this.
Please help with a simple URL scenario.
Thanks
Karenfirst add a web reference to ASP project
then define parameters of Reporting Service.render()
the url is a parameter of that function.
it works well on ASP.NET
but i do not know whether it is available on ASP|||Sorry, all I want to do is add an HTML page URL link to a reporting
services folder. I could not find much information on how to do this in
report manager.
Thanks
Karen|||the url is like that http://localhost/ReportServer?/sample
rs/Nametag&rs:Format=pdf
some of the url parameters are BookimakrID,DocMap, EndFind,FallbackPage|||So how do I publish the link to a URL into the Report Folder
Thanks
Karen|||All I want to do is put URLs to other applications and HTML pages into
the RS Folder. So sort of I want to use it as a portal not just as a
means to reach only reports
Thanks
Karen|||The only way I am aware of how to do this is to add a page that has the
links. You can create an HTML page and then add it to your report project
and deploy it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<karenmiddleol@.yahoo.com> wrote in message
news:1131673239.202311.213960@.f14g2000cwb.googlegroups.com...
> All I want to do is put URLs to other applications and HTML pages into
> the RS Folder. So sort of I want to use it as a portal not just as a
> means to reach only reports
> Thanks
> Karen
>