Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts

Thursday, March 22, 2012

Duplex printing SRS 2000

Is it possible to set a printer to duplex within SQL Reporting Service 2000?
I have several reports to print and need to switch back and forth between
duplex (Front and Back) and one sided printing.
TIABump
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>|||I guess no one else has been able to do this either. Time to start looking
for a new report writer.
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>sql

Duplex printing in reporting services

I have been working on this problem for days. I have a report that is grouped
and will be printed duplex (front and back). There is a page break after each
group. I want to ensure that the start of a new group does not end up printed
on the back side of an old group. For example:

Page 1 (printed on front side of paper): group 1
Page 2 (printed on back side of paper): more group 1
Page 3 (printed on front side of paper): more group 1
Page 4 (printed on on back side of paper): group 2 < This is a problem

I need:

Page 1 (front side): group 1
Page 2 (back side): more group 1
Page 3 (front side): more group 1
Page 4 (back side): <This Page Intentionally Left Blank>
Page 5 (front side): group 2

Issues that I've run into include the fact that SSRS renders the entire body
first, before rendering the header/footer. This prevents the body of the
report from knowing which page it will end up on when it is rendered (and is
also why you cannot reference Globals!PageNumber from the body).

The restriction above also prevents using a variable in custom code to know
when to generate a page break. If you set this variable in the header/footer
then the body will never see it as the entire body is rendered first and will
therefore only see the initial state of the variable.

I have seen this issue posted in a number of places,
but no one ever has a solution to this (except switching back to
Crystal Reports). Have any MVPs ever addressed this issue? I am
really hoping someone can offer a good solution or work-around.


Finally - I have resolved this problem. We are writing the results to a pdf file, and was therefore able to use PDFSharp to update the output file before making it available to our users. With PDFSharp, I loop through each page of the exported report and determine whether it is the start of a new group (by checking the contents of the page). If it is a new group and the page number is EVEN, then I insert a blank page just before. So while there is no way to determine page numbers in Reporting Services, there is a way to manipulate the pdf output to be correct for duplex printing.

Duplex printing in reporting services

I have been working on this problem for days. I have a report that is grouped
and will be printed duplex (front and back). There is a page break after each
group. I want to ensure that the start of a new group does not end up printed
on the back side of an old group. For example:

Page 1 (printed on front side of paper): group 1
Page 2 (printed on back side of paper): more group 1
Page 3 (printed on front side of paper): more group 1
Page 4 (printed on on back side of paper): group 2 < This is a problem

I need:

Page 1 (front side): group 1
Page 2 (back side): more group 1
Page 3 (front side): more group 1
Page 4 (back side): <This Page Intentionally Left Blank>
Page 5 (front side): group 2

Issues that I've run into include the fact that SSRS renders the entire body
first, before rendering the header/footer. This prevents the body of the
report from knowing which page it will end up on when it is rendered (and is
also why you cannot reference Globals!PageNumber from the body).

The restriction above also prevents using a variable in custom code to know
when to generate a page break. If you set this variable in the header/footer
then the body will never see it as the entire body is rendered first and will
therefore only see the initial state of the variable.

I have seen this issue posted in a number of places,
but no one ever has a solution to this (except switching back to
Crystal Reports). Have any MVPs ever addressed this issue? I am
really hoping someone can offer a good solution or work-around.


Finally - I have resolved this problem. We are writing the results to a pdf file, and was therefore able to use PDFSharp to update the output file before making it available to our users. With PDFSharp, I loop through each page of the exported report and determine whether it is the start of a new group (by checking the contents of the page). If it is a new group and the page number is EVEN, then I insert a blank page just before. So while there is no way to determine page numbers in Reporting Services, there is a way to manipulate the pdf output to be correct for duplex printing.

Wednesday, March 21, 2012

Dundas CHART for Reporting Services

