Report Designer Install

I am trying to add report designer to a new development machine (XP
professional sp2) that has VS 2003 installed. The machine does not have IIS
installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL &
Reporting Services. I keep getting the dialog box indicating a missing IIS
and ASP.net then an abend. I used to get a dialog box where I could select
the client options, but the install stops before presenting the options.
Anyone else encountering this condition?
TIA - RonWhat is happening is that you are trying to install everything, not just the
designer. RS requires IIS to be installed. The designer does not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>I am trying to add report designer to a new development machine (XP
>professional sp2) that has VS 2003 installed. The machine does not have
>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL &
>Reporting Services. I keep getting the dialog box indicating a missing IIS
>and ASP.net then an abend. I used to get a dialog box where I could select
>the client options, but the install stops before presenting the options.
>Anyone else encountering this condition?
> TIA - Ron
>|||Thanks for the reply.
But where do I designate to just install the designer? It stops before
there is any "selection" screen.
TIA -- Ron
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
> What is happening is that you are trying to install everything, not just
> the designer. RS requires IIS to be installed. The designer does not.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not have
>>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL
>>& Reporting Services. I keep getting the dialog box indicating a missing
>>IIS and ASP.net then an abend. I used to get a dialog box where I could
>>select the client options, but the install stops before presenting the
>>options. Anyone else encountering this condition?
>> TIA - Ron
>|||When setup runs it first checks your machine. I just tried this and it tells
me I don't have IIS, asp.net etc (which I don't on my development machine a
XP Pro SP2). However you can keep clicking next. There is one place where it
takes awhile for the next button to appear. After that I was told I already
have it installed so I could not get to the screen you would want. If setup
is crashing after you leave the spot where it tells you that you are missing
IIS and asp.net then I don't know what to tell you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
news:OSPQqykqFHA.3160@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply.
> But where do I designate to just install the designer? It stops before
> there is any "selection" screen.
> TIA -- Ron
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
>> What is happening is that you are trying to install everything, not just
>> the designer. RS requires IIS to be installed. The designer does not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not have
>>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL
>>& Reporting Services. I keep getting the dialog box indicating a missing
>>IIS and ASP.net then an abend. I used to get a dialog box where I could
>>select the client options, but the install stops before presenting the
>>options. Anyone else encountering this condition?
>> TIA - Ron
>>
>|||Thanks for the help.
Yes, those are the messages I get, and when I press next I only get a
sccreen where cancel is the only option. I just don't get the "selection"
screen.
Thanks for looking. Ron
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23jI9Y4kqFHA.3540@.TK2MSFTNGP14.phx.gbl...
> When setup runs it first checks your machine. I just tried this and it
> tells me I don't have IIS, asp.net etc (which I don't on my development
> machine a XP Pro SP2). However you can keep clicking next. There is one
> place where it takes awhile for the next button to appear. After that I
> was told I already have it installed so I could not get to the screen you
> would want. If setup is crashing after you leave the spot where it tells
> you that you are missing IIS and asp.net then I don't know what to tell
> you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
> news:OSPQqykqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> But where do I designate to just install the designer? It stops before
>> there is any "selection" screen.
>> TIA -- Ron
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
>> What is happening is that you are trying to install everything, not just
>> the designer. RS requires IIS to be installed. The designer does not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not have
>>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has
>>SQL & Reporting Services. I keep getting the dialog box indicating a
>>missing IIS and ASP.net then an abend. I used to get a dialog box where
>>I could select the client options, but the install stops before
>>presenting the options. Anyone else encountering this condition?
>> TIA - Ron
>>
>>
>|||How long did you wait? This screen takes (for whatever reason) a long time
for the next button to show up. Did you wait a few minutes. I know I waited
at least a minute. It is doing something in the background and eventually
the next button shows up.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
news:uajGVKmqFHA.3016@.TK2MSFTNGP12.phx.gbl...
> Thanks for the help.
> Yes, those are the messages I get, and when I press next I only get a
> sccreen where cancel is the only option. I just don't get the "selection"
> screen.
> Thanks for looking. Ron
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23jI9Y4kqFHA.3540@.TK2MSFTNGP14.phx.gbl...
>> When setup runs it first checks your machine. I just tried this and it
>> tells me I don't have IIS, asp.net etc (which I don't on my development
>> machine a XP Pro SP2). However you can keep clicking next. There is one
>> place where it takes awhile for the next button to appear. After that I
>> was told I already have it installed so I could not get to the screen you
>> would want. If setup is crashing after you leave the spot where it tells
>> you that you are missing IIS and asp.net then I don't know what to tell
>> you.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:OSPQqykqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> But where do I designate to just install the designer? It stops before
>> there is any "selection" screen.
>> TIA -- Ron
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
>> What is happening is that you are trying to install everything, not
>> just the designer. RS requires IIS to be installed. The designer does
>> not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not
>>have IIS installed. I am using the MSDN August 2005 DVD 2432.10 that
>>has SQL & Reporting Services. I keep getting the dialog box indicating
>>a missing IIS and ASP.net then an abend. I used to get a dialog box
>>where I could select the client options, but the install stops before
>>presenting the options. Anyone else encountering this condition?
>> TIA - Ron
>>
>>
>>
>

Report Builder - Filter Dropdown Order Post 2005 SP2 Incorrect

Hi All,

Hope someone can help here. Since installing Service Pack 2 onto our SQL 2005 instances our report models are not working correctly. When selecting fields within the models as filters, and getting them to prompt when the report is run, the ordering of the data within the filters does not match the selected ordering in the model definition. The ordering is random each time the report is run.

This issue does not happen when setting the filter up, the data appears in the correct order, but when running the report the filter data is incorrect.

I have spent the last 4 hours building a new system and testing this with each stage of service packing. The RTM version of SQL 2005 is ok, SP1 is also OK, but when SP2 is applied the ordering fails.

Any ideas?

Many thanks in advance.

Regards

Nick

An update to this issue just in case it may help others.

I logged a call with Microsoft relating to this issue and the product support specialist managed to reproduce the issue at their end. It was passed up to the product teams and the reponse has come back that it is now designed this way even though it worked prior to SP2.

The specific issue is:- Dropdown parameter boxes on reports created using report builder do not adhere to the ordering specified in the report model at runtime, although they do at design time.

As we were adding parameter boxes allowing users to select from almost 1000 branch codes the fact that it isn't ordered and appears in a random order is obviously an issue that has meant we can no longer use report builder.

The workaround suggested by Microsoft is to index the underlying tables so that the table scans of the branch codes scan indexes instead and return ordered lists, as the index is already ordered. Unfortunately I cannot do this as my tables are indexed for performance, and I can't change them to fix an issue that shouldn't (in my personal opinion) be there in the first place.

Hope this helps anyone else in the same situation.

Nick