Showing posts with label reporting. Show all posts

Sunday, March 25, 2012

a couple reporting/ normalization questions

I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
used only for reporting, no OLTP. The queries are quite slow to say the
least. Every day this data is truncated and repopulated from a mainframe.
From what I can tell there are a few options here.
1; Normalize it. The problem here is there are 150+ Stored Procs dependant
on the existing structure, and of course nobody has time to re-write them.
Theres probably software that can do this for us, (?) but if so, does it
really work well? Also, the DTS Package that populates this DB every day
would need total overhauling.
2; Forget this pile of crap. Let it stay how it is for existing stuff. But
have new stuff go into Analysis Services, and then use Reporting Services.
Everyone here want to use AS and RS anyways, so thats the way we are
leaning. The problem is I have little experience with either of these tools.
Im open to the challenge and we move fairly slow anyways, so I think it can
work. Now my questions.
1; Can Reporting Services connect/report from Analysis Services?
2, Can AS be populated from a totally de-normalized DB? Can I design the
cubes how they should be, and take the data from several different tables to
populate them?
3; If #2 isnt hopefull, would I be better off to create a new, well designed
db, populate that, and from there populate AS?
All insights are appreciated.
TIA,
ChrisR
to answer number2
You should use DTS to do this
Create the structure that you think will work for you amd then you can
create your cubes (fact and dimension tables) however you want
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR
|||Chris,
1. Yes you can use AS as a source of data to RS.
2 & 3. Depends on how the data is structured. A normalized structure to a
denormalized (star or snowflake) structure would be prefered.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:BE095EAD-5738-43EC-A2EC-1BF20E837BEF@.microsoft.com...
>I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these
> tools.
> Im open to the challenge and we move fairly slow anyways, so I think it
> can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
> to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well
> designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR
|||Do both of you mean that I can, or cannot, populate well designed cubes from
my poorly designed tables? I think you are both saying I can, but want to
clarify.
Thanks, ChrisR
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR
|||Chris,
It's kinda like asking can I get 'there' from 'here' without being able to
accurately qualify where 'here' is. AS cubes are built off of denormalized
structures (star and snowflake). I'm "somewhat" sure with views and DTS you
can populate the structure tables for the AS cubes or possibly the AS cubes
themselves. Would it be easier if you were working with a normalized design
to start with? Would there be less coding and less possiblity for error?
I'd say yes to both.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:1C1291EB-FAD5-41E1-8655-5E3BC7B7B695@.microsoft.com...[vbcol=seagreen]
> Do both of you mean that I can, or cannot, populate well designed cubes
> from
> my poorly designed tables? I think you are both saying I can, but want to
> clarify.
> Thanks, ChrisR
>
> "ChrisR" wrote:
sql

a couple reporting/ normalization questions

I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
used only for reporting, no OLTP. The queries are quite slow to say the
least. Every day this data is truncated and repopulated from a mainframe.
From what I can tell there are a few options here.
1; Normalize it. The problem here is there are 150+ Stored Procs dependant
on the existing structure, and of course nobody has time to re-write them.
Theres probably software that can do this for us, (?) but if so, does it
really work well? Also, the DTS Package that populates this DB every day
would need total overhauling.
2; Forget this pile of crap. Let it stay how it is for existing stuff. But
have new stuff go into Analysis Services, and then use Reporting Services.
Everyone here want to use AS and RS anyways, so thats the way we are
leaning. The problem is I have little experience with either of these tools.
Im open to the challenge and we move fairly slow anyways, so I think it can
work. Now my questions.
1; Can Reporting Services connect/report from Analysis Services?
2, Can AS be populated from a totally de-normalized DB? Can I design the
cubes how they should be, and take the data from several different tables to
populate them?
3; If #2 isnt hopefull, would I be better off to create a new, well designed
db, populate that, and from there populate AS?
All insights are appreciated.
--
TIA,
ChrisRto answer number2
You should use DTS to do this
Create the structure that you think will work for you amd then you can
create your cubes (fact and dimension tables) however you want
http://sqlservercode.blogspot.com/
"ChrisR" wrote:
> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
1. Yes you can use AS as a source of data to RS.
2 & 3. Depends on how the data is structured. A normalized structure to a
denormalized (star or snowflake) structure would be prefered.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:BE095EAD-5738-43EC-A2EC-1BF20E837BEF@.microsoft.com...
>I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these
> tools.
> Im open to the challenge and we move fairly slow anyways, so I think it
> can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
> to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well
> designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Do both of you mean that I can, or cannot, populate well designed cubes from
my poorly designed tables? I think you are both saying I can, but want to
clarify.
Thanks, ChrisR
"ChrisR" wrote:
> I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tools.
> Im open to the challenge and we move fairly slow anyways, so I think it can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
It's kinda like asking can I get 'there' from 'here' without being able to
accurately qualify where 'here' is. AS cubes are built off of denormalized
structures (star and snowflake). I'm "somewhat" sure with views and DTS you
can populate the structure tables for the AS cubes or possibly the AS cubes
themselves. Would it be easier if you were working with a normalized design
to start with? Would there be less coding and less possiblity for error?
I'd say yes to both.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:1C1291EB-FAD5-41E1-8655-5E3BC7B7B695@.microsoft.com...
> Do both of you mean that I can, or cannot, populate well designed cubes
> from
> my poorly designed tables? I think you are both saying I can, but want to
> clarify.
> Thanks, ChrisR
>
> "ChrisR" wrote:
>> I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>> is
>> used only for reporting, no OLTP. The queries are quite slow to say the
>> least. Every day this data is truncated and repopulated from a mainframe.
>> From what I can tell there are a few options here.
>> 1; Normalize it. The problem here is there are 150+ Stored Procs
>> dependant
>> on the existing structure, and of course nobody has time to re-write
>> them.
>> Theres probably software that can do this for us, (?) but if so, does it
>> really work well? Also, the DTS Package that populates this DB every day
>> would need total overhauling.
>> 2; Forget this pile of crap. Let it stay how it is for existing stuff.
>> But
>> have new stuff go into Analysis Services, and then use Reporting
>> Services.
>> Everyone here want to use AS and RS anyways, so thats the way we are
>> leaning. The problem is I have little experience with either of these
>> tools.
>> Im open to the challenge and we move fairly slow anyways, so I think it
>> can
>> work. Now my questions.
>> 1; Can Reporting Services connect/report from Analysis Services?
>> 2, Can AS be populated from a totally de-normalized DB? Can I design the
>> cubes how they should be, and take the data from several different tables
>> to
>> populate them?
>> 3; If #2 isnt hopefull, would I be better off to create a new, well
>> designed
>> db, populate that, and from there populate AS?
>> All insights are appreciated.
>> --
>> TIA,
>> ChrisR

a couple reporting/ normalization questions