I'm curious to know others opinion of the Dundas Charting for Reporting
Services. I have downloaded and installed the beta and it appears to be
nice. Although I haven't had a chance to get any real reports created with
it. I like the fact that I can change the chart type while viewing the
report. Well, at least I can with VS.NET 2003.
I'm wondering if it is published to a server is the users can also change
the report type.Hi dm4714,
well, I am wanting to try it out too...I'll let you know what I
think....the beta has only been available for a week or so ... it's
pretty early...
We are looking to use RS + DotNetNuke + Dundas for RS....we felt the
charts inside 'vanilla RS' were a bit 'vanilla' and we wanted to
improve our charting with Dundas....
Best Regards
Peter Nolan
www.peternolan.com|||Hi dm4714,
well, I have my new instance of XP Pro and CTP version of SQL Server
2005 Dundas Chart Beta and I even bought a book on new 2005
features...learning as fast as I can...(LOL).
Without being an 'advertisement' I can say on first look Dundas Chart
for Report Services 2005 looks really good. I have had a small play
with it and am in the process of reading the manuals and understanding
how it actually works. In 2005 the Dundas Chart is a control that can
be placed into a form and you have complete control over the chart via
VB.net and C sharp. So, if you can code it, you can make the chart do
it...it seems.....I don't know the limitations as I have not got
there yet!!
The chart is placed onto the form and connected to dataset in similar
fashion to the MSFT chart that comes with RS2005. However, the range
of charts and the range of options is very large.....there also seems
to be some way to write pre/post rendering code in .net languages
though I am yet to figure that out....the samples allow you to control
such things as the type of chart produced based on another control so
the user can change the chart type on the fly.....
The documentation promises that the chart is drillable but I have not
yet tried (or even understood how to try) that feature...I asked
Dundas if they would publish an example of a drillable chart in dundas
in 2005 as I am keen to see how to do that.....we want the charts we
produce to be drillable...
It was not obvious at the start, but Dundas Chart for RS 2005 is a
completely separate product to Dundas Chart.
So, my feedback having read the manual for about 6 hours and gone
through all the samples is that it looks pretty good. Certainly I feel
we made a reasonable decision to wait for 2005 than try to get earlier
versions of any charts to work inside RS 2000.
I'll post again here when we have actually written some code and learn
some more......might be a few weeks...
I too would be very interested to hear anyone elses comments... :-)
Peter Nolan
www.peternolan.com|||I have spent about 2-3 weeks prototyping many different types of charts using
Dundas's SRS control and overall I am very impressed with it. I am using the
June CTP of SRS 2005. Here is my two cents worth of what I have found...
One big item that is missing is the ability to have a tooltip/hover message
on each data marker in a chart. Even though Dundas's base charts have this
functionality, Microsoft only allows ONE tooltip per control in SRS 2005. MS
says that this functionality is being limited due to security reasons and
Dundas had to disable this feature.
I would be interested where you got a book on SRS 2005 as I understand that
they have been releases to the market as of yet. Andrew Bryan at Dundas,
really great guy, is writing a book on how to create a custom control that
can be consumed in SRS2005. There is not any documentation at all on this as
of yet.
The programmability of Dundas's charts is really cool. With just a little
C# code I was able to inject my own image at each data marker on a chart. I
am currently working on trying to produce my own custom legend due to our
business requirements.
I would recommend that anyone using this control investigate the Advanced
tab. All of the really powerful stuff is in there. I do have some issues
with getting every x-axis data label to display, but this may be my problem.
I can only get them to display if I use both the primary and secondary x-axis
labels.
Performance is good and the 3D effects are done very well. My biggest
complaint is the lack of documentation and examples. Being a developer, I
like to have the nitty gritty details and all of this beta software sometimes
drives me nuts trying to get it to do what I want.
=====================Thanks!
Keith
p.s. Get off the couch and exercise!
"Peter Nolan" wrote:
> Hi dm4714,
> well, I have my new instance of XP Pro and CTP version of SQL Server
> 2005 Dundas Chart Beta and I even bought a book on new 2005
> features...learning as fast as I can...(LOL).
> Without being an 'advertisement' I can say on first look Dundas Chart
> for Report Services 2005 looks really good. I have had a small play
> with it and am in the process of reading the manuals and understanding
> how it actually works. In 2005 the Dundas Chart is a control that can
> be placed into a form and you have complete control over the chart via
> VB.net and C sharp. So, if you can code it, you can make the chart do
> it...it seems.....I don't know the limitations as I have not got
> there yet!!
> The chart is placed onto the form and connected to dataset in similar
> fashion to the MSFT chart that comes with RS2005. However, the range
> of charts and the range of options is very large.....there also seems
> to be some way to write pre/post rendering code in .net languages
> though I am yet to figure that out....the samples allow you to control
> such things as the type of chart produced based on another control so
> the user can change the chart type on the fly.....
> The documentation promises that the chart is drillable but I have not
> yet tried (or even understood how to try) that feature...I asked
> Dundas if they would publish an example of a drillable chart in dundas
> in 2005 as I am keen to see how to do that.....we want the charts we
> produce to be drillable...
> It was not obvious at the start, but Dundas Chart for RS 2005 is a
> completely separate product to Dundas Chart.
> So, my feedback having read the manual for about 6 hours and gone
> through all the samples is that it looks pretty good. Certainly I feel
> we made a reasonable decision to wait for 2005 than try to get earlier
> versions of any charts to work inside RS 2000.
> I'll post again here when we have actually written some code and learn
> some more......might be a few weeks...
> I too would be very interested to hear anyone elses comments... :-)
> Peter Nolan
> www.peternolan.com
>|||IN SRS 2005 is there any option for multiple X-Axis
"Keith" wrote:
> I have spent about 2-3 weeks prototyping many different types of charts using
> Dundas's SRS control and overall I am very impressed with it. I am using the
> June CTP of SRS 2005. Here is my two cents worth of what I have found...
> One big item that is missing is the ability to have a tooltip/hover message
> on each data marker in a chart. Even though Dundas's base charts have this
> functionality, Microsoft only allows ONE tooltip per control in SRS 2005. MS
> says that this functionality is being limited due to security reasons and
> Dundas had to disable this feature.
> I would be interested where you got a book on SRS 2005 as I understand that
> they have been releases to the market as of yet. Andrew Bryan at Dundas,
> really great guy, is writing a book on how to create a custom control that
> can be consumed in SRS2005. There is not any documentation at all on this as
> of yet.
> The programmability of Dundas's charts is really cool. With just a little
> C# code I was able to inject my own image at each data marker on a chart. I
> am currently working on trying to produce my own custom legend due to our
> business requirements.
> I would recommend that anyone using this control investigate the Advanced
> tab. All of the really powerful stuff is in there. I do have some issues
> with getting every x-axis data label to display, but this may be my problem.
> I can only get them to display if I use both the primary and secondary x-axis
> labels.
> Performance is good and the 3D effects are done very well. My biggest
> complaint is the lack of documentation and examples. Being a developer, I
> like to have the nitty gritty details and all of this beta software sometimes
> drives me nuts trying to get it to do what I want.
> =====================> Thanks!
> Keith
> p.s. Get off the couch and exercise!
>
> "Peter Nolan" wrote:
> > Hi dm4714,
> > well, I have my new instance of XP Pro and CTP version of SQL Server
> > 2005 Dundas Chart Beta and I even bought a book on new 2005
> > features...learning as fast as I can...(LOL).
> >
> > Without being an 'advertisement' I can say on first look Dundas Chart
> > for Report Services 2005 looks really good. I have had a small play
> > with it and am in the process of reading the manuals and understanding
> > how it actually works. In 2005 the Dundas Chart is a control that can
> > be placed into a form and you have complete control over the chart via
> > VB.net and C sharp. So, if you can code it, you can make the chart do
> > it...it seems.....I don't know the limitations as I have not got
> > there yet!!
> >
> > The chart is placed onto the form and connected to dataset in similar
> > fashion to the MSFT chart that comes with RS2005. However, the range
> > of charts and the range of options is very large.....there also seems
> > to be some way to write pre/post rendering code in .net languages
> > though I am yet to figure that out....the samples allow you to control
> > such things as the type of chart produced based on another control so
> > the user can change the chart type on the fly.....
> >
> > The documentation promises that the chart is drillable but I have not
> > yet tried (or even understood how to try) that feature...I asked
> > Dundas if they would publish an example of a drillable chart in dundas
> > in 2005 as I am keen to see how to do that.....we want the charts we
> > produce to be drillable...
> >
> > It was not obvious at the start, but Dundas Chart for RS 2005 is a
> > completely separate product to Dundas Chart.
> >
> > So, my feedback having read the manual for about 6 hours and gone
> > through all the samples is that it looks pretty good. Certainly I feel
> > we made a reasonable decision to wait for 2005 than try to get earlier
> > versions of any charts to work inside RS 2000.
> >
> > I'll post again here when we have actually written some code and learn
> > some more......might be a few weeks...
> >
> > I too would be very interested to hear anyone elses comments... :-)
> >
> > Peter Nolan
> > www.peternolan.com
> >
> >|||Dundas is very nice.
Here is a tool (free) which make charts similar to Dundas and can be
plugged
easily to sqlserver (being .NET):
http://151.100.3.84/technicalpreview/
-Pamela
.NET Developer|||Hi Keith,
the book I bought is called 'SQL Server 2005 New Features' by Michael
Otley. Senior Technical Editor SQL Server Magazine. It only has a
small section on SRS but it does cover lots and lots of the new stuff
in 2005 and there is quite a bit...after all it has been 5 years!!!
(LOL)..It's about 250 pages...I bought it because it would save me
hours and hours of flicking through other manuals and presentations
just to get the highlights of the new features...I think it's worth
getting....(I buy a lot of books.)
It seems like partitioning has been done properly in 2005...and I am
very interested/impressed with the idea that something that looks like
a stored procedure can actually be a .net programming language....I
can think of plenty of uses of such a feature.....I am trying to
figure out if I can turn 10,000 lines of SPs that I have written into
something that cannot be read, like a program...but heck, I only got
the book on the weekend....more reading to do yet...
Best Regards
Peter Nolan.|||Peter,
Thanks for the kind words and plug for my book! ... I guess I really
have to get to work on it now eh? It is expected to be released in
March.
With respect to the docs and samples, this is an area that I will be
focusing in the next couple of weeks. The docs will be a continual
work in progress but we we be getting more technical writing done soon.
For the samples, this is where you can help. If there is a particular
sample that you would like to see, let us know. We would like to get
this product's sample set as complete as our .net offerings but it will
take some time.
There will be a new beta released in Sept for the release candidate of
SQL Server 2005 so what for it ... there will be more samples in that
build.
Thanks again,
Andrew Bryan
Keith wrote:
> I have spent about 2-3 weeks prototyping many different types of charts using
> Dundas's SRS control and overall I am very impressed with it. I am using the
> June CTP of SRS 2005. Here is my two cents worth of what I have found...
> One big item that is missing is the ability to have a tooltip/hover message
> on each data marker in a chart. Even though Dundas's base charts have this
> functionality, Microsoft only allows ONE tooltip per control in SRS 2005. MS
> says that this functionality is being limited due to security reasons and
> Dundas had to disable this feature.
> I would be interested where you got a book on SRS 2005 as I understand that
> they have been releases to the market as of yet. Andrew Bryan at Dundas,
> really great guy, is writing a book on how to create a custom control that
> can be consumed in SRS2005. There is not any documentation at all on this as
> of yet.
> The programmability of Dundas's charts is really cool. With just a little
> C# code I was able to inject my own image at each data marker on a chart. I
> am currently working on trying to produce my own custom legend due to our
> business requirements.
> I would recommend that anyone using this control investigate the Advanced
> tab. All of the really powerful stuff is in there. I do have some issues
> with getting every x-axis data label to display, but this may be my problem.
> I can only get them to display if I use both the primary and secondary x-axis
> labels.
> Performance is good and the 3D effects are done very well. My biggest
> complaint is the lack of documentation and examples. Being a developer, I
> like to have the nitty gritty details and all of this beta software sometimes
> drives me nuts trying to get it to do what I want.
> =====================> Thanks!
> Keith
> p.s. Get off the couch and exercise!
>
> "Peter Nolan" wrote:
> > Hi dm4714,
> > well, I have my new instance of XP Pro and CTP version of SQL Server
> > 2005 Dundas Chart Beta and I even bought a book on new 2005
> > features...learning as fast as I can...(LOL).
> >
> > Without being an 'advertisement' I can say on first look Dundas Chart
> > for Report Services 2005 looks really good. I have had a small play
> > with it and am in the process of reading the manuals and understanding
> > how it actually works. In 2005 the Dundas Chart is a control that can
> > be placed into a form and you have complete control over the chart via
> > VB.net and C sharp. So, if you can code it, you can make the chart do
> > it...it seems.....I don't know the limitations as I have not got
> > there yet!!
> >
> > The chart is placed onto the form and connected to dataset in similar
> > fashion to the MSFT chart that comes with RS2005. However, the range
> > of charts and the range of options is very large.....there also seems
> > to be some way to write pre/post rendering code in .net languages
> > though I am yet to figure that out....the samples allow you to control
> > such things as the type of chart produced based on another control so
> > the user can change the chart type on the fly.....
> >
> > The documentation promises that the chart is drillable but I have not
> > yet tried (or even understood how to try) that feature...I asked
> > Dundas if they would publish an example of a drillable chart in dundas
> > in 2005 as I am keen to see how to do that.....we want the charts we
> > produce to be drillable...
> >
> > It was not obvious at the start, but Dundas Chart for RS 2005 is a
> > completely separate product to Dundas Chart.
> >
> > So, my feedback having read the manual for about 6 hours and gone
> > through all the samples is that it looks pretty good. Certainly I feel
> > we made a reasonable decision to wait for 2005 than try to get earlier
> > versions of any charts to work inside RS 2000.
> >
> > I'll post again here when we have actually written some code and learn
> > some more......might be a few weeks...
> >
> > I too would be very interested to hear anyone elses comments... :-)
> >
> > Peter Nolan
> > www.peternolan.com
> >
> >|||I have not used the chart package for 2005 but the previous charts were
drillable ... I would like to think that they didnt *remove* functionality
...
Right click on your chart and choose Properties. Choose the data tab ...
select one of your values and then EDIT. You will notice a series of tabs
that display ... choose the one that says ACTION and you will see "jump to
report" which is the drill - thru. Thats where it is on the OLD way ... I
hope you can find it somewhere in the vicinity on the package you are working
with. Let me know ... ok? Thanks!
"Peter Nolan" wrote:
> Hi dm4714,
> well, I have my new instance of XP Pro and CTP version of SQL Server
> 2005 Dundas Chart Beta and I even bought a book on new 2005
> features...learning as fast as I can...(LOL).
> Without being an 'advertisement' I can say on first look Dundas Chart
> for Report Services 2005 looks really good. I have had a small play
> with it and am in the process of reading the manuals and understanding
> how it actually works. In 2005 the Dundas Chart is a control that can
> be placed into a form and you have complete control over the chart via
> VB.net and C sharp. So, if you can code it, you can make the chart do
> it...it seems.....I don't know the limitations as I have not got
> there yet!!
> The chart is placed onto the form and connected to dataset in similar
> fashion to the MSFT chart that comes with RS2005. However, the range
> of charts and the range of options is very large.....there also seems
> to be some way to write pre/post rendering code in .net languages
> though I am yet to figure that out....the samples allow you to control
> such things as the type of chart produced based on another control so
> the user can change the chart type on the fly.....
> The documentation promises that the chart is drillable but I have not
> yet tried (or even understood how to try) that feature...I asked
> Dundas if they would publish an example of a drillable chart in dundas
> in 2005 as I am keen to see how to do that.....we want the charts we
> produce to be drillable...
> It was not obvious at the start, but Dundas Chart for RS 2005 is a
> completely separate product to Dundas Chart.
> So, my feedback having read the manual for about 6 hours and gone
> through all the samples is that it looks pretty good. Certainly I feel
> we made a reasonable decision to wait for 2005 than try to get earlier
> versions of any charts to work inside RS 2000.
> I'll post again here when we have actually written some code and learn
> some more......might be a few weeks...
> I too would be very interested to hear anyone elses comments... :-)
> Peter Nolan
> www.peternolan.com
>|||Hi MJ,
it is there, the manual talks about how to do it, but it needs to be
written into the controls as .net it looks like....my problem is that
my skill level is not up to it yet!!! ;-)..I think I am just not
'there' yet.
I am not after the jump/hypelink style of drill thru, I am looking for
subsetting the data from the existing dataset.....like I said, it is
just hard for me to follow..
I have had feedback from Dundas that they will prepare an example as
part of the beta...in fact they are being great they really seem to
want to hear what people want in the product!! What a nice change for a
software vendor!!!
Peter
www.peternolan.com

