Showing posts with label inside. Show all posts
Showing posts with label inside. Show all posts

Sunday, March 25, 2012

combining datasets

I have two queries, one that brings back data from a cube and another that
returns records from a db. Is there anyway inside reporting services to
combine the two data sets?Only through subreports.
"Jessica C" <jesscobbe@.hotmail.com> wrote in message
news:ucK4AE02FHA.3272@.TK2MSFTNGP09.phx.gbl...
> I have two queries, one that brings back data from a cube and another that
> returns records from a db. Is there anyway inside reporting services to
> combine the two data sets?
>

Sunday, March 11, 2012

Columns referenced inside store procedures may not exist issue

I have a stored procedure which I want to be added to 2 different databases.
However, I run into an issue that some statements in the stored procedure ar
e
referencing columns only exist in one of the databases. I want to SQL Server
to parse those statements only if those columns exist in the database.
Thanks.Sorry, this is not how it works (you could use dynamic SQL, but that is not
generally a good option). You will need to make two versions of the
procedure or add the columns in the other database.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:75D605C4-6843-4E83-8E49-39252BA25FEA@.microsoft.com...
>I have a stored procedure which I want to be added to 2 different
>databases.
> However, I run into an issue that some statements in the stored procedure
> are
> referencing columns only exist in one of the databases. I want to SQL
> Server
> to parse those statements only if those columns exist in the database.
>
> Thanks.

Sunday, February 12, 2012

Color of the text inside a textbox

Hi,
is there any way by which i can give different colors to the text inside a
same textbox'
thanks
AtulNo, RS 2000 does not support this. It is on the wish list, basically we
plan to support RTF at some point.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Atul" <atul.anjankar@.approva.net> wrote in message
news:ea$RylMXEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> is there any way by which i can give different colors to the text inside a
> same textbox'
> thanks
> Atul
>|||No.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Atul" <atul.anjankar@.approva.net> wrote in message
news:ea$RylMXEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> is there any way by which i can give different colors to the text inside a
> same textbox'
> thanks
> Atul
>