multiple instances install

Is it possible to install multiple instances of RS on one server? if so, how
do I do that?
The reason for needing this is that I have two groups of customers. One
group should be authenticated through Active Directory, while another group
should use cookies for authentication (they are authenticated through another
application which has its own user database). It is only poosible to have one
authentication mecjanism on one Reporting Server.RS 2000 does not support multiple instances on a single box. RS 2005 does.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Billy" <Billy@.discussions.microsoft.com> wrote in message
news:F597A5E8-CC70-475C-ACD7-AD0090C968E1@.microsoft.com...
> Is it possible to install multiple instances of RS on one server? if so,
> how
> do I do that?
> The reason for needing this is that I have two groups of customers. One
> group should be authenticated through Active Directory, while another
> group
> should use cookies for authentication (they are authenticated through
> another
> application which has its own user database). It is only poosible to have
> one
> authentication mecjanism on one Reporting Server.|||Great! I am using RS 2005.
How do I install and configure a multiple instances setup?
"Daniel Reib [MSFT]" wrote:
> RS 2000 does not support multiple instances on a single box. RS 2005 does.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Billy" <Billy@.discussions.microsoft.com> wrote in message
> news:F597A5E8-CC70-475C-ACD7-AD0090C968E1@.microsoft.com...
> > Is it possible to install multiple instances of RS on one server? if so,
> > how
> > do I do that?
> >
> > The reason for needing this is that I have two groups of customers. One
> > group should be authenticated through Active Directory, while another
> > group
> > should use cookies for authentication (they are authenticated through
> > another
> > application which has its own user database). It is only poosible to have
> > one
> > authentication mecjanism on one Reporting Server.
>
>|||You just need to run setup again. It should ask you if you want to install
an instance.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Billy" <Billy@.discussions.microsoft.com> wrote in message
news:0E230F61-8523-427F-88CE-154D2DCC0E5F@.microsoft.com...
> Great! I am using RS 2005.
> How do I install and configure a multiple instances setup?
> "Daniel Reib [MSFT]" wrote:
>> RS 2000 does not support multiple instances on a single box. RS 2005
>> does.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Billy" <Billy@.discussions.microsoft.com> wrote in message
>> news:F597A5E8-CC70-475C-ACD7-AD0090C968E1@.microsoft.com...
>> > Is it possible to install multiple instances of RS on one server? if
>> > so,
>> > how
>> > do I do that?
>> >
>> > The reason for needing this is that I have two groups of customers. One
>> > group should be authenticated through Active Directory, while another
>> > group
>> > should use cookies for authentication (they are authenticated through
>> > another
>> > application which has its own user database). It is only poosible to
>> > have
>> > one
>> > authentication mecjanism on one Reporting Server.
>>|||ok, thanks
"Daniel Reib [MSFT]" wrote:
> You just need to run setup again. It should ask you if you want to install
> an instance.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Billy" <Billy@.discussions.microsoft.com> wrote in message
> news:0E230F61-8523-427F-88CE-154D2DCC0E5F@.microsoft.com...
> > Great! I am using RS 2005.
> >
> > How do I install and configure a multiple instances setup?
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> RS 2000 does not support multiple instances on a single box. RS 2005
> >> does.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Billy" <Billy@.discussions.microsoft.com> wrote in message
> >> news:F597A5E8-CC70-475C-ACD7-AD0090C968E1@.microsoft.com...
> >> > Is it possible to install multiple instances of RS on one server? if
> >> > so,
> >> > how
> >> > do I do that?
> >> >
> >> > The reason for needing this is that I have two groups of customers. One
> >> > group should be authenticated through Active Directory, while another
> >> > group
> >> > should use cookies for authentication (they are authenticated through
> >> > another
> >> > application which has its own user database). It is only poosible to
> >> > have
> >> > one
> >> > authentication mecjanism on one Reporting Server.
> >>
> >>
> >>
>
>

Multiple Datasets but needs to be tied together

I am needing to take data from one data set that consists of a list of parts and their stock information. Then I am needing to show any transactions that the individual parts may have had during the time that user defined through the filters.

This requires me to have two data sets since I can't do a join between the stocking information and the transactions due to the fact that it is very possible that every part won't have a transaction for each month of each year. Doing a left join still filters down the data too much so thus the need for two data sets.

I have these parameters:

Vendor, Year, Month, Type of request

Vendor and Type of Request is handled through StockInfoDataset. I then need to update the table showing 0 or transaction amount from TransactionDataset filtered by the ItemNumber and WarehouseCode that is in StockInfoDataset. Since it seems List and Table only allow one dataset in them, I am at a loss as to how I would go about doing this.