Dundas 2.0 for RS and image quality...disappointing

I was pretty excited to get the image quality improvements in Dundas
Charting for Reporting Services 2.0. Chris Hays blog on the issue of
rendering charts in a Custom Report Item explains the issue well.
http://blogs.msdn.com/chrishays/archive/2006/04/19/CustomReportItemImageQuality.aspx
We like the Dundas charts, but the image quality in pdf format isn't nearly
as good as the native charts, which I believe are also made by Dundas. With
the new properties of ImageResolution and Sizing I was hoping that I could
find a combination that would generate smooth images in both HTML and PDF
formats. I couldn't, I went back and read Chris' article and now understand
that there needs to be a mechanism to set these settings on a per/renderer
basis, or just wait for RS 200x or spx to implement vector graphic support.Hi Steve,
If you would like help or direction in how to best implement this,
please let us know. We have implemented such a mechanism in our online
report demo environment and have some tips on our support site:
http://demos2.dundas.com/ReportingServices/
http://support.dundas.com/
There are a couple of ways to do this but the best solution depends on
how your reports are consumed. I would be happy to discuss your
options with you.
Andrew Bryan
Dundas Software
416-467-9100 x122
Steve MunLeeuw wrote:
> I was pretty excited to get the image quality improvements in Dundas
> Charting for Reporting Services 2.0. Chris Hays blog on the issue of
> rendering charts in a Custom Report Item explains the issue well.
> http://blogs.msdn.com/chrishays/archive/2006/04/19/CustomReportItemImageQuality.aspx
> We like the Dundas charts, but the image quality in pdf format isn't nearly
> as good as the native charts, which I believe are also made by Dundas. With
> the new properties of ImageResolution and Sizing I was hoping that I could
> find a combination that would generate smooth images in both HTML and PDF
> formats. I couldn't, I went back and read Chris' article and now understand
> that there needs to be a mechanism to set these settings on a per/renderer
> basis, or just wait for RS 200x or spx to implement vector graphic support.|||Ok, sorry for the poor attitude, I will try again next release.
Steve MunLeeuw
<andrewb@.dundas.com> wrote in message
news:1158696150.448185.311420@.b28g2000cwb.googlegroups.com...
> Hi Steve,
> If you would like help or direction in how to best implement this,
> please let us know. We have implemented such a mechanism in our online
> report demo environment and have some tips on our support site:
> http://demos2.dundas.com/ReportingServices/
> http://support.dundas.com/
> There are a couple of ways to do this but the best solution depends on
> how your reports are consumed. I would be happy to discuss your
> options with you.
> Andrew Bryan
> Dundas Software
> 416-467-9100 x122
>
> Steve MunLeeuw wrote:
>> I was pretty excited to get the image quality improvements in Dundas
>> Charting for Reporting Services 2.0. Chris Hays blog on the issue of
>> rendering charts in a Custom Report Item explains the issue well.
>> http://blogs.msdn.com/chrishays/archive/2006/04/19/CustomReportItemImageQuality.aspx
>> We like the Dundas charts, but the image quality in pdf format isn't
>> nearly
>> as good as the native charts, which I believe are also made by Dundas.
>> With
>> the new properties of ImageResolution and Sizing I was hoping that I
>> could
>> find a combination that would generate smooth images in both HTML and PDF
>> formats. I couldn't, I went back and read Chris' article and now
>> understand
>> that there needs to be a mechanism to set these settings on a
>> per/renderer
>> basis, or just wait for RS 200x or spx to implement vector graphic
>> support.
>sql