I have one DB in specific that fails to even be in 1NF, much less 3rd. It is
used only for reporting, no OLTP. The queries are quite slow to say the
least. Every day this data is truncated and repopulated from a mainframe.
From what I can tell there are a few options here.
1; Normalize it. The problem here is there are 150+ Stored Procs dependant
on the existing structure, and of course nobody has time to re-write them.
Theres probably software that can do this for us, (?) but if so, does it
really work well? Also, the DTS Package that populates this DB every day
would need total overhauling.
2; Forget this pile of crap. Let it stay how it is for existing stuff. But
have new stuff go into Analysis Services, and then use Reporting Services.
Everyone here want to use AS and RS anyways, so thats the way we are
leaning. The problem is I have little experience with either of these tools.
Im open to the challenge and we move fairly slow anyways, so I think it can
work. Now my questions.
1; Can Reporting Services connect/report from Analysis Services?
2, Can AS be populated from a totally de-normalized DB? Can I design the
cubes how they should be, and take the data from several different tables to
populate them?
3; If #2 isnt hopefull, would I be better off to create a new, well designed
db, populate that, and from there populate AS?
All insights are appreciated.
TIA,
ChrisRto answer number2
You should use DTS to do this
Create the structure that you think will work for you amd then you can
create your cubes (fact and dimension tables) however you want
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It
is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tool
s.
> Im open to the challenge and we move fairly slow anyways, so I think it ca
n
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well design
ed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
1. Yes you can use AS as a source of data to RS.
2 & 3. Depends on how the data is structured. A normalized structure to a
denormalized (star or snowflake) structure would be prefered.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:BE095EAD-5738-43EC-A2EC-1BF20E837BEF@.microsoft.com...
>I have one DB in specific that fails to even be in 1NF, much less 3rd. It
>is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these
> tools.
> Im open to the challenge and we move fairly slow anyways, so I think it
> can
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
> to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well
> designed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Do both of you mean that I can, or cannot, populate well designed cubes from
my poorly designed tables? I think you are both saying I can, but want to
clarify.
Thanks, ChrisR
"ChrisR" wrote:

> I have one DB in specific that fails to even be in 1NF, much less 3rd. It
is
> used only for reporting, no OLTP. The queries are quite slow to say the
> least. Every day this data is truncated and repopulated from a mainframe.
> From what I can tell there are a few options here.
> 1; Normalize it. The problem here is there are 150+ Stored Procs dependant
> on the existing structure, and of course nobody has time to re-write them.
> Theres probably software that can do this for us, (?) but if so, does it
> really work well? Also, the DTS Package that populates this DB every day
> would need total overhauling.
> 2; Forget this pile of crap. Let it stay how it is for existing stuff. But
> have new stuff go into Analysis Services, and then use Reporting Services.
> Everyone here want to use AS and RS anyways, so thats the way we are
> leaning. The problem is I have little experience with either of these tool
s.
> Im open to the challenge and we move fairly slow anyways, so I think it ca
n
> work. Now my questions.
> 1; Can Reporting Services connect/report from Analysis Services?
> 2, Can AS be populated from a totally de-normalized DB? Can I design the
> cubes how they should be, and take the data from several different tables
to
> populate them?
> 3; If #2 isnt hopefull, would I be better off to create a new, well design
ed
> db, populate that, and from there populate AS?
> All insights are appreciated.
> --
> TIA,
> ChrisR|||Chris,
It's kinda like asking can I get 'there' from 'here' without being able to
accurately qualify where 'here' is. AS cubes are built off of denormalized
structures (star and snowflake). I'm "somewhat" sure with views and DTS you
can populate the structure tables for the AS cubes or possibly the AS cubes
themselves. Would it be easier if you were working with a normalized design
to start with? Would there be less coding and less possiblity for error?
I'd say yes to both.
HTH
Jerry
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:1C1291EB-FAD5-41E1-8655-5E3BC7B7B695@.microsoft.com...[vbcol=seagreen]
> Do both of you mean that I can, or cannot, populate well designed cubes
> from
> my poorly designed tables? I think you are both saying I can, but want to
> clarify.
> Thanks, ChrisR
>
> "ChrisR" wrote:
>

A couple of beginner's questions about reporting services

