Multiple datasources in SSRS 2005 reports

Hi,
Is is possible to have multiple analysis Services datasources for a single
report? I want to be able to display measures from both cubes on the same
report with a common dimension without having to redesign my cubes.
Thanks!
BrianThe short answer is yes, but you won't be able to display the measures
side-by-side in the same region if this is what you are after. That's
because you cannot join RS datasets. That said, you can have two regions,
each bound to its own dataset. If you have a virtual cube and your MDX query
pulls data from both cubies than you should be OK.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:756074632671466407265129@.msnews.microsoft.com...
> Hi,
> Is is possible to have multiple analysis Services datasources for a single
> report? I want to be able to display measures from both cubes on the same
> report with a common dimension without having to redesign my cubes.
> Thanks!
> Brian
>

Multiple datasources

Hi,
I've written a report that uses a matrix to display some data that all
comes from a funky select statement. The report is month based, so
there is a where clause specifying the month in the select
The user now wants to add a Year to Date column. Because of the data
structure of the data i don't believe it is possible to pull the YTD
figure in the same statment.
Is it possible to have one of the columns in a matrix (or any other
control) that is based on a different dataset which takes a parameters
from the matrix row?
I'm guessing theres not, but I just want to make sure, theres alot of
smart people out there :)
Thanks
AndrewWhat you want to do is to investigate subreports. You can embed a subreport
into a column (I have done this). If the subreport returns multiple rows
then that column would go down multiple rows. In your case you will only be
returning a single row. You will want the subreport to be very simple
(obviously) since you are embeding it. Note that the subreport is called for
every row. What I do in this case is hide the report in list view so users
don't see it when selecting a report to run.
To develop a subreport you develop it like a normal report with parameters.
Make sure it works. Drag and drop the report into the column you want (add
an extra column/field that is blank and drop it into it). Then do a right
mouse click on the embeded subreport and select parameters to map the
subreport parameters to the appropriate field.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ajharvey@.gmail.com> wrote in message
news:1114049920.896557.185450@.o13g2000cwo.googlegroups.com...
> Hi,
> I've written a report that uses a matrix to display some data that all
> comes from a funky select statement. The report is month based, so
> there is a where clause specifying the month in the select
> The user now wants to add a Year to Date column. Because of the data
> structure of the data i don't believe it is possible to pull the YTD
> figure in the same statment.
> Is it possible to have one of the columns in a matrix (or any other
> control) that is based on a different dataset which takes a parameters
> from the matrix row?
> I'm guessing theres not, but I just want to make sure, theres alot of
> smart people out there :)
> Thanks
> Andrew
>|||Thanks,
I'll give that a try

Multiple datasets in a single chart?

Is it possible to incorporate data from 2 datasets into a single chart? For example I have 1 set of data from 1 db which allows me to display datapoint "A" by week. I have a second dataset from another db which allows me to display datapoint "B" by week. I'd like to plot each of these separate datapoints on a single chart with the x axis being week and the y axis being a stacked bar chart incorporating both A and B values as individual data series. Further, assuming this is possible, is it then possible to have 1 series displayed as an area while the 2nd series is a column or line?
Thanks in advance!

Did you ever find a way to do this? In the middle of a Reporting Services 2005 evaluation and we are trying to reproduce this functionality.|||Sorry this is currently not supported. You would need to join the two result sets already in the dataset query to be able to use it in the same chart.

-- Robert

Multiple datasets in a single chart?

Is it possible to incorporate data from 2 datasets into a single chart? For example I have 1 set of data from 1 db which allows me to display datapoint "A" by week. I have a second dataset from another db which allows me to display datapoint "B" by week. I'd like to plot each of these separate datapoints on a single chart with the x axis being week and the y axis being a stacked bar chart incorporating both A and B values as individual data series. Further, assuming this is possible, is it then possible to have 1 series displayed as an area while the 2nd series is a column or line?
Thanks in advance!

Did you ever find a way to do this? In the middle of a Reporting Services 2005 evaluation and we are trying to reproduce this functionality.|||Sorry this is currently not supported. You would need to join the two result sets already in the dataset query to be able to use it in the same chart.

-- Robert

Multiple Database

I am trying to display data from two databases.

in case of one database we can join multiple tables.

But how to join tables in multiple database.

If you are using the databases on the same server you will be able to use them by using there fully qualified names "<database>.<schema>.<Table>", as long as you have permission to access the tables in each database.

If the databases are on different servers you will first need to create a linked server on the database servers and then use the four part name for the table... "<server>.<database>.<schema>.<Table>", Check linked servers in the books online.

Multiple columns?