Monday, March 19, 2012

dumb question...

After configuring exactly as specified in reporting services custom security, when I try to hit report manager, I keep on getting the error:

Invalid URI: The format of the URI could not be determined.

It does not redirct me to UILogin.aspx page but forwards me to Pages/Folder.aspx and gives this error.

Please if possible let me know ASAP.

I have the following in "rsreportserver.config" file

<UrlRoot>http://<computername>/reportserver</UrlRoot>

I have tried using "localhost" instead of computer name in the above line. Secondly, when I hit report manager, I thought it should redirect me to UILogin.aspx. It does not. And even if it did, I would like to know how it would do that because in report server, you specify the url in the <forms> tag. here there is no such tag that would make it redirect to UILogon.aspx.

I have the following in Web.config file of Report Manager

<authentication mode="Windows" />
<identity impersonate="false" />

I have the following in RsWebApplication.config file

<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<CustomAuthenticationUI>
<loginUrl>UILogin.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
</UI>

Thanks.

Thanks.

Solved it

There were 2 issues

the UILogon.aspx file was not under pages(wonder what that would do?)

Secondly, changed the ordering in RSWebApplication.config file to

<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<computername>/ReportServer</ReportServerUrl>
</UI>

Finally, in the url requested

http://<computername>/Reports

|||