I'm writing my first RS report.
1. Is there any way to program a field to clear, or even hide, under certain
conditions?
2. Is there any way to simulate a check box, to display boolean values? (I
don't see anything in the toolbox.)On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
wrote:
> I'm writing my first RS report.
> 1. Is there any way to program a field to clear, or even hide, under certain
> conditions?
> 2. Is there any way to simulate a check box, to display boolean values? (I
> don't see anything in the toolbox.)
1. Yes. Many of the controls on SSRS are expression based. In your
scenario, expressions can be used to manipulate the Hidden property of
a textbox based on other data, constants, etc.
2. Assuming you're talking about the body of the report. I have used
images in the past to simulate an X or a checkmark.|||I don't think I really understand what you mean by expressions yet. Are you
talking about writing what appears to be a vb command in the format field?
If so, I haven't been able to get that to work yet. What I'd like to do is
something like this:
iif(instr(Fields!SomeValue.Value, "A String") > 0,"",Fields!SomeValue.Value)
In other words, if the value of the incoming string does contain a
particular pattern, blank the box, otherwise display it. Or have I
completely misunderstood the concept?
"Potter" wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> >
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> >
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
>
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
>|||On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> wrote:
> > I'm writing my first RS report.
> > 1. Is there any way to program a field to clear, or even hide, under certain
> > conditions?
> > 2. Is there any way to simulate a check box, to display boolean values? (I
> > don't see anything in the toolbox.)
> 1. Yes. Many of the controls on SSRS are expression based. In your
> scenario, expressions can be used to manipulate the Hidden property of
> a textbox based on other data, constants, etc.
> 2. Assuming you're talking about the body of the report. I have used
> images in the past to simulate an X or a checkmark.
hi there
In the properties box - there is a visibility property - you can use
this and toggle it depending on other fields.
hope that helps
jewel|||Actually no, I need a way to program the visibility based on content.
Clicking on a field won't do.
"jewelfire" wrote:
> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> > wrote:
> >
> > > I'm writing my first RS report.
> >
> > > 1. Is there any way to program a field to clear, or even hide, under certain
> > > conditions?
> >
> > > 2. Is there any way to simulate a check box, to display boolean values? (I
> > > don't see anything in the toolbox.)
> >
> > 1. Yes. Many of the controls on SSRS are expression based. In your
> > scenario, expressions can be used to manipulate the Hidden property of
> > a textbox based on other data, constants, etc.
> > 2. Assuming you're talking about the body of the report. I have used
> > images in the past to simulate an X or a checkmark.
> hi there
> In the properties box - there is a visibility property - you can use
> this and toggle it depending on other fields.
> hope that helps
> jewel
>|||In the visibility property, hidden can be set to true, false or expression.
Pick expression and put the appropriate expression there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> Actually no, I need a way to program the visibility based on content.
> Clicking on a field won't do.
> "jewelfire" wrote:
>> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> > wrote:
>> >
>> > > I'm writing my first RS report.
>> >
>> > > 1. Is there any way to program a field to clear, or even hide, under
>> > > certain
>> > > conditions?
>> >
>> > > 2. Is there any way to simulate a check box, to display boolean
>> > > values? (I
>> > > don't see anything in the toolbox.)
>> >
>> > 1. Yes. Many of the controls on SSRS are expression based. In your
>> > scenario, expressions can be used to manipulate the Hidden property of
>> > a textbox based on other data, constants, etc.
>> > 2. Assuming you're talking about the body of the report. I have used
>> > images in the past to simulate an X or a checkmark.
>> hi there
>> In the properties box - there is a visibility property - you can use
>> this and toggle it depending on other fields.
>> hope that helps
>> jewel
>>|||Missed that! That's what I was looking for.
Just to play safe, here is my code.
=IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
I'm assuming that 'Me' in this context, refers to the current text field.
As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
blank date. (No nulls, period. Company rules.)
"Bruce L-C [MVP]" wrote:
> In the visibility property, hidden can be set to true, false or expression.
> Pick expression and put the appropriate expression there.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
> > Actually no, I need a way to program the visibility based on content.
> > Clicking on a field won't do.
> >
> > "jewelfire" wrote:
> >
> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
> >> > wrote:
> >> >
> >> > > I'm writing my first RS report.
> >> >
> >> > > 1. Is there any way to program a field to clear, or even hide, under
> >> > > certain
> >> > > conditions?
> >> >
> >> > > 2. Is there any way to simulate a check box, to display boolean
> >> > > values? (I
> >> > > don't see anything in the toolbox.)
> >> >
> >> > 1. Yes. Many of the controls on SSRS are expression based. In your
> >> > scenario, expressions can be used to manipulate the Hidden property of
> >> > a textbox based on other data, constants, etc.
> >> > 2. Assuming you're talking about the body of the report. I have used
> >> > images in the past to simulate an X or a checkmark.
> >>
> >> hi there
> >>
> >> In the properties box - there is a visibility property - you can use
> >> this and toggle it depending on other fields.
> >>
> >> hope that helps
> >> jewel
> >>
> >>
>
>|||I haven't used Me in RS (I've used it in VB). It is easy to test. Most
errors are picked up when you try to preview it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:52FB048B-27B0-436A-A269-8B1CC83E12AA@.microsoft.com...
> Missed that! That's what I was looking for.
> Just to play safe, here is my code.
> =IIf (InStr(me.Value,"1/1/1753") > 0, True ,False)
> I'm assuming that 'Me' in this context, refers to the current text field.
> As I mentioned elsewhere, this is legacy code with '1/1/1753' indicating a
> blank date. (No nulls, period. Company rules.)
> "Bruce L-C [MVP]" wrote:
>> In the visibility property, hidden can be set to true, false or
>> expression.
>> Pick expression and put the appropriate expression there.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:6211D77E-5C9B-4206-B823-CE6273331547@.microsoft.com...
>> > Actually no, I need a way to program the visibility based on content.
>> > Clicking on a field won't do.
>> >
>> > "jewelfire" wrote:
>> >
>> >> On May 10, 11:38 am, Potter <drewpot...@.gmail.com> wrote:
>> >> > On May 9, 4:13 pm, B. Chernick <BChern...@.discussions.microsoft.com>
>> >> > wrote:
>> >> >
>> >> > > I'm writing my first RS report.
>> >> >
>> >> > > 1. Is there any way to program a field to clear, or even hide,
>> >> > > under
>> >> > > certain
>> >> > > conditions?
>> >> >
>> >> > > 2. Is there any way to simulate a check box, to display boolean
>> >> > > values? (I
>> >> > > don't see anything in the toolbox.)
>> >> >
>> >> > 1. Yes. Many of the controls on SSRS are expression based. In
>> >> > your
>> >> > scenario, expressions can be used to manipulate the Hidden property
>> >> > of
>> >> > a textbox based on other data, constants, etc.
>> >> > 2. Assuming you're talking about the body of the report. I have
>> >> > used
>> >> > images in the past to simulate an X or a checkmark.
>> >>
>> >> hi there
>> >>
>> >> In the properties box - there is a visibility property - you can use
>> >> this and toggle it depending on other fields.
>> >>
>> >> hope that helps
>> >> jewel
>> >>
>> >>
>>|||You can also hide the field using an expression like this (instead of an iif statement):
Click your field, go to your properties box and scroll down to Visibility. Under that you have a hidden option--select Expression.
In the expression paste in a TRUE statement for what you want hidden
=Fields!Dates.Value= "1753"
That will hide the field just under certain conditions.
Hope that also gives you some flexibility
From http://www.developmentnow.com/g/115_2007_5_0_0_968676/A-couple-of-beginners-questions-about-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

A connection could not be made with report server ...

I just installed SQL Server 2005 (Reporting Services) on my collegues laptop
(Windows XP, SP2) and when we try to deploy the reports we get the message:
"A connection could not be made with report server at
http://localhost/ReportServer"
Everything is running (green checks) in the Reporting Services configuration
manager. We get the error, "Page not found." when we just try to open
http://<machinename>/Reports or http://localhost/Reports. I see the virtual
directories in IIS, all services seem to be running correctly.
Please help! I have installed reporting services about 10 times and have
not run into this problem before. The only issue that we had initially was
that the IIS default web site would not run because there was a conflict on
TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
problem should it.
Thank you,
Laurie
--
LaurieTWhat happens when you try going to http://localhost/?
Have you tried http://localhost:81/Reports, since that's what you changed
the port to?
Clint
"LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
>I just installed SQL Server 2005 (Reporting Services) on my collegues
>laptop
> (Windows XP, SP2) and when we try to deploy the reports we get the
> message:
> "A connection could not be made with report server at
> http://localhost/ReportServer"
> Everything is running (green checks) in the Reporting Services
> configuration
> manager. We get the error, "Page not found." when we just try to open
> http://<machinename>/Reports or http://localhost/Reports. I see the
> virtual
> directories in IIS, all services seem to be running correctly.
> Please help! I have installed reporting services about 10 times and have
> not run into this problem before. The only issue that we had initially
> was
> that the IIS default web site would not run because there was a conflict
> on
> TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> problem should it.
> Thank you,
> Laurie
> --
> LaurieT|||Clint -- Thanks, I tried this and still got some errors (although different
than I was seeing before).
I got this error when trying http://localhost:81/Reports
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
----
A name was started with an invalid character. Error processing resource
'http://localhost:81/Reports'. Line 1, Position 2
<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag..."
Any ideas?
Thank you.
--
LaurieT
"Clint" wrote:
> What happens when you try going to http://localhost/?
> Have you tried http://localhost:81/Reports, since that's what you changed
> the port to?
> Clint
> "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> >I just installed SQL Server 2005 (Reporting Services) on my collegues
> >laptop
> > (Windows XP, SP2) and when we try to deploy the reports we get the
> > message:
> > "A connection could not be made with report server at
> > http://localhost/ReportServer"
> >
> > Everything is running (green checks) in the Reporting Services
> > configuration
> > manager. We get the error, "Page not found." when we just try to open
> > http://<machinename>/Reports or http://localhost/Reports. I see the
> > virtual
> > directories in IIS, all services seem to be running correctly.
> >
> > Please help! I have installed reporting services about 10 times and have
> > not run into this problem before. The only issue that we had initially
> > was
> > that the IIS default web site would not run because there was a conflict
> > on
> > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > problem should it.
> >
> > Thank you,
> > Laurie
> > --
> > LaurieT
>
>|||Sorry, I got nothing else. :) I'm pretty much an RS newbie. Hopefully
someone else can chime in for you.
Clint
"LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
news:71DB89B9-F5F4-445E-A480-95A635B73ECB@.microsoft.com...
> Clint -- Thanks, I tried this and still got some errors (although
> different
> than I was seeing before).
> I got this error when trying http://localhost:81/Reports
> "The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://localhost:81/Reports'. Line 1, Position 2
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag..."
> Any ideas?
> Thank you.
> --
> LaurieT
>
> "Clint" wrote:
>> What happens when you try going to http://localhost/?
>> Have you tried http://localhost:81/Reports, since that's what you changed
>> the port to?
>> Clint
>> "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
>> news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
>> >I just installed SQL Server 2005 (Reporting Services) on my collegues
>> >laptop
>> > (Windows XP, SP2) and when we try to deploy the reports we get the
>> > message:
>> > "A connection could not be made with report server at
>> > http://localhost/ReportServer"
>> >
>> > Everything is running (green checks) in the Reporting Services
>> > configuration
>> > manager. We get the error, "Page not found." when we just try to open
>> > http://<machinename>/Reports or http://localhost/Reports. I see the
>> > virtual
>> > directories in IIS, all services seem to be running correctly.
>> >
>> > Please help! I have installed reporting services about 10 times and
>> > have
>> > not run into this problem before. The only issue that we had initially
>> > was
>> > that the IIS default web site would not run because there was a
>> > conflict
>> > on
>> > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't
>> > be a
>> > problem should it.
>> >
>> > Thank you,
>> > Laurie
>> > --
>> > LaurieT
>>|||laurie,
I had the same problem and Now it has been fixed.i looked online and
here is what i found:
1)The FIX
For IIS MMC: Right click My Computer...then click manage...under
services and applications....expand IIS
then right click the "reports" virtual directory, select property and
then under the
ASP.NET tab select asp.net version that belongs to the .NET framework
version 2.something. For some reason, after you installed reporting
services,
the version of the ASP.NET was removed from the asp.net tab. click ok
2)New Problem
Then you get this new problem when you go to http://localhost/Reports/
--my comment Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException:
Failed to access IIS metabase.
The process account used to run ASP.NET must have read access to the
IIS metabase (e.g. IIS://servername/W3SVC). For information on
modifying metabase permissions, please see
http://support.microsoft.com/?kbid=267904 .
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[HostingEnvironmentException: Failed to access IIS metabase.]
System.Web.Hosting.HostingEnvironment.MapPathCaching(String path)
+3609369 System.Web.CachedPathData.GetPathData(String path) +406
System.Web.Configuration.RuntimeConfigLKG.GetInternalSection
(String sectionName, Type type, ResultsIndex index) +134
2) The FIX
To correct the problem To repair IIS mappings for ASP.NET, run the
Aspnet_regiis.exe utlity. To do so, follow these steps:
Click Start, and then click Run.
Type cmd, and then click OK.
At the command prompt, type the following command, and then press
ENTER:
"\<Windows folder>\Microsoft.NET\Framework\<Version
Number>\aspnet_regiis.exe" -i
NOTE:Replace <Windows folder> with the name of the directory where the
operating system is installed and replace <Version Number> with the
.NET Framework version installed on your computer. Or you could do a
seach for the .exe file and locate the directory
You can find the above reference at
http://support.microsoft.com/default.aspx?scid=kb;en-us;325093
Now try going to http://computername/reports/
Hope it helps,
Sharan Doddakashi
LaurieT wrote:
> Clint -- Thanks, I tried this and still got some errors (although different
> than I was seeing before).
> I got this error when trying http://localhost:81/Reports
> "The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://localhost:81/Reports'. Line 1, Position 2
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag..."
> Any ideas?
> Thank you.
> --
> LaurieT
>
> "Clint" wrote:
> > What happens when you try going to http://localhost/?
> >
> > Have you tried http://localhost:81/Reports, since that's what you changed
> > the port to?
> >
> > Clint
> >
> > "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> > news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> > >I just installed SQL Server 2005 (Reporting Services) on my collegues
> > >laptop
> > > (Windows XP, SP2) and when we try to deploy the reports we get the
> > > message:
> > > "A connection could not be made with report server at
> > > http://localhost/ReportServer"
> > >
> > > Everything is running (green checks) in the Reporting Services
> > > configuration
> > > manager. We get the error, "Page not found." when we just try to open
> > > http://<machinename>/Reports or http://localhost/Reports. I see the
> > > virtual
> > > directories in IIS, all services seem to be running correctly.
> > >
> > > Please help! I have installed reporting services about 10 times and have
> > > not run into this problem before. The only issue that we had initially
> > > was
> > > that the IIS default web site would not run because there was a conflict
> > > on
> > > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > > problem should it.
> > >
> > > Thank you,
> > > Laurie
> > > --
> > > LaurieT
> >
> >
> >|||Sharan,
Thanks for the valuable solution. That was very helpful, precisely to
the point and it solved the issue.
Good Work!
Shailesh
HELP wrote:
> laurie,
> I had the same problem and Now it has been fixed.i looked online and
> here is what i found:
> 1)The FIX
> For IIS MMC: Right click My Computer...then click manage...under
> services and applications....expand IIS
> then right click the "reports" virtual directory, select property and
> then under the
> ASP.NET tab select asp.net version that belongs to the .NET framework
> version 2.something. For some reason, after you installed reporting
> services,
> the version of the ASP.NET was removed from the asp.net tab. click ok
> 2)New Problem
> Then you get this new problem when you go to http://localhost/Reports/
> --my comment Failed to access IIS metabase.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
> Exception Details: System.Web.Hosting.HostingEnvironmentException:
> Failed to access IIS metabase.
> The process account used to run ASP.NET must have read access to the
> IIS metabase (e.g. IIS://servername/W3SVC). For information on
> modifying metabase permissions, please see
> http://support.microsoft.com/?kbid=267904 .
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of
> the exception can be identified using the exception stack trace below.
>
> Stack Trace:
> [HostingEnvironmentException: Failed to access IIS metabase.]
> System.Web.Hosting.HostingEnvironment.MapPathCaching(String path)
> +3609369 System.Web.CachedPathData.GetPathData(String path) +406
> System.Web.Configuration.RuntimeConfigLKG.GetInternalSection
> (String sectionName, Type type, ResultsIndex index) +134
>
> 2) The FIX
> To correct the problem To repair IIS mappings for ASP.NET, run the
> Aspnet_regiis.exe utlity. To do so, follow these steps:
> Click Start, and then click Run.
> Type cmd, and then click OK.
> At the command prompt, type the following command, and then press
> ENTER:
> "\<Windows folder>\Microsoft.NET\Framework\<Version
> Number>\aspnet_regiis.exe" -i
> NOTE:Replace <Windows folder> with the name of the directory where the
> operating system is installed and replace <Version Number> with the
> .NET Framework version installed on your computer. Or you could do a
> seach for the .exe file and locate the directory
> You can find the above reference at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325093
> Now try going to http://computername/reports/
> Hope it helps,
> Sharan Doddakashi
>
> LaurieT wrote:
> > Clint -- Thanks, I tried this and still got some errors (although different
> > than I was seeing before).
> >
> > I got this error when trying http://localhost:81/Reports
> >
> > "The XML page cannot be displayed
> > Cannot view XML input using XSL style sheet. Please correct the error and
> > then click the Refresh button, or try again later.
> >
> >
> > ----
> >
> > A name was started with an invalid character. Error processing resource
> > 'http://localhost:81/Reports'. Line 1, Position 2
> >
> > <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> > Inherits="Microsoft.ReportingServices.UI.HomePag..."
> >
> > Any ideas?
> >
> > Thank you.
> > --
> > LaurieT
> >
> >
> > "Clint" wrote:
> >
> > > What happens when you try going to http://localhost/?
> > >
> > > Have you tried http://localhost:81/Reports, since that's what you changed
> > > the port to?
> > >
> > > Clint
> > >
> > > "LaurieT" <LaurieT@.discussions.microsoft.com> wrote in message
> > > news:75CE650E-D235-4DDC-9408-802E8AE9312A@.microsoft.com...
> > > >I just installed SQL Server 2005 (Reporting Services) on my collegues
> > > >laptop
> > > > (Windows XP, SP2) and when we try to deploy the reports we get the
> > > > message:
> > > > "A connection could not be made with report server at
> > > > http://localhost/ReportServer"
> > > >
> > > > Everything is running (green checks) in the Reporting Services
> > > > configuration
> > > > manager. We get the error, "Page not found." when we just try to open
> > > > http://<machinename>/Reports or http://localhost/Reports. I see the
> > > > virtual
> > > > directories in IIS, all services seem to be running correctly.
> > > >
> > > > Please help! I have installed reporting services about 10 times and have
> > > > not run into this problem before. The only issue that we had initially
> > > > was
> > > > that the IIS default web site would not run because there was a conflict
> > > > on
> > > > TCP Port 80, so I switched that TCP Port to port 81 -- this shouldn't be a
> > > > problem should it.
> > > >
> > > > Thank you,
> > > > Laurie
> > > > --
> > > > LaurieT
> > >
> > >
> > >

A connection could not be made to the reporting server http://localhost/reportserver

Hi all,

When I build a simple project using the report wizard project.

When i deploy the report i get the following error.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>

<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span>

<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

</body>
</html>

--. (Microsoft.ReportingServices.Designer)

BUTTONS:

Could some one come to my rescue.

Thanx in advance.

Ronald

Is Reporting services installed on the machine you are designing on? If not, go to the project properties and change the report server url to the machine where Report Server is installed on.|||

I'm getting the exact same error, but I'm working off of the same machine. To clarify, SQL and MS Visual Studio are on the same machine -- I've created the report and tried to deploy in MSVS.

Note that this machine is part of a network governed by a file & print server.

I can get a valid web page at http://localhost that changes to http://localhost/default.aspx and displays a Home page to a Team Web Site.

But when I try http://lolcalhost/reportsserver, I get the following errors:

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'Microsoft.BusinessFramework' or one of its dependencies. The system cannot find the file specified. (c:\inetpub\wwwroot\web.config line 77)

Source Error:

Line 75: <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" /> Line 76:  Line 77: <add name="EnterpriseInitializationModule" type="Microsoft.BusinessFramework.Security.EnterpriseInitializationModule,Microsoft.BusinessFramework" /> Line 78: <add name="BPAdminRedirectModule" type="Microsoft.BusinessFramework.Portal.Administration.BPAdminRedirectModule,Microsoft.BusinessFramework.Portal" /> Line 79: <add name="BPHomeRedirectModule" type="Microsoft.BusinessFramework.Portal.Shell.BPHomeRedirectModule,Microsoft.BusinessFramework.Portal" />

Source File: c:\inetpub\wwwroot\web.config Line: 77

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Can you help?

A connection could not be made to the reporting server http://localhost/reportserver

Hi all,

When I build a simple project using the report wizard project.

When i deploy the report i get the following error.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

</body>
</html>

--. (Microsoft.ReportingServices.Designer)

BUTTONS:

Could some one come to my rescue.

Thanx in advance.

Ronald

Is Reporting services installed on the machine you are designing on? If not, go to the project properties and change the report server url to the machine where Report Server is installed on.

A connection could not be made to the report server http://localhost/reportServer..

hi,

I got this error when I was trying to deploy the reporting into IIS..

A connection could not be made to the report server http://localhost/reportServer.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

I am not able to solve it please help.

Thanks.

Are you able to browse to http://localhost/reportServer using IE?|||

No,

I am not able to browse to http://localhost/reportServer using IE The page cannot be found is shown I have mentioned the error above that I got when I am trying to deploy the reporting into IIS..

Thanks

|||

Then that means that either your virtual directories have been created with a different name (not the default) or have not been created at all.

Have you run the reporting services confirguration tool?

|||

Raina - I was having the exact same problem and eventually resolved it this way:

I discovered that the Reporting Services Configuration Manager was incorrectly showing green check-marks indicating my Report Server and Report Manager Virtual Directories were set up, when in fact they were not (what tipped me off to this is when I went to Control Panel -> Administrative Tools -> Internet Information Services, there were no Report Server or Reports folder branches under my Default Web Site tree). So in the Reporting Services Configuration Manager, I clicked the New button to create the default Report Server and Report Manager Virtual Directories ((this was the 2nd time I did this, which may have been necessary because I uninstalled and reinstalled IIS after instaling SSRS). This time the IIS manager showed Report Server and Reports folder branches under my Default Web Site tree, and I was able to successfully browse to http://localhost/reportserver, AND deploy my SSRS project to the web server. Note that I am running a named instance of SQL Server 2005 (the default instance is SQL Server 2000), and even though I have seen posts suggesting the correct URL for a named instance would be http://localhost/reportserver$<named_instance>, this did NOT work for me ... http://localhost/reportserver DOES work.

|||

jbrauer wrote:
Note that I am running a named instance of SQL Server 2005 (the default instance is SQL Server 2000), and even though I have seen posts suggesting the correct URL for a named instance would be http://localhost/reportserver$<named_instance>, this did NOT work for me ... http://localhost/reportserver DOES work.

Well I have to disagree. I am also running a named instance, so the URL that works for me is
http://localhost/reportserver$<named_instance

When you create a new report model project its deploy URL by default is http://localhost/reportserver So i had to change that , through project properties, to the named instance one.

Good Luck !!|||Yes jbrauer, this was exactly the solution for me too, thankyou.

A connection could not be made to the report server http://localhost/reportServer..

hi,

I got this error when I was trying to deploy the reporting into IIS..

A connection could not be made to the report server http://localhost/reportServer.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

I am not able to solve it please help.

Thanks.

Are you able to browse to http://localhost/reportServer using IE?|||

No,

Thanks

|||

Then that means that either your virtual directories have been created with a different name (not the default) or have not been created at all.

Have you run the reporting services confirguration tool?

|||

Raina - I was having the exact same problem and eventually resolved it this way:

|||

jbrauer wrote:
Note that I am running a named instance of SQL Server 2005 (the default instance is SQL Server 2000), and even though I have seen posts suggesting the correct URL for a named instance would be http://localhost/reportserver$<named_instance>, this did NOT work for me ... http://localhost/reportserver DOES work.

Well I have to disagree. I am also running a named instance, so the URL that works for me is
http://localhost/reportserver$<named_instance

When you create a new report model project its deploy URL by default is http://localhost/reportserver So i had to change that , through project properties, to the named instance one.

Good Luck !!

A connection could not be made to the report server http://localhost/reportServer..

hi,

I got this error when I was trying to deploy the reporting into IIS..

A connection could not be made to the report server http://localhost/reportServer.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

I am not able to solve it please help.

Thanks.

Are you able to browse to http://localhost/reportServer using IE?|||

No,

Thanks

|||

Then that means that either your virtual directories have been created with a different name (not the default) or have not been created at all.

Have you run the reporting services confirguration tool?

|||

Raina - I was having the exact same problem and eventually resolved it this way:

|||

jbrauer wrote:
Note that I am running a named instance of SQL Server 2005 (the default instance is SQL Server 2000), and even though I have seen posts suggesting the correct URL for a named instance would be http://localhost/reportserver$<named_instance>, this did NOT work for me ... http://localhost/reportserver DOES work.

Well I have to disagree. I am also running a named instance, so the URL that works for me is
http://localhost/reportserver$<named_instance

When you create a new report model project its deploy URL by default is http://localhost/reportserver So i had to change that , through project properties, to the named instance one.

Good Luck !!
|||Yes jbrauer, this was exactly the solution for me too, thankyou. sql

A connection could not be made to the report server http://localhost/Reports.

hi all,
i have been trying to Deploy my report and it keeps giving me this
error.
When i go to IIS and browse on reports the Reporting Services page
comes on fine.
And typing http://localhost/Reports renders the Reporting Services
page too. The problem is when i try to deploy, i keep getting this
error.
Please Help!!
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server http://localhost/Reports.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
--
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--Reports is the portal. ReportServer is reporting services. Try
http://servername/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Deepali" <dchikkam@.gmail.com> wrote in message
news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
> hi all,
> i have been trying to Deploy my report and it keeps giving me this
> error.
> When i go to IIS and browse on reports the Reporting Services page
> comes on fine.
> And typing http://localhost/Reports renders the Reporting Services
> page too. The problem is when i try to deploy, i keep getting this
> error.
> Please Help!!
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://localhost/Reports.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> --
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
>|||On typing http://localhost/ReportServer,
it renders one of the folders that i had created on the portals.
localhost/ReportServer - /
----
Friday, July 27, 2007 2:01 PM <dir> Practice
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
Any help is greatly appreciated.
On Jul 27, 3:50 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Reports is the portal. ReportServer is reporting services. Tryhttp://servername/ReportServer
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Deepali" <dchik...@.gmail.com> wrote in message
> news:1185567589.727407.84420@.z24g2000prh.googlegroups.com...
>
> > hi all,
> > i have been trying to Deploy my report and it keeps giving me this
> > error.
> > When i go to IIS and browse on reports the Reporting Services page
> > comes on fine.
> > And typinghttp://localhost/Reports renders the Reporting Services
> > page too. The problem is when i try to deploy, i keep getting this
> > error.
> > Please Help!!
> > TITLE: Microsoft Report Designer
> > --
> > A connection could not be made to the report server
> >http://localhost/Reports.
> > --
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > --
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> > --
> > BUTTONS:
> > OK
> > -- Hide quoted text -
> - Show quoted text -|||ok figured it out. the TargetServerURL was pointing to http://localhost/Reports
and changed it to
http://localhost/ReportServer and it started working perfectly.
thanks Bruce .

Thursday, March 22, 2012

A connection could not be made to the report server

installed MS SQL 2005 Express Advanced (with Reporting services). I built a
sample report using the wizard. When i click on 'deploy' i get the error as
below. There is an application with virtual name as 'ReportServer' in the
IIS 5.1 . What could be the possible reasons for this error ?
Regards,
Chak.
:-
TITLE: Microsoft Report Designer
--
A connection could not be made to the report server
http://localhost/ReportServer.
--
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
(Microsoft.ReportingServices.Designer)
--
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)
--
BUTTONS:
OK
--I re-installed the Reporting server after checking the 'Apply default
settings' check box. Now the report seems to be deployable.
Regards.
"Chakravarthy" <r_chakravarthy@.hotmail.com> wrote in message
news:OHGSa16uGHA.2224@.TK2MSFTNGP06.phx.gbl...
> installed MS SQL 2005 Express Advanced (with Reporting services). I built
> a sample report using the wizard. When i click on 'deploy' i get the error
> as below. There is an application with virtual name as 'ReportServer' in
> the IIS 5.1 . What could be the possible reasons for this error ?
> Regards,
> Chak.
> :-
>
> TITLE: Microsoft Report Designer
> --
> A connection could not be made to the report server
> http://localhost/ReportServer.
> --
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> (Microsoft.ReportingServices.Designer)
> --
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
> --
> BUTTONS:
> OK
> --
>

Monday, March 19, 2012

9MB of errors in log file each time RS report is run

I have a report that is running extremely slowly. The Reporting
Services log files seem to generate 9MB of errors each time I run the
report. The error is the text below repeated over and over. Can anyone
help?
Thanks,
Burt
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__07_01_2004_11_38_28.log</Path>
<SystemName>SFCMSREPORTS</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
aspnet_wp!processing!1c24!7/1/2004-11:38:28:: a ASSERT: Assertion
failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IndexedExprHost.get_Item(Int32
index)
Microsoft.ReportingServices.ReportProcessing.be.a(e A_0, ObjectType
A_1, String A_2, String A_3)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.a(e
A_0, String A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.c()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.b()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.e()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.h()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.c()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ac.b()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.d()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.g()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.a(a5
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.f()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Boolean&
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.b()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Object
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a(Object
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+bb.a(ParameterInfoCollection
A_0, Boolean A_1, GetReportChunk A_2)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, ax A_4,
DateTime A_5, z& A_6)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot,
DataSourceInfoCollection thisReportDataSources, Boolean
cachingRequested, Warning[]& warnings, ReportSnapshot&
resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session,
JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext
context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32
iWRType)Hi Burt, could you please send report definition?
"Burt" burt_5920@.yahoo.com wrote in message
news:19e5f39f.0407011047.ccfd350@.posting.google.com...
> I have a report that is running extremely slowly. The Reporting
> Services log files seem to generate 9MB of errors each time I run the
> report. The error is the text below repeated over and over. Can anyone
> help?
> Thanks,
> Burt
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServer__07_01_2004_11_38_28.log</Path>
> <SystemName>SFCMSREPORTS</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> aspnet_wp!processing!1c24!7/1/2004-11:38:28:: a ASSERT: Assertion
> failed! Call stack:
>
Microsoft.ReportingServices.ReportProcessing.ExprHostObjectModel.IndexedExpr
Host.get_Item(Int32
> index)
> Microsoft.ReportingServices.ReportProcessing.be.a(e A_0, ObjectType
> A_1, String A_2, String A_3)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.a(e
> A_0, String A_1)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+as.c()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.b()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.e()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.h()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ay.c()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ac.b()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.d()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.g()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.a(a5
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.f()
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Boolean&
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ax.b()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+a2.a(Object
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+s.a(Object
> A_0)
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+bb.a(Parameter
InfoCollection
> A_0, Boolean A_1, GetReportChunk A_2)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, ax A_4,
> DateTime A_5, z& A_6)
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(D
ateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
>
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContex
t
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot,
> DataSourceInfoCollection thisReportDataSources, Boolean
> cachingRequested, Warning[]& warnings, ReportSnapshot&
> resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
>
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog
ItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
>
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
>
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
>
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS
Service
> rs, CatalogItemContext reportContext, ClientRequest session,
> JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection&
> effectiveParameters, String[]& secondaryStreamNames)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(
HttpResponseStreamFactory
> streamFactory)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(
)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(It
emType
> itemType)
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessReques
t(HttpContext
> context)
>
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplicati
on+IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
>
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(
HttpContext
> context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32
> iWRType)

9GB log file generated

Hi
The reporting services is generating large log files of 9GB daily and using
all the virtual memory that all applications on my win2003 server stop
running. Application is running on sql server 2000 and Microsoft Report
Server SP1.
How do I go about trouble-shooting this?
--
Regards PatsyWhich report server log is getting up to 9GB?
Is it the ReportServerTempDB log or ReportServer log? (it better not be the
ReportServer log...)
Or do you mean the actual LOG files in the reportserver directory? (these
are text files)
One thing you can check quickly, make sure the ReportServerTempDB database
is set to simple recovery mode.
=-Chris
"Patsy" <Patsy@.discussions.microsoft.com> wrote in message
news:12B3FCC9-60A3-4F48-B1F0-385B5C2DA7D4@.microsoft.com...
> Hi
> The reporting services is generating large log files of 9GB daily and
> using
> all the virtual memory that all applications on my win2003 server stop
> running. Application is running on sql server 2000 and Microsoft Report
> Server SP1.
> How do I go about trouble-shooting this?
> --
> Regards Patsy|||This is a known issue. You could search this group for -- log hotfix.
One reply from MS said:
Ask product support for the fix associated with KB 885286.
I believe this is fixed in sp2
Patsy wrote:
> Hi
> The reporting services is generating large log files of 9GB daily and using
> all the virtual memory that all applications on my win2003 server stop
> running. Application is running on sql server 2000 and Microsoft Report
> Server SP1.
> How do I go about trouble-shooting this?
> --
> Regards Patsy

8gb of log files - how to i stop ?

Hi,
Reporting services has been running for a couple of months. I noticed today
that I had 8GB of log files. Is there anything I can do to stop so much
being logged ? i don't really need it.
Thanks
ScottThis is a known issue (Bug #: 304241 -
http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
SP2 http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-130...
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"scott" <nospamscott@.yahoo.com> wrote in message
news:uConQxBlFHA.708@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Reporting services has been running for a couple of months. I noticed
> today that I had 8GB of log files. Is there anything I can do to stop so
> much being logged ? i don't really need it.
> Thanks
> Scott
>|||many thanks
scott

Tuesday, March 6, 2012

64-bit SQL Server 2005 Installation (Reporting Services)

Hi,

Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server. The Reporting services is not getting installed or the option is disabled. The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. The server also has SQL Server 2000 (32bit).

Is the 32-bit SQL Server 2000 (32 bit) a problem ? But, it was working fine with the SQL Server 2005 CTP.

Can anyone help/suggest ?

Thanks in advance.remove other reporting services from your machine. and try again

64-bit Reporting Services 2005 single-threading?

We're running on an AMD 8-core Opteron, with Enterprise RS 2005 64-bit.
It seems that when we have multiple users running reports at the same time,
the mdx queries get executed in parallel to the AS database, but the
processing of the data by reporting services is done in a single-thread mode.
E.g. a report run by itself takes 15 seconds. Same report run by 5 people can
take 3:30 to return (with the w3wp taking up the equivalent of only 1 core).
My laptop running RS 2005 processes these simultaneous report faster than our
Opteron!!!
We played with setting the # of workers on the IIS Appl Pool, and it does
seem to cause multiple reports to be processed simultaneously, but I don't
think this is the best solution. I think we are running the equivalent of 8
copies of reporting services on the box in this configuration -- I see 8 RS
logs being generated.
Is there a setting in either IIS or RS 2005 to make it process requests in
parallel?
SteveHi Steve,
Me too, interested to know the answer to your question. If you find out -
please update.
Thanks,
Al
"SteveIrwin" wrote:
...
> Is there a setting in either IIS or RS 2005 to make it process requests in
> parallel?
> Steve|||It looks like the App Pool that gets created for RS has CPUAffinity assign to
it, I think. When you create another App Pool in IIS, and switch the
Reporting Services vdir to use the new pool, then it behaves like a regular
website -- one worker process that answers all requests that come to it,
spawning multiple threads if necessary.
So it comes down to how you want to have RS to work: do you want one worker
that spawns threads to handle requests, or have multiple workers that will
each take up only one cpu/core for each request, then move on to the next
request. It would be interested to see any whitepapers on this subject.
Steve
"TheTechie" wrote:
> Hi Steve,
> Me too, interested to know the answer to your question. If you find out -
> please update.
> Thanks,
> Al
> "SteveIrwin" wrote:
> ...
> > Is there a setting in either IIS or RS 2005 to make it process requests in
> > parallel?
> >
> > Steve

Saturday, February 25, 2012

64-Bit Edition for RS Database

I am attempting to install Reporting Services on a 32-bit application server
with the database on another box running SQL Server 2000 "Enterprise Edition
(64-bit)" . I am receiving the following error:
"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose ..."
The version I am attempting to install is "Reporting Services Enterprise
Edition". I've verified in the install window that it is the Enterprise
Edition of Reporting Services that I am trying to install. I have verified
that I can connect to the 64-bit server from my application server and my SQL
Login Account has SysAdmin permissions. I ran the SELECT
SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition') command that I read in another thread and it
returned the following information:
8.00.760 SP3 Enterprise Edition (64-bit)
I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
anyone installed Reporting Services using 64-bit SQL Server 2000 for the
database repository?
Thanks in advance...Setup will not allow you to install using a 64 bit version of SQL. There
are manual steps you can perform to get this to work, but it would require a
32 bit version of SQL.
1) Install RS pointing to the 32 bit version of SQL.
2) move both the ReportServer DB and the ReportServerTemp DB to the 64 bit
version (I don't know what the exact steps are to move a database from a 32
bit to a 64 bit sql, you would have to investigate this)
3) use rsconfig.exe to point RS to the 64 bit version of the catalog
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Malinda Jepsen" <Malinda Jepsen@.discussions.microsoft.com> wrote in message
news:E3DE691A-4A16-46CD-BE89-9964EE0FDCBA@.microsoft.com...
> I am attempting to install Reporting Services on a 32-bit application
server
> with the database on another box running SQL Server 2000 "Enterprise
Edition
> (64-bit)" . I am receiving the following error:
> "This edition of the Report Server Database is not supported on the
edition
> of SQL Server 2000 you have chosen. Please choose ..."
> The version I am attempting to install is "Reporting Services Enterprise
> Edition". I've verified in the install window that it is the Enterprise
> Edition of Reporting Services that I am trying to install. I have
verified
> that I can connect to the 64-bit server from my application server and my
SQL
> Login Account has SysAdmin permissions. I ran the SELECT
> SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
> SERVERPROPERTY ('edition') command that I read in another thread and it
> returned the following information:
> 8.00.760 SP3 Enterprise Edition (64-bit)
> I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
> anyone installed Reporting Services using 64-bit SQL Server 2000 for the
> database repository?
> Thanks in advance...|||Finally success!
What I found was that I couldn't pull a database from another install of
Reporting Services. Since I had already installed it in our lab environment
on a 32-bit server, I first tried to attach that database. But when I did
that, Reporting Services thought I wanted to join a web farm. Then when I
tried to install it with the .ini file with SQL authentication to create the
database (RSSETUPACCOUNT/RSSETUPPASSWORD), it was not creating the database
(even though the SQL user I was using had SysAdmin permissions). I finally
gave my NT account SysAdmin rights and then it would create the database
(using the default install without an .ini file). Once that was complete,
sure enough, I could just move it to the 64-bit server (using standard
detach/attach). One final step was to give the SQL (or NT) user permissions
in the database (I started with datareader and datawriter).
"Daniel Reib [MSFT]" wrote:
> Setup will not allow you to install using a 64 bit version of SQL. There
> are manual steps you can perform to get this to work, but it would require a
> 32 bit version of SQL.
> 1) Install RS pointing to the 32 bit version of SQL.
> 2) move both the ReportServer DB and the ReportServerTemp DB to the 64 bit
> version (I don't know what the exact steps are to move a database from a 32
> bit to a 64 bit sql, you would have to investigate this)
> 3) use rsconfig.exe to point RS to the 64 bit version of the catalog
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Malinda Jepsen" <Malinda Jepsen@.discussions.microsoft.com> wrote in message
> news:E3DE691A-4A16-46CD-BE89-9964EE0FDCBA@.microsoft.com...
> > I am attempting to install Reporting Services on a 32-bit application
> server
> > with the database on another box running SQL Server 2000 "Enterprise
> Edition
> > (64-bit)" . I am receiving the following error:
> > "This edition of the Report Server Database is not supported on the
> edition
> > of SQL Server 2000 you have chosen. Please choose ..."
> >
> > The version I am attempting to install is "Reporting Services Enterprise
> > Edition". I've verified in the install window that it is the Enterprise
> > Edition of Reporting Services that I am trying to install. I have
> verified
> > that I can connect to the 64-bit server from my application server and my
> SQL
> > Login Account has SysAdmin permissions. I ran the SELECT
> > SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
> > SERVERPROPERTY ('edition') command that I read in another thread and it
> > returned the following information:
> > 8.00.760 SP3 Enterprise Edition (64-bit)
> >
> > I'm suspect that the "Enterprise Edition (64-bit)" is the culprit. Has
> > anyone installed Reporting Services using 64-bit SQL Server 2000 for the
> > database repository?
> >
> > Thanks in advance...
>
>

Sunday, March 25, 2012

a couple reporting/ normalization questions

a couple reporting/ normalization questions

a couple reporting/ normalization questions

A couple of beginner's questions about reporting services

A connection could not be made with report server ...

A connection could not be made to the reporting server http://localhost/reportserver

Server Error in '/ReportServer' Application.

Configuration Error

A connection could not be made to the reporting server http://localhost/reportserver

A connection could not be made to the report server http://localhost/reportServer..

A connection could not be made to the report server http://localhost/reportServer..

A connection could not be made to the report server http://localhost/reportServer..

A connection could not be made to the report server http://localhost/Reports.

Thursday, March 22, 2012

A connection could not be made to the report server

Monday, March 19, 2012

9MB of errors in log file each time RS report is run

9GB log file generated

8gb of log files - how to i stop ?

Tuesday, March 6, 2012

64-bit SQL Server 2005 Installation (Reporting Services)

64-bit Reporting Services 2005 single-threading?

Saturday, February 25, 2012

64-Bit Edition for RS Database

3G ram for SQL server

Blog Archive

About Me