Explaining this is quite difficult in a forum post, but hopefully someone would be able to shine some light on possibly avenues to follow here....thank you in advance.

Josh

I'm not sure I understand 100% what you're facing, but here's how I would try to tackle this...

Each parameter can have a separate dataset, for lookup purposes.
Then the main dataset can be based on the selected report parameters.
Finally, I would use either a view or a stored procedure to return the needed dataset.
Using the view/sp provides a lot of flexibility that direct table queries do not, including the ability to join, summarize, and otherwise process values from multiple tables.

I hope that helps.

|||

Your solution may very well work, but I have never done it that way so I am a bit at a loss.....

Unfortunately, unless there is something I am missing, I can't use a view or stored procedure to derive this information....here is an example of what I am wanting to do

Vendor = ABC, Year = 2006, Month = 07, Type = Qty On Hand > 0

Table A

[Column AA] [Column AB] [Column AC]

Item1 Whs1 QtyOnHand1

Item2 Whs1 QtyOnHand2

Item3 Whs2 QtyOnHand3

Item4 Whs1 QtyOnHand0

Table B

[Columnb BA] [ColumnBB] [Column BC] [ColumnBD]

Item1 Whs1 06/01/06 QtySold1

Item1 Whs1 07/01/06 QtySold2

Item2 Whs1 05/01/06 QtySold3

Item3 Whs2 06/01/06 QtySold4

Item4 Whs1 07/01/06 QtySold5

So when I do

SELECT * FROM [TableA] LEFT OUTER JOIN [TableB] ON [TableA].[Column AA] = [TableB].[Column BA] AND [TableA].[Column AB] = [TableB].[Column BB] WHERE [TableA].[QtyOnHand] > 0

I am going to get a result set of

Item1 Whs1 QtyOnHand1 Item1 Whs1 06/01/06 QtySold1

Item1 Whs1 QtyOnHand1 Item1 Whs1 07/01/06 QtySold1

Item2 Whs1 QtyOnHand2 Item2 Whs1 05/01/06 QtySold3

Item3 Whs2 QtyOnHand3 Item3 Whs2 06/01/06 QtySold4

This is essentially what my View Does that I am selecting from....

Now in my report I have them select year and month......to filter what transactions are going to be summed.

My problem is that I still need to show the qtyOnhand and such even though there my be no transactions for the time period they select....so using the parameters above. This is what I get then after that I'll show what I want...

This is what I get:

Item1 Whs1 QtyOnHand1 Item1 Whs1 07/01/06 SUM(QtySold1)

This is what I want:

Item1 Whs1 QtyOnHand1 Item1 Whs1 06/01/06 0

Item1 Whs1 QtyOnHand1 Item1 Whs1 07/01/06 SUM(QtySold1)

Item2 Whs1 QtyOnHand2 Item2 Whs1 05/01/06 0

Item3 Whs2 QtyOnHand3 Item3 Whs2 06/01/06 0

I hope this clarifies things a bit....

Thank you,

Josh

|||

It seems like it's possibly to query what you need and get it in 1 dataset, then maybe doing some filtering or special exclusions, but first,

can you please give your relevant tables and their column names? I know you were trying to be discrete, but COLUMNAA, COLUMNAB is hard to put into motion. After that, I'm sure someone can get you a query that will do the job (full outer join might be necessary).

Multiple Datasets but needs to be tied together

I am needing to take data from one data set that consists of a list of parts and their stock information. Then I am needing to show any transactions that the individual parts may have had during the time that user defined through the filters.

This requires me to have two data sets since I can't do a join between the stocking information and the transactions due to the fact that it is very possible that every part won't have a transaction for each month of each year. Doing a left join still filters down the data too much so thus the need for two data sets.

I have these parameters:

Vendor, Year, Month, Type of request

Vendor and Type of Request is handled through StockInfoDataset. I then need to update the table showing 0 or transaction amount from TransactionDataset filtered by the ItemNumber and WarehouseCode that is in StockInfoDataset. Since it seems List and Table only allow one dataset in them, I am at a loss as to how I would go about doing this.

Explaining this is quite difficult in a forum post, but hopefully someone would be able to shine some light on possibly avenues to follow here....thank you in advance.

Josh

I'm not sure I understand 100% what you're facing, but here's how I would try to tackle this...

Each parameter can have a separate dataset, for lookup purposes.
Then the main dataset can be based on the selected report parameters.
Finally, I would use either a view or a stored procedure to return the needed dataset.
Using the view/sp provides a lot of flexibility that direct table queries do not, including the ability to join, summarize, and otherwise process values from multiple tables.