I been trying to get my own sql reporting services going... but i have so many issues..

the dumb question: does SQL 2005 Reporting Services require IIS 6.0 ? Windows 2003?

thanks

|||

Should work on xp pro . no need for windows 2003. For production deployment however, consider deploying enterprise version on windows server 2003.

Also always use iis6.0

|||

so, iis5 does not work?

Dumb question

Simple question from a simpleton. I'm working through Microsoft Press SQL Server 2005 Reporting Services Step by Step. It references a database rs2005sbsDW, which as far as I can tell was not included with either the sample databases on the SQL Server (standard edition) install disk or the Step by Step book. Where the heck is it? What am I missing.

Trying to reinstall the sample databases from the SQL Server install disk's tells me I have everything installed already.

Thanks in advance.

Hi,

Did you follow the instructions on page XV? The files will be installed via a setup.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

I did thanks. I was using the book a bit too literally. The instructions for specifying the database in the connection manager just suggest typing the database name in or using the drop down box, neither which accepted or display the rs2005sbsDW database. I assumed it just wasn't there. Once I knew where is was, it became obvious to use the browse option in connection manager instead.

Thanks.

|||Please I need the datasource rs2005sbsDW my email is edupuebla@.yahoo.com.

Thanks

Sunday, March 11, 2012

