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
Showing posts with label path. Show all posts
Showing posts with label path. Show all posts
Wednesday, March 28, 2012
Monday, March 19, 2012
How to add some attributes when I use For Xml Path?
How to add some attributes when I use For Xml Path?
As I developed the sql statement using For Xml Path, the users now required
add new attributes to some tags.
For Example:
SQL:
Select TOP 2 Code, Name From City For Xml Path('City')
<City>
<Code>1</Code>
<Name>STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name>LEXINGTON, GA</Name>
</City>
The new requirement and expected result as:
<City>
<Code>1</Code>
<Name Changed="N">STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name Changed="N">LEXINGTON, GA</Name>
</City>
Select TOP 2 Code, 'N' as "Name/@.Changed", Name From City For Xml
Path('City')
As I developed the sql statement using For Xml Path, the users now required
add new attributes to some tags.
For Example:
SQL:
Select TOP 2 Code, Name From City For Xml Path('City')
<City>
<Code>1</Code>
<Name>STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name>LEXINGTON, GA</Name>
</City>
The new requirement and expected result as:
<City>
<Code>1</Code>
<Name Changed="N">STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name Changed="N">LEXINGTON, GA</Name>
</City>
Select TOP 2 Code, 'N' as "Name/@.Changed", Name From City For Xml
Path('City')
How to add some attributes when I use For Xml Path?
How to add some attributes when I use For Xml Path?
As I developed the sql statement using For Xml Path, the users now required
add new attributes to some tags.
For Example:
SQL:
Select TOP 2 Code, Name From City For Xml Path('City')
<City>
<Code>1</Code>
<Name>STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name>LEXINGTON, GA</Name>
</City>
The new requirement and expected result as:
<City>
<Code>1</Code>
<Name Changed="N">STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name Changed="N">LEXINGTON, GA</Name>
</City>Select TOP 2 Code, 'N' as "Name/@.Changed", Name From City For Xml
Path('City')
As I developed the sql statement using For Xml Path, the users now required
add new attributes to some tags.
For Example:
SQL:
Select TOP 2 Code, Name From City For Xml Path('City')
<City>
<Code>1</Code>
<Name>STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name>LEXINGTON, GA</Name>
</City>
The new requirement and expected result as:
<City>
<Code>1</Code>
<Name Changed="N">STREATOR, IL</Name>
</City>
<City>
<Code>2</Code>
<Name Changed="N">LEXINGTON, GA</Name>
</City>Select TOP 2 Code, 'N' as "Name/@.Changed", Name From City For Xml
Path('City')
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
>
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
>
Subscribe to:
Posts (Atom)