I hope that helps.

|||

Your solution may very well work, but I have never done it that way so I am a bit at a loss.....

Unfortunately, unless there is something I am missing, I can't use a view or stored procedure to derive this information....here is an example of what I am wanting to do

Vendor = ABC, Year = 2006, Month = 07, Type = Qty On Hand > 0

Table A

[Column AA] [Column AB] [Column AC]

Item1 Whs1 QtyOnHand1

Item2 Whs1 QtyOnHand2

Item3 Whs2 QtyOnHand3

Item4 Whs1 QtyOnHand0

Table B

[Columnb BA] [ColumnBB] [Column BC] [ColumnBD]

Item1 Whs1 06/01/06 QtySold1

Item1 Whs1 07/01/06 QtySold2

Item2 Whs1 05/01/06 QtySold3

Item3 Whs2 06/01/06 QtySold4

Item4 Whs1 07/01/06 QtySold5

So when I do

SELECT * FROM [TableA] LEFT OUTER JOIN [TableB] ON [TableA].[Column AA] = [TableB].[Column BA] AND [TableA].[Column AB] = [TableB].[Column BB] WHERE [TableA].[QtyOnHand] > 0

I am going to get a result set of

Item1 Whs1 QtyOnHand1 Item1 Whs1 06/01/06 QtySold1

Item1 Whs1 QtyOnHand1 Item1 Whs1 07/01/06 QtySold1

Item2 Whs1 QtyOnHand2 Item2 Whs1 05/01/06 QtySold3

Item3 Whs2 QtyOnHand3 Item3 Whs2 06/01/06 QtySold4

This is essentially what my View Does that I am selecting from....

Now in my report I have them select year and month......to filter what transactions are going to be summed.

My problem is that I still need to show the qtyOnhand and such even though there my be no transactions for the time period they select....so using the parameters above. This is what I get then after that I'll show what I want...

This is what I get:

Item1 Whs1 QtyOnHand1 Item1 Whs1 07/01/06 SUM(QtySold1)

This is what I want:

Item1 Whs1 QtyOnHand1 Item1 Whs1 06/01/06 0

Item1 Whs1 QtyOnHand1 Item1 Whs1 07/01/06 SUM(QtySold1)

Item2 Whs1 QtyOnHand2 Item2 Whs1 05/01/06 0

Item3 Whs2 QtyOnHand3 Item3 Whs2 06/01/06 0

I hope this clarifies things a bit....

Thank you,

Josh

|||

It seems like it's possibly to query what you need and get it in 1 dataset, then maybe doing some filtering or special exclusions, but first,

can you please give your relevant tables and their column names? I know you were trying to be discrete, but COLUMNAA, COLUMNAB is hard to put into motion. After that, I'm sure someone can get you a query that will do the job (full outer join might be necessary).

Multiple Databases accessed by Multiple reports by Multiple users...?

Hello All,
I am somewhat new to MS Reporting Services and I've got a situation
where I have different users needing to access the same report (rdl)
but from different databases?
Ideally I would want to have each report pointing to all databases
dynamically.
Do you know how I would go about setting this up? Multiple reports
pointing to different datasources? Passing a parameter which
determines a specific datasource? - Is it even possible to pass a
parameter to the report to determine which data source to use?
Thanks for your help in advance
MagAre you using RS 2000 or RS 2005? In RS 2005 you can use data source
expressions (search books online under expressions, data sources). If RS
2000 it is much harder and a total pain and I strongly suggest going to RS
2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mag" <mestafanos@.gmail.com> wrote in message
news:1137700476.286569.181810@.g14g2000cwa.googlegroups.com...
> Hello All,
> I am somewhat new to MS Reporting Services and I've got a situation
> where I have different users needing to access the same report (rdl)
> but from different databases?
> Ideally I would want to have each report pointing to all databases
> dynamically.
> Do you know how I would go about setting this up? Multiple reports
> pointing to different datasources? Passing a parameter which
> determines a specific datasource? - Is it even possible to pass a
> parameter to the report to determine which data source to use?
> Thanks for your help in advance
> Mag
>

Multiple columns partitioning in SQL 2008

Will partitioning on multiple columns be supported in SQL 2008, without needing to use the computed column option?

Thanks for any help

Moved to SQL 2008 (Katmai) forums.

|||

Bassel Banbouk wrote:

Will partitioning on multiple columns be supported in SQL 2008, without needing to use the computed column option?

Thanks for any help

No. This is not planned for SQL Server 2008.