Dumb question

Simple question from a simpleton. I'm working through Microsoft Press SQL Server 2005 Reporting Services Step by Step. It references a database rs2005sbsDW, which as far as I can tell was not included with either the sample databases on the SQL Server (standard edition) install disk or the Step by Step book. Where the heck is it? What am I missing.

Trying to reinstall the sample databases from the SQL Server install disk's tells me I have everything installed already.

Thanks in advance.

Hi,

Did you follow the instructions on page XV? The files will be installed via a setup.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

I did thanks. I was using the book a bit too literally. The instructions for specifying the database in the connection manager just suggest typing the database name in or using the drop down box, neither which accepted or display the rs2005sbsDW database. I assumed it just wasn't there. Once I knew where is was, it became obvious to use the browse option in connection manager instead.

Thanks.

|||Please I need the datasource rs2005sbsDW my email is edupuebla@.yahoo.com.

Thanks

Dual y-axis chart combo chart

Can reporting service 2000 do combo chart (column and line) with two y-axis?Hi,
You can place two charts side by side.
Amarnath
"qye2020" wrote:
> Can reporting service 2000 do combo chart (column and line) with two y-axis?
>
>|||Use the "Plot data as line" option to mix lines with bars or with columns.
I was able to develop a way to simulate a second y axis. In my case the
data source was a cube. I had two types of series, one with large, whole
numbers, and one with percentages, which caused the percentages to be at the
zero point when displayed with the other type of series. My solution was to
write a calculated member that found the maximum value of the whole number
series for all rows, and to round that value up to the next highest number.
Therefore, if the series returned 8,235 as the maximum value in any row, the
result of my calculated member would be 9,000. The 9,000 value of the
calculated member was returned for every row. In the graph I used the value
property of the percentage series to multiply the actual value by my
calculated member value. I used the label property to obtain the actual
percentage value. Thus, 80% became .8 * 9000 for plotting purposes, but the
data point label said 80%. The result was a successful combination of the
two very different types of series. The only thing that I could not do
without a true second y axis was having the tick marks and labels of a second
axis along the right side of the graph.
--
Brian C. Berg
MCSE+I, MCDBA
Berg Information Technology, Inc.
This posting is provided "AS IS" with no warranties, and confers no rights.
"qye2020" wrote:
> Can reporting service 2000 do combo chart (column and line) with two y-axis?
>
>