I have a SPROC that returns any number of vehicle options for a specific
vehicle.
I want to display the information in a multi-column fashion like this...
4speed Auto Windows Floor mats
Radio Bucket Seats Wheels
NOT like this
4speed
Auto Windows
Floor mats
Radio
Bucket Seats
Wheels
What control should I use, and how do I do it? I've tried for a while now
and can't find a solution.
Thanks in advance!
BrianHave you tried using the Table control. In your case, I think you will need
to add a second detail row.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Cesafsky" <brian.cesafsky@.autotrackerplus.com> wrote in message
news:O0IborWuFHA.2568@.TK2MSFTNGP15.phx.gbl...
>I have a SPROC that returns any number of vehicle options for a specific
>vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> What control should I use, and how do I do it? I've tried for a while now
> and can't find a solution.
>
> Thanks in advance!
> Brian
>
>|||yes, I tried that, but I must be doing something wrong... I just get the
same option repeated... like this...
4speed
4speed
Auto Windows
Auto Windows
Floor mats
Floor mats
Radio
Radio
Bucket Seats
Bucket Seats
Wheels
Wheels
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23$aN0fiuFHA.2920@.TK2MSFTNGP10.phx.gbl...
> Have you tried using the Table control. In your case, I think you will
> need to add a second detail row.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Brian Cesafsky" <brian.cesafsky@.autotrackerplus.com> wrote in message
> news:O0IborWuFHA.2568@.TK2MSFTNGP15.phx.gbl...
>>I have a SPROC that returns any number of vehicle options for a specific
>>vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> What control should I use, and how do I do it? I've tried for a while
>> now and can't find a solution.
>>
>> Thanks in advance!
>> Brian
>>
>

multiple columns of images

I need to be able to display multiple (external) images per row in one
control. The report that the control is on must have only one column, since
other controls (namely a table control) house enough columnar data to fill
an
entire page and then some.
I'm not trying to repeat the same image many times, I want to use space
efficiently by having several images per row. For example, instead of
having
30 images displayed in a single column, I would like to have either 15 rows
with two images per row; or 10 rows with 3 images per row.
I am using BI Report Builder in VS 2005.
I currently have a table control that to displays a single column of images
(via an image control).
I'm using image controls in the table to point to external images (hosted by
a web server). My database has a table with one column indicating the
external location of my images. This part works great.
I don't want to use the RepeatWith property because the
PDF renderer doesn't support it.
I have attempted to use the Matrix, and was able to create a single row that
spanned many pages. These spanned pages have grundles of blank, unformatted
space; which is simply unacceptable for my report's required
professionalism.
Perhaps there is a way to line feed or carriage return this long row?
Using a SubReport with multiple columns is unacceptable because subreports
inherit their parent column settings, which would be 1 in this case.
I would appreciate any help.
RobertHi Robert,
Thank you for using MSDN Managed Newsgroup Support.
Would you please make this issue more clear? I know you want to display the
images in a row. Based on my scope, you could add multiple images in
multiple columns of the table.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

multiple columns in details section

I have three fields in my report that make up each record. I would like to display these in detail section.

so instead of

1. alam Dept1 10000
2. khaiser dept2 20000
3. mujeeb dept2 20000

I would have

alam khaiser mujeeb ...
dept1 dept2 dept2 ...
10000 20000 20000 ..Use Crosstab Report|||1. Right-click on the dtails section, to open the Section Expert dialog box.

2. On the 'Sections' list, click the details section.

3. On the 'Common' tab, select 'Format with multiple columns' check box. A new tab called 'Layout' appears.

4. On the 'Layout' tab, specify the formatting for the columns:

Enter the width of the column in the 'Width' box. (you can set the height by dragging the section borders in the Design view of the report)

Enter the space between labels going across the page in the 'Horizontal gap' checkbox.

Enter the space between labels going down the page in the 'Vertical gap' box.

Select the printing direction, 'Across then Down' or 'Down then Across'.

Good Luck|||after using the Scetion expert i got mutliple columns but the sum of salary should be in right side but it is not coming ......

Multiple columns - 3rd post...

I have a SPROC that returns any number of vehicle options for a specific
vehicle.
I want to display the information in a multi-column fashion like this...
4speed Auto Windows Floor mats
Radio Bucket Seats Wheels
NOT like this
4speed
Auto Windows
Floor mats
Radio
Bucket Seats
Wheels
Somone suggested using the Table control and to add a second detail row.
I tried that, but I must be doing something wrong... I just get the
same option repeated... like this...
4speed
4speed
Auto Windows
Auto Windows
Floor mats
Floor mats
Radio
Radio
Bucket Seats
Bucket Seats
Wheels
Wheels
Thanks in advance!Have you tried using the MATRIX feature?
Is there a MAX to how many features a vehicle can have?
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||sorry, missed that last question... no, there is no MAX
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||I did try that... didn't work...
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||Brian,
You could use a list and in the list arrange the textboxes however you
wanted them. You would just need to make sure you had enough boxes for the
vehicle options.
Not sure if this is the correct solution for what you need, but just another
idea.
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||Create a three column report, with a body so short it only holds the
one text box. Similar approach as would be used for mailing labels.|||I am trying this, but what happens is that I see Column2 and column3 to the
right of the first column, I place the text box in the first column, and
what I see in the out put is the very last option from my query and that is
it.
any ideas?
Thanks again!
"Parker" <psmith@.iquest.net> wrote in message
news:1128084282.571367.232050@.o13g2000cwo.googlegroups.com...
> Create a three column report, with a body so short it only holds the
> one text box. Similar approach as would be used for mailing labels.
>|||Modify your stored proc so that it returns a concatenated string wit
a carriage return after each third entry. Then display the result i
a text box and the text will wrap. The string should something lik
this
item1 & " " & item 2 & " " & item 3 & char(13
& char(10) & item4 ...
Most lilkely you will have to use a cursor to build the string an
also do some text manipulation to force column alignment