Wednesday, March 7, 2012

Dual axes in RS2k5

I seem to remember reading that in Reporting Services 2005 it would be
possible to create column charts with dual axes, in particular with a dual y
axis.
I've been playing around with the charts but I can't seem to find a way to
do this. Did this functionality find its way into the product in the end? How
is it done?
Thanks,
Matt.Hi Matt,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood would like to know whether Dual axes
will be supported in SQL Server 2005 Reporting Services. If I have
misunderstood your concern, please feel free to point it out.
Unfortunately, dual axes are not supported in the built-in charting
included with SQL Server 2005 RS. However, Dundas (see
http://www.dundasreporting.com/home/index.aspx) will be providing a plug-in
that supports this functionality.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

dual axes

How to use dual axes in Reporting?
--
asharmaOn Apr 12, 4:12 am, asharma2004 <asha...@.harbingertechaxes.com> wrote:
> How to use dual axes in Reporting?
> --
> asharma
Are you referring to multi-columns or flipping half of a report page
(as in a wedding invitation, etc)? If you are referring to the multi-
columns, you would do the following (otherwise, the flipping option,
as far as I know, is not available in SSRS):
Select Layout view -> select the Report tab at the top -> select
Report Properties -> select the Layout tab -> and select the desired
number of columns on the top left (and other desired properties).
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant