refer this link for latest fixes in SQL Server 2005...
http://support.microsoft.com/kb/933508
SP2 Release version was --9.00.3042.00
Latest version with this fix(Mar 05) is -- 9.00.3050.00
Madhu
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Thursday, March 22, 2012
Build 9.0.3050
I downloaded SP2 on March 10, 2007, and applied it. The system to which I applied it reports 9.0.3050 as the version number, not 9.0.3042. Is this due to the post-SP2 fix?My system, which was updated with the bugged SP2, and then the subsequent hotfix, also reports 9.0.3050. So that seems like a reasonable assumption.|||
Bug?-when using nested subreports in combination with list
Someone please help me with a workaround on this issue:
I have created three reports: (ReportA, ReportB and ReportC).
ReportA includes a subreport (ReportB). ReportB consists of one list. The list is bound to a dataset. The list consists of one subreport (ReportC). ReportC is an empty report.
What is the problem:
When running Report A,The report generation fails when the dataset that is used in ReportB returns zero rows and the report is rendered across two or more pages.
The same problem also occurs when the dataset returns one or more rows and every row are filtered away using a filter expression on the list in ReportB
To make sure that the report is rendered across two or more pages, just add some dummy data to reportA.
When reportB is run, the problem does not occur.
The first page is genereted correctly, but when I navigate to the second page, the error occur.
Anyone experienced the same issue?
This sounds similar to something I am experiencing. I am using SQL 2005.
I have 5 levels of nested reports.
The first page always displays as expected.|||Microsoft has confirmed to me that this issue is a bug and that this should be solved in Service Pack 1.|||Wow, that's great.
My PM actually solved this on for us with a work around. It's a problem related to a common business issue "asymetrical heirarchy". If there is no data in the 3rd level, it affects the turn down control on the top level. We are currently re-writing our queries to always produce results, and then hide the display when the childID = parentID.
Microsoft SRS 2005 already handles this issue better than most others, but if they're going to fix it all the way, that's great!
|||Hello,
when RS2005 SP1 wil be released?
Thanks in adavnce
Bug?-when using nested subreports in combination with list
Someone please help me with a workaround on this issue:
I have created three reports: (ReportA, ReportB and ReportC).
ReportA includes a subreport (ReportB). ReportB consists of one list. The list is bound to a dataset. The list consists of one subreport (ReportC). ReportC is an empty report.
What is the problem:
When running Report A,The report generation fails when the dataset that is used in ReportB returns zero rows and the report is rendered across two or more pages.
The same problem also occurs when the dataset returns one or more rows and every row are filtered away using a filter expression on the list in ReportB
To make sure that the report is rendered across two or more pages, just add some dummy data to reportA.
When reportB is run, the problem does not occur.
The first page is genereted correctly, but when I navigate to the second page, the error occur.
Anyone experienced the same issue?
This sounds similar to something I am experiencing. I am using SQL 2005.
I have 5 levels of nested reports.
The first page always displays as expected.|||Microsoft has confirmed to me that this issue is a bug and that this should be solved in Service Pack 1.|||
Wow, that's great.
My PM actually solved this on for us with a work around. It's a problem related to a common business issue "asymetrical heirarchy". If there is no data in the 3rd level, it affects the turn down control on the top level. We are currently re-writing our queries to always produce results, and then hide the display when the childID = parentID.
Microsoft SRS 2005 already handles this issue better than most others, but if they're going to fix it all the way, that's great!
|||Hello,
when RS2005 SP1 wil be released?
Thanks in adavnce
sql
Bug?-when using nested subreports in combination with list
Someone please help me with a workaround on this issue:
I have created three reports: (ReportA, ReportB and ReportC).
ReportA includes a subreport (ReportB). ReportB consists of one list. The list is bound to a dataset. The list consists of one subreport (ReportC). ReportC is an empty report.
What is the problem:
When running Report A,The report generation fails when the dataset that is used in ReportB returns zero rows and the report is rendered across two or more pages.
The same problem also occurs when the dataset returns one or more rows and every row are filtered away using a filter expression on the list in ReportB
To make sure that the report is rendered across two or more pages, just add some dummy data to reportA.
When reportB is run, the problem does not occur.
The first page is genereted correctly, but when I navigate to the second page, the error occur.
Anyone experienced the same issue?
This sounds similar to something I am experiencing. I am using SQL 2005.
I have 5 levels of nested reports.
The first page always displays as expected.|||Microsoft has confirmed to me that this issue is a bug and that this should be solved in Service Pack 1.|||
Wow, that's great.
My PM actually solved this on for us with a work around. It's a problem related to a common business issue "asymetrical heirarchy". If there is no data in the 3rd level, it affects the turn down control on the top level. We are currently re-writing our queries to always produce results, and then hide the display when the childID = parentID.
Microsoft SRS 2005 already handles this issue better than most others, but if they're going to fix it all the way, that's great!
|||Hello,
when RS2005 SP1 wil be released?
Thanks in adavnce
BUG? or intended that in order to move or rename reports....
...anywhere in the folder structure a person must be set up as a Content Manager at the Reporting Services ROOT (and at every level of the folder hierarchy down to the level that they are moving/renaming)?
Sure, you can remove them from the role in other folders where they should not be moving or renaming objects, but it seems you still have to have them at the root (and down the chain), which gives them far more capabilities than you might intend.
Jeff
After further examination into this problem, it appears in order for someone to move or rename a report or file, they need two things:
1) Content Manager role for the folder they are moving to/from or renaming files
2) Content Manager role for the root RS folder, but not up or down the chain between the root or the folder above.
This has really got to be a bug, as I can't imagine Microsoft doing this on purpose.
Jeff
Tuesday, March 20, 2012
BUG: provider cannot derive parameter information and setparameter
I create reports on an oracle db. I use the correct oracle provider. When i
create a report parameter and run it in the datatab, it says "provider cannot
derive parameter information and setparameterinfo has not been called".
However if I go to generic query designer or the layout tab, the report
parameter works correctly.
This appears to be a bug!!. Could someone from Microsoft please confirm this.
Much appreciated
Kevin WeirYou will need an Oracle Client 8.1.7 or later installed on the server and
the client machines. Please verify you are not using an older Oracle client.
Regardless of the data provider (OleDB or managed), they will need the
Oracle Client (OCI) to actually talk to the Oracle server.
As indicated in several other discussion threads on this newsgroup, the
visual query designer (with 4 panes) is a shared component of the VS
framework (which is unable to use the managed provider and uses the MS OleDB
provider for Oracle instead). Even if you select "Oracle" from the data
source dialog, the visual query designer will actually use the OleDB
provider, while the generic query designer will *always* use the data
provider you actually selected. I.e. "Oracle" is the managed provider of the
.NET framework. Most likely you are using named parameters (e.g. :par1)
which are only supported by the managed Oracle provider (hence the query
execution works successfully in the generic text-based query designer). The
OleDB provider only supports unnamed parameters.
Some information can also be found in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> I create reports on an oracle db. I use the correct oracle provider. When
i
> create a report parameter and run it in the datatab, it says "provider
cannot
> derive parameter information and setparameterinfo has not been called".
> However if I go to generic query designer or the layout tab, the report
> parameter works correctly.
> This appears to be a bug!!. Could someone from Microsoft please confirm
this.
> Much appreciated
> Kevin Weir
>|||Just adding another comment: The graphical query designer in RS is the VDT
component which supports only a limited list of data providers as outlined
in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811241
The text-based generic query designer in RS supports almost any data
provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23AOfSgAsEHA.3396@.tk2msftngp13.phx.gbl...
> You will need an Oracle Client 8.1.7 or later installed on the server and
> the client machines. Please verify you are not using an older Oracle
client.
> Regardless of the data provider (OleDB or managed), they will need the
> Oracle Client (OCI) to actually talk to the Oracle server.
> As indicated in several other discussion threads on this newsgroup, the
> visual query designer (with 4 panes) is a shared component of the VS
> framework (which is unable to use the managed provider and uses the MS
OleDB
> provider for Oracle instead). Even if you select "Oracle" from the data
> source dialog, the visual query designer will actually use the OleDB
> provider, while the generic query designer will *always* use the data
> provider you actually selected. I.e. "Oracle" is the managed provider of
the
> .NET framework. Most likely you are using named parameters (e.g. :par1)
> which are only supported by the managed Oracle provider (hence the query
> execution works successfully in the generic text-based query designer).
The
> OleDB provider only supports unnamed parameters.
> Some information can also be found in this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
> news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> > I create reports on an oracle db. I use the correct oracle provider.
When
> i
> > create a report parameter and run it in the datatab, it says "provider
> cannot
> > derive parameter information and setparameterinfo has not been called".
> >
> > However if I go to generic query designer or the layout tab, the report
> > parameter works correctly.
> >
> > This appears to be a bug!!. Could someone from Microsoft please confirm
> this.
> >
> > Much appreciated
> > Kevin Weir
> >
>|||Hi Robert
Thanks for your response. Your comments have clarrified this issue for me.
I did not realize the OLE DB provider was being used by Visual Designer
which accounts for different behavior in Generic Query designer.
For others that may read this thread we are using Oracle 9.2.0.4 client with
named parameters. For example, one of our queries might look like this:
SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID = :EMPLOYEE_ID
Regards
Kevin
"Robert Bruckner [MSFT]" wrote:
> You will need an Oracle Client 8.1.7 or later installed on the server and
> the client machines. Please verify you are not using an older Oracle client.
> Regardless of the data provider (OleDB or managed), they will need the
> Oracle Client (OCI) to actually talk to the Oracle server.
> As indicated in several other discussion threads on this newsgroup, the
> visual query designer (with 4 panes) is a shared component of the VS
> framework (which is unable to use the managed provider and uses the MS OleDB
> provider for Oracle instead). Even if you select "Oracle" from the data
> source dialog, the visual query designer will actually use the OleDB
> provider, while the generic query designer will *always* use the data
> provider you actually selected. I.e. "Oracle" is the managed provider of the
> ..NET framework. Most likely you are using named parameters (e.g. :par1)
> which are only supported by the managed Oracle provider (hence the query
> execution works successfully in the generic text-based query designer). The
> OleDB provider only supports unnamed parameters.
> Some information can also be found in this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
> news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> > I create reports on an oracle db. I use the correct oracle provider. When
> i
> > create a report parameter and run it in the datatab, it says "provider
> cannot
> > derive parameter information and setparameterinfo has not been called".
> >
> > However if I go to generic query designer or the layout tab, the report
> > parameter works correctly.
> >
> > This appears to be a bug!!. Could someone from Microsoft please confirm
> this.
> >
> > Much appreciated
> > Kevin Weir
> >
>
>
create a report parameter and run it in the datatab, it says "provider cannot
derive parameter information and setparameterinfo has not been called".
However if I go to generic query designer or the layout tab, the report
parameter works correctly.
This appears to be a bug!!. Could someone from Microsoft please confirm this.
Much appreciated
Kevin WeirYou will need an Oracle Client 8.1.7 or later installed on the server and
the client machines. Please verify you are not using an older Oracle client.
Regardless of the data provider (OleDB or managed), they will need the
Oracle Client (OCI) to actually talk to the Oracle server.
As indicated in several other discussion threads on this newsgroup, the
visual query designer (with 4 panes) is a shared component of the VS
framework (which is unable to use the managed provider and uses the MS OleDB
provider for Oracle instead). Even if you select "Oracle" from the data
source dialog, the visual query designer will actually use the OleDB
provider, while the generic query designer will *always* use the data
provider you actually selected. I.e. "Oracle" is the managed provider of the
.NET framework. Most likely you are using named parameters (e.g. :par1)
which are only supported by the managed Oracle provider (hence the query
execution works successfully in the generic text-based query designer). The
OleDB provider only supports unnamed parameters.
Some information can also be found in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> I create reports on an oracle db. I use the correct oracle provider. When
i
> create a report parameter and run it in the datatab, it says "provider
cannot
> derive parameter information and setparameterinfo has not been called".
> However if I go to generic query designer or the layout tab, the report
> parameter works correctly.
> This appears to be a bug!!. Could someone from Microsoft please confirm
this.
> Much appreciated
> Kevin Weir
>|||Just adding another comment: The graphical query designer in RS is the VDT
component which supports only a limited list of data providers as outlined
in this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811241
The text-based generic query designer in RS supports almost any data
provider.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23AOfSgAsEHA.3396@.tk2msftngp13.phx.gbl...
> You will need an Oracle Client 8.1.7 or later installed on the server and
> the client machines. Please verify you are not using an older Oracle
client.
> Regardless of the data provider (OleDB or managed), they will need the
> Oracle Client (OCI) to actually talk to the Oracle server.
> As indicated in several other discussion threads on this newsgroup, the
> visual query designer (with 4 panes) is a shared component of the VS
> framework (which is unable to use the managed provider and uses the MS
OleDB
> provider for Oracle instead). Even if you select "Oracle" from the data
> source dialog, the visual query designer will actually use the OleDB
> provider, while the generic query designer will *always* use the data
> provider you actually selected. I.e. "Oracle" is the managed provider of
the
> .NET framework. Most likely you are using named parameters (e.g. :par1)
> which are only supported by the managed Oracle provider (hence the query
> execution works successfully in the generic text-based query designer).
The
> OleDB provider only supports unnamed parameters.
> Some information can also be found in this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
> news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> > I create reports on an oracle db. I use the correct oracle provider.
When
> i
> > create a report parameter and run it in the datatab, it says "provider
> cannot
> > derive parameter information and setparameterinfo has not been called".
> >
> > However if I go to generic query designer or the layout tab, the report
> > parameter works correctly.
> >
> > This appears to be a bug!!. Could someone from Microsoft please confirm
> this.
> >
> > Much appreciated
> > Kevin Weir
> >
>|||Hi Robert
Thanks for your response. Your comments have clarrified this issue for me.
I did not realize the OLE DB provider was being used by Visual Designer
which accounts for different behavior in Generic Query designer.
For others that may read this thread we are using Oracle 9.2.0.4 client with
named parameters. For example, one of our queries might look like this:
SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID = :EMPLOYEE_ID
Regards
Kevin
"Robert Bruckner [MSFT]" wrote:
> You will need an Oracle Client 8.1.7 or later installed on the server and
> the client machines. Please verify you are not using an older Oracle client.
> Regardless of the data provider (OleDB or managed), they will need the
> Oracle Client (OCI) to actually talk to the Oracle server.
> As indicated in several other discussion threads on this newsgroup, the
> visual query designer (with 4 panes) is a shared component of the VS
> framework (which is unable to use the managed provider and uses the MS OleDB
> provider for Oracle instead). Even if you select "Oracle" from the data
> source dialog, the visual query designer will actually use the OleDB
> provider, while the generic query designer will *always* use the data
> provider you actually selected. I.e. "Oracle" is the managed provider of the
> ..NET framework. Most likely you are using named parameters (e.g. :par1)
> which are only supported by the managed Oracle provider (hence the query
> execution works successfully in the generic text-based query designer). The
> OleDB provider only supports unnamed parameters.
> Some information can also be found in this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834305
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kevin Weir" <KevinWeir@.discussions.microsoft.com> wrote in message
> news:D359816A-16DD-4CDD-959D-C5B066474C15@.microsoft.com...
> > I create reports on an oracle db. I use the correct oracle provider. When
> i
> > create a report parameter and run it in the datatab, it says "provider
> cannot
> > derive parameter information and setparameterinfo has not been called".
> >
> > However if I go to generic query designer or the layout tab, the report
> > parameter works correctly.
> >
> > This appears to be a bug!!. Could someone from Microsoft please confirm
> this.
> >
> > Much appreciated
> > Kevin Weir
> >
>
>
BUG: Leading Spaces in PDF stripped
Hello
We are currently generating reports in PDF format and leading spaces are now
being stripped from printed reports. This started to happen when when we
applied SP2. Has anyone else encountered this problem and if so how did you
get around it.
Much appreciated,
Kevin Weir
DirectWest PublishersI'm a little surprised no one has had a similar problem. Leading spaces are
definetly stripped from ALL strings when rendering to PDF. This started to
happen after SP2 was installed.
If someone from Microsoft sees this post are you aware this is an actual bug.
Regards
Kevin Weir
DirectWest Publishers
"Kevin Weir" wrote:
> Hello
> We are currently generating reports in PDF format and leading spaces are now
> being stripped from printed reports. This started to happen when when we
> applied SP2. Has anyone else encountered this problem and if so how did you
> get around it.
> Much appreciated,
> Kevin Weir
> DirectWest Publishers
>|||Kevin,
I have experienced the same thing, I posted a few oddities after applying
SP2 and I have not received any help. Unfortunatley I don't have a
workaround for this one except to redesign. This is very aggravating as I
had to go in to a number of reports to fix once this SP was applied. It was
the only way I could combine bold font with normal and now that does not work
either.
I will continue my search, if I found I will update this post, please do the
same.
"Kevin Weir" wrote:
> Hello
> We are currently generating reports in PDF format and leading spaces are now
> being stripped from printed reports. This started to happen when when we
> applied SP2. Has anyone else encountered this problem and if so how did you
> get around it.
> Much appreciated,
> Kevin Weir
> DirectWest Publishers
>|||Hello
I will certainly let you know if I find a solution.
Now if I could just find link/e-mail address where I could let Microsoft
know about this bug.
"DigitalVixen" wrote:
> Kevin,
> I have experienced the same thing, I posted a few oddities after applying
> SP2 and I have not received any help. Unfortunatley I don't have a
> workaround for this one except to redesign. This is very aggravating as I
> had to go in to a number of reports to fix once this SP was applied. It was
> the only way I could combine bold font with normal and now that does not work
> either.
> I will continue my search, if I found I will update this post, please do the
> same.
> "Kevin Weir" wrote:
> > Hello
> >
> > We are currently generating reports in PDF format and leading spaces are now
> > being stripped from printed reports. This started to happen when when we
> > applied SP2. Has anyone else encountered this problem and if so how did you
> > get around it.
> >
> > Much appreciated,
> >
> > Kevin Weir
> > DirectWest Publishers
> >
We are currently generating reports in PDF format and leading spaces are now
being stripped from printed reports. This started to happen when when we
applied SP2. Has anyone else encountered this problem and if so how did you
get around it.
Much appreciated,
Kevin Weir
DirectWest PublishersI'm a little surprised no one has had a similar problem. Leading spaces are
definetly stripped from ALL strings when rendering to PDF. This started to
happen after SP2 was installed.
If someone from Microsoft sees this post are you aware this is an actual bug.
Regards
Kevin Weir
DirectWest Publishers
"Kevin Weir" wrote:
> Hello
> We are currently generating reports in PDF format and leading spaces are now
> being stripped from printed reports. This started to happen when when we
> applied SP2. Has anyone else encountered this problem and if so how did you
> get around it.
> Much appreciated,
> Kevin Weir
> DirectWest Publishers
>|||Kevin,
I have experienced the same thing, I posted a few oddities after applying
SP2 and I have not received any help. Unfortunatley I don't have a
workaround for this one except to redesign. This is very aggravating as I
had to go in to a number of reports to fix once this SP was applied. It was
the only way I could combine bold font with normal and now that does not work
either.
I will continue my search, if I found I will update this post, please do the
same.
"Kevin Weir" wrote:
> Hello
> We are currently generating reports in PDF format and leading spaces are now
> being stripped from printed reports. This started to happen when when we
> applied SP2. Has anyone else encountered this problem and if so how did you
> get around it.
> Much appreciated,
> Kevin Weir
> DirectWest Publishers
>|||Hello
I will certainly let you know if I find a solution.
Now if I could just find link/e-mail address where I could let Microsoft
know about this bug.
"DigitalVixen" wrote:
> Kevin,
> I have experienced the same thing, I posted a few oddities after applying
> SP2 and I have not received any help. Unfortunatley I don't have a
> workaround for this one except to redesign. This is very aggravating as I
> had to go in to a number of reports to fix once this SP was applied. It was
> the only way I could combine bold font with normal and now that does not work
> either.
> I will continue my search, if I found I will update this post, please do the
> same.
> "Kevin Weir" wrote:
> > Hello
> >
> > We are currently generating reports in PDF format and leading spaces are now
> > being stripped from printed reports. This started to happen when when we
> > applied SP2. Has anyone else encountered this problem and if so how did you
> > get around it.
> >
> > Much appreciated,
> >
> > Kevin Weir
> > DirectWest Publishers
> >
Friday, February 24, 2012
Browser Role - Deletes
I'm trying to restrict my users from being able to delete or move any of the
reports. Using the Browser Role ( View Folders, View Reports ) still
allows them to get to the "Show Details" page with full access to delete my
reports. What am I missing?
TIA
TinaThe Show Details will still show the check box to delete the report. But
the user does not have permissions to do it and will receive an error. If
this is not the case, please let me know.
Make sure you apply permissions at the folder level as well.
| From: "Tina Smith" <tb.smith@.earthlink.net>
| Subject: Browser Role - Deletes
| Date: Tue, 18 Jan 2005 11:31:20 -0500
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <O1QclsX$EHA.2076@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: user-10ibco9.biz.mindspring.com 65.37.179.9
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40126
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm trying to restrict my users from being able to delete or move any of
the
| reports. Using the Browser Role ( View Folders, View Reports ) still
| allows them to get to the "Show Details" page with full access to delete
my
| reports. What am I missing?
|
| TIA
| Tina
|
|
||||Yes, they do receive an error stating they don't have the permissions.
I'd rather not show them the option to delete the reports when they don't
have the permissions to. Is there anyway to eliminate the "ShowDetails"
for the browser role?
Thanks
Tina
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:tR6$y7X$EHA.3360@.cpmsftngxa10.phx.gbl...
> The Show Details will still show the check box to delete the report. But
> the user does not have permissions to do it and will receive an error. If
> this is not the case, please let me know.
> Make sure you apply permissions at the folder level as well.
>
> --
> | From: "Tina Smith" <tb.smith@.earthlink.net>
> | Subject: Browser Role - Deletes
> | Date: Tue, 18 Jan 2005 11:31:20 -0500
> | Lines: 9
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> | Message-ID: <O1QclsX$EHA.2076@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: user-10ibco9.biz.mindspring.com 65.37.179.9
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40126
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I'm trying to restrict my users from being able to delete or move any of
> the
> | reports. Using the Browser Role ( View Folders, View Reports ) still
> | allows them to get to the "Show Details" page with full access to delete
> my
> | reports. What am I missing?
> |
> | TIA
> | Tina
> |
> |
> |
>
reports. Using the Browser Role ( View Folders, View Reports ) still
allows them to get to the "Show Details" page with full access to delete my
reports. What am I missing?
TIA
TinaThe Show Details will still show the check box to delete the report. But
the user does not have permissions to do it and will receive an error. If
this is not the case, please let me know.
Make sure you apply permissions at the folder level as well.
| From: "Tina Smith" <tb.smith@.earthlink.net>
| Subject: Browser Role - Deletes
| Date: Tue, 18 Jan 2005 11:31:20 -0500
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <O1QclsX$EHA.2076@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: user-10ibco9.biz.mindspring.com 65.37.179.9
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40126
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm trying to restrict my users from being able to delete or move any of
the
| reports. Using the Browser Role ( View Folders, View Reports ) still
| allows them to get to the "Show Details" page with full access to delete
my
| reports. What am I missing?
|
| TIA
| Tina
|
|
||||Yes, they do receive an error stating they don't have the permissions.
I'd rather not show them the option to delete the reports when they don't
have the permissions to. Is there anyway to eliminate the "ShowDetails"
for the browser role?
Thanks
Tina
""Brad Syputa - MS"" <bradsy@.Online.Microsoft.com> wrote in message
news:tR6$y7X$EHA.3360@.cpmsftngxa10.phx.gbl...
> The Show Details will still show the check box to delete the report. But
> the user does not have permissions to do it and will receive an error. If
> this is not the case, please let me know.
> Make sure you apply permissions at the folder level as well.
>
> --
> | From: "Tina Smith" <tb.smith@.earthlink.net>
> | Subject: Browser Role - Deletes
> | Date: Tue, 18 Jan 2005 11:31:20 -0500
> | Lines: 9
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> | Message-ID: <O1QclsX$EHA.2076@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: user-10ibco9.biz.mindspring.com 65.37.179.9
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40126
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I'm trying to restrict my users from being able to delete or move any of
> the
> | reports. Using the Browser Role ( View Folders, View Reports ) still
> | allows them to get to the "Show Details" page with full access to delete
> my
> | reports. What am I missing?
> |
> | TIA
> | Tina
> |
> |
> |
>
Browser realignment
Howdy all,
I was curious, we have built a reporting services backend for DotNetNuke which displays reports in an IFRAME, but as you drill through the report the browser and iframe realign down to the top of the item clicked, here i show you,... This is before i click on a toggle item,...
Everything seems normal, browser and iframe all at the top,...
Then, as you can see the browser needlessly dives down the page, and the report rolls down as well,
Anyone know of a remedy for this, is there a property which can be set in RS or is it all in my frame configuration??
It is annoying enough for me to scroll back up, so i know the customer wont be jazzed about it either.
I thank in advance anyone for their help,...
This link may also help as well - From DNN
http://forums.asp.net/search/SearchResults.aspx?q=IFrame%20&f=OTA=&u=
Best Regards,
Joe
I was curious, we have built a reporting services backend for DotNetNuke which displays reports in an IFRAME, but as you drill through the report the browser and iframe realign down to the top of the item clicked, here i show you,... This is before i click on a toggle item,...
Everything seems normal, browser and iframe all at the top,...
Then, as you can see the browser needlessly dives down the page, and the report rolls down as well,
Anyone know of a remedy for this, is there a property which can be set in RS or is it all in my frame configuration??
It is annoying enough for me to scroll back up, so i know the customer wont be jazzed about it either.
I thank in advance anyone for their help,...
Good Morning:
There may be a number of issues (postback's, IIS, etc.) and I have deployed DNN in a similar way to your above example. This "thread" from the DNN forum may lead you in a direction that may help.
http://forums.asp.net/781505/ShowPost.aspx - Persistent Scrolling!
Best Reagrds,
Joe
This link may also help as well - From DNN
http://forums.asp.net/search/SearchResults.aspx?q=IFrame%20&f=OTA=&u=
Best Regards,
Joe
browse to reports
Hi,
I have created reports on my local machine as a test.
I can view the reports fine but others can not browse to these reports on my
machine.
I am not using any code, just the front end report creating of reporting
services in Visual studio .net
How can I allow other to view these reports on my machine.
ThanksHi,
Surf to http://servername/reports, click on the properties-tab and add the
users you want to give access.
hth,
Pieter
"Farsh" <Farsh@.discussions.microsoft.com> wrote in message
news:1D124954-0038-4726-8BAC-CDBE70EC6F38@.microsoft.com...
> Hi,
> I have created reports on my local machine as a test.
> I can view the reports fine but others can not browse to these reports on
> my
> machine.
> I am not using any code, just the front end report creating of reporting
> services in Visual studio .net
> How can I allow other to view these reports on my machine.
> Thanks|||first of all u should tell whats the error ppl r getting when they r
trying to access ur report so that it could properly b pointed out n
rectified as per my understanding i believe this would b RSACCESSDENIED
error n u ve to add users login to PERMIT through REPORT MANAGER check
security features/tab in report manager
hope it ll answer|||Thanks
"Pieter van Maasdam" wrote:
> Hi,
> Surf to http://servername/reports, click on the properties-tab and add the
> users you want to give access.
> hth,
> Pieter
> "Farsh" <Farsh@.discussions.microsoft.com> wrote in message
> news:1D124954-0038-4726-8BAC-CDBE70EC6F38@.microsoft.com...
> > Hi,
> > I have created reports on my local machine as a test.
> > I can view the reports fine but others can not browse to these reports on
> > my
> > machine.
> > I am not using any code, just the front end report creating of reporting
> > services in Visual studio .net
> >
> > How can I allow other to view these reports on my machine.
> > Thanks
>
>
I have created reports on my local machine as a test.
I can view the reports fine but others can not browse to these reports on my
machine.
I am not using any code, just the front end report creating of reporting
services in Visual studio .net
How can I allow other to view these reports on my machine.
ThanksHi,
Surf to http://servername/reports, click on the properties-tab and add the
users you want to give access.
hth,
Pieter
"Farsh" <Farsh@.discussions.microsoft.com> wrote in message
news:1D124954-0038-4726-8BAC-CDBE70EC6F38@.microsoft.com...
> Hi,
> I have created reports on my local machine as a test.
> I can view the reports fine but others can not browse to these reports on
> my
> machine.
> I am not using any code, just the front end report creating of reporting
> services in Visual studio .net
> How can I allow other to view these reports on my machine.
> Thanks|||first of all u should tell whats the error ppl r getting when they r
trying to access ur report so that it could properly b pointed out n
rectified as per my understanding i believe this would b RSACCESSDENIED
error n u ve to add users login to PERMIT through REPORT MANAGER check
security features/tab in report manager
hope it ll answer|||Thanks
"Pieter van Maasdam" wrote:
> Hi,
> Surf to http://servername/reports, click on the properties-tab and add the
> users you want to give access.
> hth,
> Pieter
> "Farsh" <Farsh@.discussions.microsoft.com> wrote in message
> news:1D124954-0038-4726-8BAC-CDBE70EC6F38@.microsoft.com...
> > Hi,
> > I have created reports on my local machine as a test.
> > I can view the reports fine but others can not browse to these reports on
> > my
> > machine.
> > I am not using any code, just the front end report creating of reporting
> > services in Visual studio .net
> >
> > How can I allow other to view these reports on my machine.
> > Thanks
>
>
Sunday, February 19, 2012
broken links when using https://
Hi,
My reports are hosted on a secure website (SSL). Most of the pages
appear just fine, but the 4 links in the top-right corner of the screen
("Home", "My Subscriptions", "Site Settings", "Help") are broken as
they are referring to pages using http:// when of course they should be
using https://
For example, the HTML for the "My Subscriptions" link looks like this:
<a
href="http://links.10026.com/?link=http://dub-mis-001/Reports/Pages/Subscriptions.aspx">My Subscriptions</a>
But it should look like this:
<a
href="http://links.10026.com/?link=https://dub-mis-001/Reports/Pages/Subscriptions.aspx">My Subscriptions</a>
I'm aware that this porblem has been mentioned a number of times
previously in this group, but nobody seems to have a solution?
Is there way I can "change" the HTML that is generated so that the
links use https:// or relative addressing?
Best Wishes,
DonAlternatively, is there any way to remove these links?
Cheers,
Don
My reports are hosted on a secure website (SSL). Most of the pages
appear just fine, but the 4 links in the top-right corner of the screen
("Home", "My Subscriptions", "Site Settings", "Help") are broken as
they are referring to pages using http:// when of course they should be
using https://
For example, the HTML for the "My Subscriptions" link looks like this:
<a
href="http://links.10026.com/?link=http://dub-mis-001/Reports/Pages/Subscriptions.aspx">My Subscriptions</a>
But it should look like this:
<a
href="http://links.10026.com/?link=https://dub-mis-001/Reports/Pages/Subscriptions.aspx">My Subscriptions</a>
I'm aware that this porblem has been mentioned a number of times
previously in this group, but nobody seems to have a solution?
Is there way I can "change" the HTML that is generated so that the
links use https:// or relative addressing?
Best Wishes,
DonAlternatively, is there any way to remove these links?
Cheers,
Don
Broken link in e-mail subscription
I have scheduled the first report at this customers site to send out e-mails
of reports. It is sending out the report just fine and including the PDF
file that I requested however I also checked the Include Link box in the
schedule because of the requirements of the users wanting to hide details in
the e-mailed report and wanting to link to the report and then drill down to
see the details only when necessary.
When the e-mail is sent it doesn't formulate the URL correctly and says the
following:
The report is accessible at the following address:
http://localhost/reports?%2fAccounting%.........
The closest thing I've found online to resolve this was this link:
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm
-- See "Incomplete Report Server Configuration on an SSL-Protected Server
Causes Broken Report Links in Report Server E-Mail Notifications" section.
Unfortunately, an examination of the suggestion revealed that we are not
using SSL and when I checked the <UrlRoot> in the RSReportServer.config file
it was set correctly to the server name that I'd want used in replacing
localhost in the URL.
Does anyone know how to fix this?You'll actually need to modify the rswebapplication.config file for that
setting.
The section should look like the following to get your issue resolved:
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> I have scheduled the first report at this customers site to send out
e-mails
> of reports. It is sending out the report just fine and including the PDF
> file that I requested however I also checked the Include Link box in the
> schedule because of the requirements of the users wanting to hide details
in
> the e-mailed report and wanting to link to the report and then drill down
to
> see the details only when necessary.
> When the e-mail is sent it doesn't formulate the URL correctly and says
the
> following:
> The report is accessible at the following address:
> http://localhost/reports?%2fAccounting%.........
> The closest thing I've found online to resolve this was this link:
>
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
25641/ReadmeSQL2005.htm
> -- See "Incomplete Report Server Configuration on an SSL-Protected
Server
> Causes Broken Report Links in Report Server E-Mail Notifications" section.
> Unfortunately, an examination of the suggestion revealed that we are not
> using SSL and when I checked the <UrlRoot> in the RSReportServer.config
file
> it was set correctly to the server name that I'd want used in replacing
> localhost in the URL.
> Does anyone know how to fix this?
>|||Thanks for the quick reply!
That didn't work; the e-mailed report still says localhost. Does it require
a reboot of the server or the service?
I changed two files named rswebapplication.config located here on the server:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
and
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
Any ideas?
Thanks,
Keith
"Chris Alton [MSFT]" wrote:
> You'll actually need to modify the rswebapplication.config file for that
> setting.
> The section should look like the following to get your issue resolved:
> <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> >
> > I have scheduled the first report at this customers site to send out
> e-mails
> > of reports. It is sending out the report just fine and including the PDF
> > file that I requested however I also checked the Include Link box in the
> > schedule because of the requirements of the users wanting to hide details
> in
> > the e-mailed report and wanting to link to the report and then drill down
> to
> > see the details only when necessary.
> >
> > When the e-mail is sent it doesn't formulate the URL correctly and says
> the
> > following:
> >
> > The report is accessible at the following address:
> > http://localhost/reports?%2fAccounting%.........
> >
> > The closest thing I've found online to resolve this was this link:
> >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> 25641/ReadmeSQL2005.htm
> > -- See "Incomplete Report Server Configuration on an SSL-Protected
> Server
> > Causes Broken Report Links in Report Server E-Mail Notifications" section.
> >
> > Unfortunately, an examination of the suggestion revealed that we are not
> > using SSL and when I checked the <UrlRoot> in the RSReportServer.config
> file
> > it was set correctly to the server name that I'd want used in replacing
> > localhost in the URL.
> >
> > Does anyone know how to fix this?
> >
> >
>|||If you have two instances of Reporting Services installed then you need to
figure out which instance you are connecting to and modify the correct
configuration files. Also, if you modified the rsreportserver.config file
for the wrong instance then that could have caused it as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> X-WBNR-Posting-Host: 64.4.185.178
> From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
<8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Broken link in e-mail subscription
> Thanks for the quick reply!
> That didn't work; the e-mailed report still says localhost. Does it
require
> a reboot of the server or the service?
> I changed two files named rswebapplication.config located here on the
server:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager
> and
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager
> Any ideas?
> Thanks,
> Keith
>
> "Chris Alton [MSFT]" wrote:
> > You'll actually need to modify the rswebapplication.config file for
that
> > setting.
> >
> > The section should look like the following to get your issue resolved:
> > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > >
> > > I have scheduled the first report at this customers site to send out
> > e-mails
> > > of reports. It is sending out the report just fine and including the
PDF
> > > file that I requested however I also checked the Include Link box in
the
> > > schedule because of the requirements of the users wanting to hide
details
> > in
> > > the e-mailed report and wanting to link to the report and then drill
down
> > to
> > > see the details only when necessary.
> > >
> > > When the e-mail is sent it doesn't formulate the URL correctly and
says
> > the
> > > following:
> > >
> > > The report is accessible at the following address:
> > > http://localhost/reports?%2fAccounting%.........
> > >
> > > The closest thing I've found online to resolve this was this link:
> > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > 25641/ReadmeSQL2005.htm
> > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > Server
> > > Causes Broken Report Links in Report Server E-Mail Notifications"
section.
> > >
> > > Unfortunately, an examination of the suggestion revealed that we are
not
> > > using SSL and when I checked the <UrlRoot> in the
RSReportServer.config
> > file
> > > it was set correctly to the server name that I'd want used in
replacing
> > > localhost in the URL.
> > >
> > > Does anyone know how to fix this?
> > >
> > >
> >
> >
>|||Welp, I didn't know I had a second instance, but you were right! I have it
fixed.
One thing though, I couldn't google a fix to this problem. Perhaps there is
something that could be added to BOL? Or did I miss it?
"Chris Alton [MSFT]" wrote:
> If you have two instances of Reporting Services installed then you need to
> figure out which instance you are connecting to and modify the correct
> configuration files. Also, if you modified the rsreportserver.config file
> for the wrong instance then that could have caused it as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > X-WBNR-Posting-Host: 64.4.185.178
> > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Broken link in e-mail subscription
> >
> > Thanks for the quick reply!
> >
> > That didn't work; the e-mailed report still says localhost. Does it
> require
> > a reboot of the server or the service?
> >
> > I changed two files named rswebapplication.config located here on the
> server:
> > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager
> > and
> > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager
> >
> > Any ideas?
> >
> > Thanks,
> > Keith
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You'll actually need to modify the rswebapplication.config file for
> that
> > > setting.
> > >
> > > The section should look like the following to get your issue resolved:
> > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Broken link in e-mail subscription
> > > >
> > > > I have scheduled the first report at this customers site to send out
> > > e-mails
> > > > of reports. It is sending out the report just fine and including the
> PDF
> > > > file that I requested however I also checked the Include Link box in
> the
> > > > schedule because of the requirements of the users wanting to hide
> details
> > > in
> > > > the e-mailed report and wanting to link to the report and then drill
> down
> > > to
> > > > see the details only when necessary.
> > > >
> > > > When the e-mail is sent it doesn't formulate the URL correctly and
> says
> > > the
> > > > following:
> > > >
> > > > The report is accessible at the following address:
> > > > http://localhost/reports?%2fAccounting%.........
> > > >
> > > > The closest thing I've found online to resolve this was this link:
> > > >
> > >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > 25641/ReadmeSQL2005.htm
> > > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > > Server
> > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> section.
> > > >
> > > > Unfortunately, an examination of the suggestion revealed that we are
> not
> > > > using SSL and when I checked the <UrlRoot> in the
> RSReportServer.config
> > > file
> > > > it was set correctly to the server name that I'd want used in
> replacing
> > > > localhost in the URL.
> > > >
> > > > Does anyone know how to fix this?
> > > >
> > > >
> > >
> > >
> >
>|||I'm sure its in Books Online somewhere. It has to get the link for the
report from somewhere and if it is configured as localhost in all the
configuration files then its going to use localhost.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> Welp, I didn't know I had a second instance, but you were right! I have
it
> fixed.
> One thing though, I couldn't google a fix to this problem. Perhaps there
is
> something that could be added to BOL? Or did I miss it?
> "Chris Alton [MSFT]" wrote:
> > If you have two instances of Reporting Services installed then you need
to
> > figure out which instance you are connecting to and modify the correct
> > configuration files. Also, if you modified the rsreportserver.config
file
> > for the wrong instance then that could have caused it as well.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > > X-WBNR-Posting-Host: 64.4.185.178
> > > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?=<greenmtnsun@.discussions.microsoft.com>
> > > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> > <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: Broken link in e-mail subscription
> > >
> > > Thanks for the quick reply!
> > >
> > > That didn't work; the e-mailed report still says localhost. Does it
> > require
> > > a reboot of the server or the service?
> > >
> > > I changed two files named rswebapplication.config located here on the
> > server:
> > > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> > Services\ReportManager
> > > and
> > > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportManager
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You'll actually need to modify the rswebapplication.config file for
> > that
> > > > setting.
> > > >
> > > > The section should look like the following to get your issue
resolved:
> > > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: Broken link in e-mail subscription
> > > > >
> > > > > I have scheduled the first report at this customers site to send
out
> > > > e-mails
> > > > > of reports. It is sending out the report just fine and including
the
> > PDF
> > > > > file that I requested however I also checked the Include Link box
in
> > the
> > > > > schedule because of the requirements of the users wanting to hide
> > details
> > > > in
> > > > > the e-mailed report and wanting to link to the report and then
drill
> > down
> > > > to
> > > > > see the details only when necessary.
> > > > >
> > > > > When the e-mail is sent it doesn't formulate the URL correctly
and
> > says
> > > > the
> > > > > following:
> > > > >
> > > > > The report is accessible at the following address:
> > > > > http://localhost/reports?%2fAccounting%.........
> > > > >
> > > > > The closest thing I've found online to resolve this was this link:
> > > > >
> > > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > > 25641/ReadmeSQL2005.htm
> > > > > -- See "Incomplete Report Server Configuration on an
SSL-Protected
> > > > Server
> > > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> > section.
> > > > >
> > > > > Unfortunately, an examination of the suggestion revealed that we
are
> > not
> > > > > using SSL and when I checked the <UrlRoot> in the
> > RSReportServer.config
> > > > file
> > > > > it was set correctly to the server name that I'd want used in
> > replacing
> > > > > localhost in the URL.
> > > > >
> > > > > Does anyone know how to fix this?
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
of reports. It is sending out the report just fine and including the PDF
file that I requested however I also checked the Include Link box in the
schedule because of the requirements of the users wanting to hide details in
the e-mailed report and wanting to link to the report and then drill down to
see the details only when necessary.
When the e-mail is sent it doesn't formulate the URL correctly and says the
following:
The report is accessible at the following address:
http://localhost/reports?%2fAccounting%.........
The closest thing I've found online to resolve this was this link:
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad125641/ReadmeSQL2005.htm
-- See "Incomplete Report Server Configuration on an SSL-Protected Server
Causes Broken Report Links in Report Server E-Mail Notifications" section.
Unfortunately, an examination of the suggestion revealed that we are not
using SSL and when I checked the <UrlRoot> in the RSReportServer.config file
it was set correctly to the server name that I'd want used in replacing
localhost in the URL.
Does anyone know how to fix this?You'll actually need to modify the rswebapplication.config file for that
setting.
The section should look like the following to get your issue resolved:
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> I have scheduled the first report at this customers site to send out
e-mails
> of reports. It is sending out the report just fine and including the PDF
> file that I requested however I also checked the Include Link box in the
> schedule because of the requirements of the users wanting to hide details
in
> the e-mailed report and wanting to link to the report and then drill down
to
> see the details only when necessary.
> When the e-mail is sent it doesn't formulate the URL correctly and says
the
> following:
> The report is accessible at the following address:
> http://localhost/reports?%2fAccounting%.........
> The closest thing I've found online to resolve this was this link:
>
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
25641/ReadmeSQL2005.htm
> -- See "Incomplete Report Server Configuration on an SSL-Protected
Server
> Causes Broken Report Links in Report Server E-Mail Notifications" section.
> Unfortunately, an examination of the suggestion revealed that we are not
> using SSL and when I checked the <UrlRoot> in the RSReportServer.config
file
> it was set correctly to the server name that I'd want used in replacing
> localhost in the URL.
> Does anyone know how to fix this?
>|||Thanks for the quick reply!
That didn't work; the e-mailed report still says localhost. Does it require
a reboot of the server or the service?
I changed two files named rswebapplication.config located here on the server:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
and
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
Any ideas?
Thanks,
Keith
"Chris Alton [MSFT]" wrote:
> You'll actually need to modify the rswebapplication.config file for that
> setting.
> The section should look like the following to get your issue resolved:
> <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> >
> > I have scheduled the first report at this customers site to send out
> e-mails
> > of reports. It is sending out the report just fine and including the PDF
> > file that I requested however I also checked the Include Link box in the
> > schedule because of the requirements of the users wanting to hide details
> in
> > the e-mailed report and wanting to link to the report and then drill down
> to
> > see the details only when necessary.
> >
> > When the e-mail is sent it doesn't formulate the URL correctly and says
> the
> > following:
> >
> > The report is accessible at the following address:
> > http://localhost/reports?%2fAccounting%.........
> >
> > The closest thing I've found online to resolve this was this link:
> >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> 25641/ReadmeSQL2005.htm
> > -- See "Incomplete Report Server Configuration on an SSL-Protected
> Server
> > Causes Broken Report Links in Report Server E-Mail Notifications" section.
> >
> > Unfortunately, an examination of the suggestion revealed that we are not
> > using SSL and when I checked the <UrlRoot> in the RSReportServer.config
> file
> > it was set correctly to the server name that I'd want used in replacing
> > localhost in the URL.
> >
> > Does anyone know how to fix this?
> >
> >
>|||If you have two instances of Reporting Services installed then you need to
figure out which instance you are connecting to and modify the correct
configuration files. Also, if you modified the rsreportserver.config file
for the wrong instance then that could have caused it as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> X-WBNR-Posting-Host: 64.4.185.178
> From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
<8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Broken link in e-mail subscription
> Thanks for the quick reply!
> That didn't work; the e-mailed report still says localhost. Does it
require
> a reboot of the server or the service?
> I changed two files named rswebapplication.config located here on the
server:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager
> and
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager
> Any ideas?
> Thanks,
> Keith
>
> "Chris Alton [MSFT]" wrote:
> > You'll actually need to modify the rswebapplication.config file for
that
> > setting.
> >
> > The section should look like the following to get your issue resolved:
> > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > >
> > > I have scheduled the first report at this customers site to send out
> > e-mails
> > > of reports. It is sending out the report just fine and including the
> > > file that I requested however I also checked the Include Link box in
the
> > > schedule because of the requirements of the users wanting to hide
details
> > in
> > > the e-mailed report and wanting to link to the report and then drill
down
> > to
> > > see the details only when necessary.
> > >
> > > When the e-mail is sent it doesn't formulate the URL correctly and
says
> > the
> > > following:
> > >
> > > The report is accessible at the following address:
> > > http://localhost/reports?%2fAccounting%.........
> > >
> > > The closest thing I've found online to resolve this was this link:
> > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > 25641/ReadmeSQL2005.htm
> > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > Server
> > > Causes Broken Report Links in Report Server E-Mail Notifications"
section.
> > >
> > > Unfortunately, an examination of the suggestion revealed that we are
not
> > > using SSL and when I checked the <UrlRoot> in the
RSReportServer.config
> > file
> > > it was set correctly to the server name that I'd want used in
replacing
> > > localhost in the URL.
> > >
> > > Does anyone know how to fix this?
> > >
> > >
> >
> >
>|||Welp, I didn't know I had a second instance, but you were right! I have it
fixed.
One thing though, I couldn't google a fix to this problem. Perhaps there is
something that could be added to BOL? Or did I miss it?
"Chris Alton [MSFT]" wrote:
> If you have two instances of Reporting Services installed then you need to
> figure out which instance you are connecting to and modify the correct
> configuration files. Also, if you modified the rsreportserver.config file
> for the wrong instance then that could have caused it as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Broken link in e-mail subscription
> > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > X-WBNR-Posting-Host: 64.4.185.178
> > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?= <greenmtnsun@.discussions.microsoft.com>
> > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Broken link in e-mail subscription
> >
> > Thanks for the quick reply!
> >
> > That didn't work; the e-mailed report still says localhost. Does it
> require
> > a reboot of the server or the service?
> >
> > I changed two files named rswebapplication.config located here on the
> server:
> > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportManager
> > and
> > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager
> >
> > Any ideas?
> >
> > Thanks,
> > Keith
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You'll actually need to modify the rswebapplication.config file for
> that
> > > setting.
> > >
> > > The section should look like the following to get your issue resolved:
> > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Broken link in e-mail subscription
> > > >
> > > > I have scheduled the first report at this customers site to send out
> > > e-mails
> > > > of reports. It is sending out the report just fine and including the
> > > > file that I requested however I also checked the Include Link box in
> the
> > > > schedule because of the requirements of the users wanting to hide
> details
> > > in
> > > > the e-mailed report and wanting to link to the report and then drill
> down
> > > to
> > > > see the details only when necessary.
> > > >
> > > > When the e-mail is sent it doesn't formulate the URL correctly and
> says
> > > the
> > > > following:
> > > >
> > > > The report is accessible at the following address:
> > > > http://localhost/reports?%2fAccounting%.........
> > > >
> > > > The closest thing I've found online to resolve this was this link:
> > > >
> > >
> http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > 25641/ReadmeSQL2005.htm
> > > > -- See "Incomplete Report Server Configuration on an SSL-Protected
> > > Server
> > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> section.
> > > >
> > > > Unfortunately, an examination of the suggestion revealed that we are
> not
> > > > using SSL and when I checked the <UrlRoot> in the
> RSReportServer.config
> > > file
> > > > it was set correctly to the server name that I'd want used in
> replacing
> > > > localhost in the URL.
> > > >
> > > > Does anyone know how to fix this?
> > > >
> > > >
> > >
> > >
> >
>|||I'm sure its in Books Online somewhere. It has to get the link for the
report from somewhere and if it is configured as localhost in all the
configuration files then its going to use localhost.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Broken link in e-mail subscription
> Welp, I didn't know I had a second instance, but you were right! I have
it
> fixed.
> One thing though, I couldn't google a fix to this problem. Perhaps there
is
> something that could be added to BOL? Or did I miss it?
> "Chris Alton [MSFT]" wrote:
> > If you have two instances of Reporting Services installed then you need
to
> > figure out which instance you are connecting to and modify the correct
> > configuration files. Also, if you modified the rsreportserver.config
file
> > for the wrong instance then that could have caused it as well.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Broken link in e-mail subscription
> > > thread-index: AcgKl6UBYx8q8qj4SQiu7zquybnHhQ==> > > X-WBNR-Posting-Host: 64.4.185.178
> > > From: =?Utf-8?B?Z3JlZW5tdG5zdW4=?=<greenmtnsun@.discussions.microsoft.com>
> > > References: <F510629C-E0E1-4162-9845-87980E21B924@.microsoft.com>
> > <8SY8AQpCIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: Broken link in e-mail subscription
> > >
> > > Thanks for the quick reply!
> > >
> > > That didn't work; the e-mailed report still says localhost. Does it
> > require
> > > a reboot of the server or the service?
> > >
> > > I changed two files named rswebapplication.config located here on the
> > server:
> > > C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> > Services\ReportManager
> > > and
> > > C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportManager
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You'll actually need to modify the rswebapplication.config file for
> > that
> > > > setting.
> > > >
> > > > The section should look like the following to get your issue
resolved:
> > > > <ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
> > > > <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: Broken link in e-mail subscription
> > > > >
> > > > > I have scheduled the first report at this customers site to send
out
> > > > e-mails
> > > > > of reports. It is sending out the report just fine and including
the
> > > > > file that I requested however I also checked the Include Link box
in
> > the
> > > > > schedule because of the requirements of the users wanting to hide
> > details
> > > > in
> > > > > the e-mailed report and wanting to link to the report and then
drill
> > down
> > > > to
> > > > > see the details only when necessary.
> > > > >
> > > > > When the e-mail is sent it doesn't formulate the URL correctly
and
> > says
> > > > the
> > > > > following:
> > > > >
> > > > > The report is accessible at the following address:
> > > > > http://localhost/reports?%2fAccounting%.........
> > > > >
> > > > > The closest thing I've found online to resolve this was this link:
> > > > >
> > > >
> >
http://download.microsoft.com/download/5/0/e/50ec0a69-d69e-4962-b2c9-80bbad1
> > > > 25641/ReadmeSQL2005.htm
> > > > > -- See "Incomplete Report Server Configuration on an
SSL-Protected
> > > > Server
> > > > > Causes Broken Report Links in Report Server E-Mail Notifications"
> > section.
> > > > >
> > > > > Unfortunately, an examination of the suggestion revealed that we
are
> > not
> > > > > using SSL and when I checked the <UrlRoot> in the
> > RSReportServer.config
> > > > file
> > > > > it was set correctly to the server name that I'd want used in
> > replacing
> > > > > localhost in the URL.
> > > > >
> > > > > Does anyone know how to fix this?
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>
Broken Images and Charts in Deployed Reports
Hi all,
Does anyone know why on some installations of RS, using the Reports Viewer
(http://localhost/Reports/), all images and charts appear to be broken, but
if exported, work fine. Using ReportServer works, but its not very
user-friendly for our clients.
I only read a couple of posts about this issue, but couldnt find an answer.
Some people said that if you enable Allow All Cookie's in IE, it works... but
why then is this problem only occuring on some installations of RS?
The one major differance I can point out is that it seams that broken images
only occur on Servers (Win2003) but not on development (XP) computers... Is
this as simple as an IIS issue, or security perhaps?
Please help! I'm sure there are many others with the same issue!
Thanks,
AndreAnswer is simple, and stupid...
IE does block the cookies from the RS website for some reason.
There are two fixes I know.
1) Inform anyone using RS to find the security icon at the bottom of IE and
right click it and allow Cookies from that site.
2) Inform anyone using RS to go to IE security and turn of automatic
handling of cookies and allow all cookies... I dont think this is quite hte
best idea though.
Andre
"Arkiliknam" wrote:
> Hi all,
> Does anyone know why on some installations of RS, using the Reports Viewer
> (http://localhost/Reports/), all images and charts appear to be broken, but
> if exported, work fine. Using ReportServer works, but its not very
> user-friendly for our clients.
> I only read a couple of posts about this issue, but couldnt find an answer.
> Some people said that if you enable Allow All Cookie's in IE, it works... but
> why then is this problem only occuring on some installations of RS?
> The one major differance I can point out is that it seams that broken images
> only occur on Servers (Win2003) but not on development (XP) computers... Is
> this as simple as an IIS issue, or security perhaps?
> Please help! I'm sure there are many others with the same issue!
> Thanks,
> Andre
Does anyone know why on some installations of RS, using the Reports Viewer
(http://localhost/Reports/), all images and charts appear to be broken, but
if exported, work fine. Using ReportServer works, but its not very
user-friendly for our clients.
I only read a couple of posts about this issue, but couldnt find an answer.
Some people said that if you enable Allow All Cookie's in IE, it works... but
why then is this problem only occuring on some installations of RS?
The one major differance I can point out is that it seams that broken images
only occur on Servers (Win2003) but not on development (XP) computers... Is
this as simple as an IIS issue, or security perhaps?
Please help! I'm sure there are many others with the same issue!
Thanks,
AndreAnswer is simple, and stupid...
IE does block the cookies from the RS website for some reason.
There are two fixes I know.
1) Inform anyone using RS to find the security icon at the bottom of IE and
right click it and allow Cookies from that site.
2) Inform anyone using RS to go to IE security and turn of automatic
handling of cookies and allow all cookies... I dont think this is quite hte
best idea though.
Andre
"Arkiliknam" wrote:
> Hi all,
> Does anyone know why on some installations of RS, using the Reports Viewer
> (http://localhost/Reports/), all images and charts appear to be broken, but
> if exported, work fine. Using ReportServer works, but its not very
> user-friendly for our clients.
> I only read a couple of posts about this issue, but couldnt find an answer.
> Some people said that if you enable Allow All Cookie's in IE, it works... but
> why then is this problem only occuring on some installations of RS?
> The one major differance I can point out is that it seams that broken images
> only occur on Servers (Win2003) but not on development (XP) computers... Is
> this as simple as an IIS issue, or security perhaps?
> Please help! I'm sure there are many others with the same issue!
> Thanks,
> Andre
Thursday, February 16, 2012
Brian Bischof's comparison between Crystal Reports and SQL Reporting Services
Could someone paste a link to a place where I could download the .pdf
comparison between Crystal Reports and SQL Reporting Services that was
done by Brian Bischof?
His web site seems to be down and I really need this to help make up
my mind.
Thanks in advance.
Jimis this the one?
http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
"LaceyLou" wrote:
> Could someone paste a link to a place where I could download the .pdf
> comparison between Crystal Reports and SQL Reporting Services that was
> done by Brian Bischof?
> His web site seems to be down and I really need this to help make up
> my mind.
> Thanks in advance.
> Jim
>|||Just to caveat this document, is it pretty biased towards CR to the point of
even misleading people about the reality of the differences between the two.
I cannot be sure if it is because of the writers lack of knowledge of SSRS
and in depth experience with CR, or what the issue might be.
However, I have 10 years of experience working with CR (since v 5) and about
a year with RS, so I am in the same situation, so if I can recognize how he
is misleading, he should be able to as well.
Jeff
"NH" wrote:
> is this the one?
> http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
> "LaceyLou" wrote:
> >
> > Could someone paste a link to a place where I could download the .pdf
> > comparison between Crystal Reports and SQL Reporting Services that was
> > done by Brian Bischof?
> >
> > His web site seems to be down and I really need this to help make up
> > my mind.
> >
> > Thanks in advance.
> >
> > Jim
> >|||"=?Utf-8?B?SmVmZiBBZ2VudA==?=" <Jeff Agent@.discussions.microsoft.com>
wrote in news:0ECDB56B-11A5-4C67-946B-106582B46012@.microsoft.com:
You right. I just read it. I almost choked when I saw his take on the
license fees. I'd say that most of us run RS on the same box. He then
quotes $7,500 for CR Server but neglects to say that it's for 5 users. 10
users will cost you $15,000, 20 will cost you $30,000.
Read the URL and think about the bias of the source.
> Just to caveat this document, is it pretty biased towards CR to the
> point of even misleading people about the reality of the differences
> between the two. I cannot be sure if it is because of the writers lack
> of knowledge of SSRS and in depth experience with CR, or what the
> issue might be.
> However, I have 10 years of experience working with CR (since v 5) and
> about a year with RS, so I am in the same situation, so if I can
> recognize how he is misleading, he should be able to as well.
> Jeff
>
> "NH" wrote:
>> is this the one?
>> http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
>> "LaceyLou" wrote:
>> >
>> > Could someone paste a link to a place where I could download the
>> > .pdf comparison between Crystal Reports and SQL Reporting Services
>> > that was done by Brian Bischof?
>> >
>> > His web site seems to be down and I really need this to help make
>> > up my mind.
>> >
>> > Thanks in advance.
>> >
>> > Jim
>> >
>
comparison between Crystal Reports and SQL Reporting Services that was
done by Brian Bischof?
His web site seems to be down and I really need this to help make up
my mind.
Thanks in advance.
Jimis this the one?
http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
"LaceyLou" wrote:
> Could someone paste a link to a place where I could download the .pdf
> comparison between Crystal Reports and SQL Reporting Services that was
> done by Brian Bischof?
> His web site seems to be down and I really need this to help make up
> my mind.
> Thanks in advance.
> Jim
>|||Just to caveat this document, is it pretty biased towards CR to the point of
even misleading people about the reality of the differences between the two.
I cannot be sure if it is because of the writers lack of knowledge of SSRS
and in depth experience with CR, or what the issue might be.
However, I have 10 years of experience working with CR (since v 5) and about
a year with RS, so I am in the same situation, so if I can recognize how he
is misleading, he should be able to as well.
Jeff
"NH" wrote:
> is this the one?
> http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
> "LaceyLou" wrote:
> >
> > Could someone paste a link to a place where I could download the .pdf
> > comparison between Crystal Reports and SQL Reporting Services that was
> > done by Brian Bischof?
> >
> > His web site seems to be down and I really need this to help make up
> > my mind.
> >
> > Thanks in advance.
> >
> > Jim
> >|||"=?Utf-8?B?SmVmZiBBZ2VudA==?=" <Jeff Agent@.discussions.microsoft.com>
wrote in news:0ECDB56B-11A5-4C67-946B-106582B46012@.microsoft.com:
You right. I just read it. I almost choked when I saw his take on the
license fees. I'd say that most of us run RS on the same box. He then
quotes $7,500 for CR Server but neglects to say that it's for 5 users. 10
users will cost you $15,000, 20 will cost you $30,000.
Read the URL and think about the bias of the source.
> Just to caveat this document, is it pretty biased towards CR to the
> point of even misleading people about the reality of the differences
> between the two. I cannot be sure if it is because of the writers lack
> of knowledge of SSRS and in depth experience with CR, or what the
> issue might be.
> However, I have 10 years of experience working with CR (since v 5) and
> about a year with RS, so I am in the same situation, so if I can
> recognize how he is misleading, he should be able to as well.
> Jeff
>
> "NH" wrote:
>> is this the one?
>> http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
>> "LaceyLou" wrote:
>> >
>> > Could someone paste a link to a place where I could download the
>> > .pdf comparison between Crystal Reports and SQL Reporting Services
>> > that was done by Brian Bischof?
>> >
>> > His web site seems to be down and I really need this to help make
>> > up my mind.
>> >
>> > Thanks in advance.
>> >
>> > Jim
>> >
>
Tuesday, February 14, 2012
Breaking of Sub Report?
Hi All,
I have created a Report that include 10 other sub reports. The problem is that if there is not enough space for that sub report on the page, it goes to the next page. Also, if the content of sub report is huge, it removes the page header details so that it can fit into one page.
Is there any way that the sub report breaks on its own and there is no wastage of space? I guess that will solve my problem of page header details as well.
If anyone has worked on such issue, please let me know.
Any help will be greatly appreciated.
TIA!!!
Hi,
Anyone has got any clue?
Regards!!!
Breaking a dataset into chunks
Hey everyone. I'm trying to recreate some Excel reports my company has
been issuing for the last few years using Reporting Services (data is
coming from an Analysis Services cube now). The reports display
information over a retail hierarchy. Here's what I'm trying to do for
one of them: On one report issued for every entity that has children,
there are five columns of space allotted for key measures on each of
the children (and the report needs to expand to the necessary number
of pages for all children to be displayed, up to five per page). Then,
immediately next to it on each page, the same information about the
current entity and its hierarchy parents must be put in on each page.
There would be up to four columns here. At first I tried fitting this
into two matrix controls, but I quickly realized that SSRS will
process the first matrix for all records in its dataset before getting
to the second one, forcing it to start displaying it no sooner than
the last page of the first matrix. If anyone knows a brilliant way to
allow two unlike-sized datasets to be used in two matrices that can
interrupt each other to get data onto a page, by all means let me know
(I'm not holding my breath for that one though).
This brings me to my actual question. The next solution we've come up
with, as much as we don't like it, is assuming a maximum of 25
children for any entity and creating five separate pages, each one
with a matrix that pulls in a maximum of five records. This of course
probably means five datasets, unless I can set up filtering to limit
which rows from the dataset are being used for each control. So, my
question is this: can anyone suggest a good way to either A) break the
dataset into chunks of <=5 records, or B) filter the each page's
control so that it only takes the appropriate <=5 records, without
redisplaying a record that was already displayed on a previous page?
Any help would be MUCH appreciated. Thanks!On Jan 22, 11:41=A0am, adam.schm...@.gmail.com wrote:
> If anyone knows a brilliant way to
> allow two unlike-sized datasets to be used in two matrices that can
> interrupt each other to get data onto a page, by all means let me know
> (I'm not holding my breath for that one though).
If I understand your problem, you could: Put each object into a
Rectangle object, then align the Rectangles to have the same Top edge,
and align the Right edge of the left rectangle to meet the Left edge
of the right rectangle.
> So, my
> question is this: can anyone suggest a good way to either A) break the
> dataset into chunks of <=3D5 records,
If your source data is a SQL Server, then try using the ROW_Number()
OVER ( ORDER BY FIELD ) function in the statement to generate row
numbers. Then, you can group by ( RowNumber - RowNumber Mod 5 ) to
create groups of 5.
> or B) filter the each page's
> control so that it only takes the appropriate <=3D5 records, without
> redisplaying a record that was already displayed on a previous page?
You could create a group as defined in (A), then put the Group in a
List object, then go to the List's properties and check the Page Break
at End. Then put all your display stuff inside the List. There are
probably other ways of doing this.
-- Scott|||Thanks Scott! I got as far as the two rectangles idea and it almost
worked -- there was only one problem. I need to have the same four
columns of information on each page in the right matrix, whereas the
left matrix just needs to expand to the size of the dataset. This is
so that for example a district manager could look at each attribute on
any page of five stores (from the left matrix) and compare it to his
entire district, his districts region, the rest of the stores in the
same brand division, and the entire company's performance (in the
right matrix). Again, five or less stores per page. Since these are
coming from different data sets, I'm having issues getting the two
data sets to repeat the same amount of times and getting the page
breaks to happen in the right places.
This provided a great jumping-off point for me, though, and I have a
hack solution that will work, although it's not great. The second
matrix can simply be replaced by four columns of textboxes, each one
displaying a specific data point. Instead of the "parents" dataset
containing up to four records, I'll need to use four datasets, each
containing up to one. Then the textboxes can display the first value
in each of those datasets for the appropriate field. Each column of
textboxes (or all four) can then be nested in a rectangle and the
rectangle can be set to repeat with the first matrix.
Obviously, this is labor-intensive, and kind of a pain, especially
given some of the formatting constraints that are going to come up.
So... if anyone knows a way to circumvent using 4 columns, 25 text
boxes each, that still allows me to set the RepeatWith property to the
left matrix, I'm all ears.
Thanks!
On Jan 22, 11:00 am, Orne <polysilly...@.yahoo.com> wrote:
> On Jan 22, 11:41 am, adam.schm...@.gmail.com wrote:
> > If anyone knows a brilliant way to
> > allow two unlike-sized datasets to be used in two matrices that can
> > interrupt each other to get data onto a page, by all means let me know
> > (I'm not holding my breath for that one though).
> If I understand your problem, you could: Put each object into a
> Rectangle object, then align the Rectangles to have the same Top edge,
> and align the Right edge of the left rectangle to meet the Left edge
> of the right rectangle.
> > So, my
> > question is this: can anyone suggest a good way to either A) break the
> > dataset into chunks of <=5 records,
> If your source data is a SQL Server, then try using the ROW_Number()
> OVER ( ORDER BY FIELD ) function in the statement to generate row
> numbers. Then, you can group by ( RowNumber - RowNumber Mod 5 ) to
> create groups of 5.
> > or B) filter the each page's
> > control so that it only takes the appropriate <=5 records, without
> > redisplaying a record that was already displayed on a previous page?
> You could create a group as defined in (A), then put the Group in a
> List object, then go to the List's properties and check the Page Break
> at End. Then put all your display stuff inside the List. There are
> probably other ways of doing this.
> -- Scott
been issuing for the last few years using Reporting Services (data is
coming from an Analysis Services cube now). The reports display
information over a retail hierarchy. Here's what I'm trying to do for
one of them: On one report issued for every entity that has children,
there are five columns of space allotted for key measures on each of
the children (and the report needs to expand to the necessary number
of pages for all children to be displayed, up to five per page). Then,
immediately next to it on each page, the same information about the
current entity and its hierarchy parents must be put in on each page.
There would be up to four columns here. At first I tried fitting this
into two matrix controls, but I quickly realized that SSRS will
process the first matrix for all records in its dataset before getting
to the second one, forcing it to start displaying it no sooner than
the last page of the first matrix. If anyone knows a brilliant way to
allow two unlike-sized datasets to be used in two matrices that can
interrupt each other to get data onto a page, by all means let me know
(I'm not holding my breath for that one though).
This brings me to my actual question. The next solution we've come up
with, as much as we don't like it, is assuming a maximum of 25
children for any entity and creating five separate pages, each one
with a matrix that pulls in a maximum of five records. This of course
probably means five datasets, unless I can set up filtering to limit
which rows from the dataset are being used for each control. So, my
question is this: can anyone suggest a good way to either A) break the
dataset into chunks of <=5 records, or B) filter the each page's
control so that it only takes the appropriate <=5 records, without
redisplaying a record that was already displayed on a previous page?
Any help would be MUCH appreciated. Thanks!On Jan 22, 11:41=A0am, adam.schm...@.gmail.com wrote:
> If anyone knows a brilliant way to
> allow two unlike-sized datasets to be used in two matrices that can
> interrupt each other to get data onto a page, by all means let me know
> (I'm not holding my breath for that one though).
If I understand your problem, you could: Put each object into a
Rectangle object, then align the Rectangles to have the same Top edge,
and align the Right edge of the left rectangle to meet the Left edge
of the right rectangle.
> So, my
> question is this: can anyone suggest a good way to either A) break the
> dataset into chunks of <=3D5 records,
If your source data is a SQL Server, then try using the ROW_Number()
OVER ( ORDER BY FIELD ) function in the statement to generate row
numbers. Then, you can group by ( RowNumber - RowNumber Mod 5 ) to
create groups of 5.
> or B) filter the each page's
> control so that it only takes the appropriate <=3D5 records, without
> redisplaying a record that was already displayed on a previous page?
You could create a group as defined in (A), then put the Group in a
List object, then go to the List's properties and check the Page Break
at End. Then put all your display stuff inside the List. There are
probably other ways of doing this.
-- Scott|||Thanks Scott! I got as far as the two rectangles idea and it almost
worked -- there was only one problem. I need to have the same four
columns of information on each page in the right matrix, whereas the
left matrix just needs to expand to the size of the dataset. This is
so that for example a district manager could look at each attribute on
any page of five stores (from the left matrix) and compare it to his
entire district, his districts region, the rest of the stores in the
same brand division, and the entire company's performance (in the
right matrix). Again, five or less stores per page. Since these are
coming from different data sets, I'm having issues getting the two
data sets to repeat the same amount of times and getting the page
breaks to happen in the right places.
This provided a great jumping-off point for me, though, and I have a
hack solution that will work, although it's not great. The second
matrix can simply be replaced by four columns of textboxes, each one
displaying a specific data point. Instead of the "parents" dataset
containing up to four records, I'll need to use four datasets, each
containing up to one. Then the textboxes can display the first value
in each of those datasets for the appropriate field. Each column of
textboxes (or all four) can then be nested in a rectangle and the
rectangle can be set to repeat with the first matrix.
Obviously, this is labor-intensive, and kind of a pain, especially
given some of the formatting constraints that are going to come up.
So... if anyone knows a way to circumvent using 4 columns, 25 text
boxes each, that still allows me to set the RepeatWith property to the
left matrix, I'm all ears.
Thanks!
On Jan 22, 11:00 am, Orne <polysilly...@.yahoo.com> wrote:
> On Jan 22, 11:41 am, adam.schm...@.gmail.com wrote:
> > If anyone knows a brilliant way to
> > allow two unlike-sized datasets to be used in two matrices that can
> > interrupt each other to get data onto a page, by all means let me know
> > (I'm not holding my breath for that one though).
> If I understand your problem, you could: Put each object into a
> Rectangle object, then align the Rectangles to have the same Top edge,
> and align the Right edge of the left rectangle to meet the Left edge
> of the right rectangle.
> > So, my
> > question is this: can anyone suggest a good way to either A) break the
> > dataset into chunks of <=5 records,
> If your source data is a SQL Server, then try using the ROW_Number()
> OVER ( ORDER BY FIELD ) function in the statement to generate row
> numbers. Then, you can group by ( RowNumber - RowNumber Mod 5 ) to
> create groups of 5.
> > or B) filter the each page's
> > control so that it only takes the appropriate <=5 records, without
> > redisplaying a record that was already displayed on a previous page?
> You could create a group as defined in (A), then put the Group in a
> List object, then go to the List's properties and check the Page Break
> at End. Then put all your display stuff inside the List. There are
> probably other ways of doing this.
> -- Scott
Sunday, February 12, 2012
Bottom half of Page Not Found
I have RS2k on SQL2k for several months with no issues, all users can access
reports for which they have been granted access.
I have one new user lately that has not been able to access a report that he
has been granted access to.
He clicks the link to the report server http://servername.domain.com/reports
and gets directed to the Home folder where he can see the report folder he
needs.
Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
the two linked reports that his user group has been granted access to. When
he clicks the hyperlink to either of these two reports, the header fo the
site (that has the breadcrumb bar) is still viewable, but the part of the
page that would normally show the "report is generating" message does not
appear and instead he gets a 'Page Not Found' error.
I have tried granting access to his username specifically, but no success.
I have looked at the web.config file but did not make any changes
(Impersonate is set to true, but no username or password is specified which
should cause the logged on user credentials to pass through.)
No other users are having this issue.
The reports are linked to reports in another folder which he does not have
access to.
Any suggestions?
Thanks.2 Other things:
1. Actual error message is "The Page Cannot Be Displayed. The page you are
looking for is currently unavailable..."
2. User is getting the same experience on other reports as well.
"Phillip" wrote:
> I have RS2k on SQL2k for several months with no issues, all users can access
> reports for which they have been granted access.
> I have one new user lately that has not been able to access a report that he
> has been granted access to.
> He clicks the link to the report server http://servername.domain.com/reports
> and gets directed to the Home folder where he can see the report folder he
> needs.
> Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
> the two linked reports that his user group has been granted access to. When
> he clicks the hyperlink to either of these two reports, the header fo the
> site (that has the breadcrumb bar) is still viewable, but the part of the
> page that would normally show the "report is generating" message does not
> appear and instead he gets a 'Page Not Found' error.
> I have tried granting access to his username specifically, but no success.
> I have looked at the web.config file but did not make any changes
> (Impersonate is set to true, but no username or password is specified which
> should cause the logged on user credentials to pass through.)
> No other users are having this issue.
> The reports are linked to reports in another folder which he does not have
> access to.
> Any suggestions?
> Thanks.
reports for which they have been granted access.
I have one new user lately that has not been able to access a report that he
has been granted access to.
He clicks the link to the report server http://servername.domain.com/reports
and gets directed to the Home folder where he can see the report folder he
needs.
Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
the two linked reports that his user group has been granted access to. When
he clicks the hyperlink to either of these two reports, the header fo the
site (that has the breadcrumb bar) is still viewable, but the part of the
page that would normally show the "report is generating" message does not
appear and instead he gets a 'Page Not Found' error.
I have tried granting access to his username specifically, but no success.
I have looked at the web.config file but did not make any changes
(Impersonate is set to true, but no username or password is specified which
should cause the logged on user credentials to pass through.)
No other users are having this issue.
The reports are linked to reports in another folder which he does not have
access to.
Any suggestions?
Thanks.2 Other things:
1. Actual error message is "The Page Cannot Be Displayed. The page you are
looking for is currently unavailable..."
2. User is getting the same experience on other reports as well.
"Phillip" wrote:
> I have RS2k on SQL2k for several months with no issues, all users can access
> reports for which they have been granted access.
> I have one new user lately that has not been able to access a report that he
> has been granted access to.
> He clicks the link to the report server http://servername.domain.com/reports
> and gets directed to the Home folder where he can see the report folder he
> needs.
> Then he clicks the folder icon so that he is at .../HisRptFolder/ and sees
> the two linked reports that his user group has been granted access to. When
> he clicks the hyperlink to either of these two reports, the header fo the
> site (that has the breadcrumb bar) is still viewable, but the part of the
> page that would normally show the "report is generating" message does not
> appear and instead he gets a 'Page Not Found' error.
> I have tried granting access to his username specifically, but no success.
> I have looked at the web.config file but did not make any changes
> (Impersonate is set to true, but no username or password is specified which
> should cause the logged on user credentials to pass through.)
> No other users are having this issue.
> The reports are linked to reports in another folder which he does not have
> access to.
> Any suggestions?
> Thanks.
Friday, February 10, 2012
BorderStyle not shown as Solid for Top ,Bottom & Right side of Reports.
HI ,
Although I am setting the Border Style for each & every cell and /or Merge cells ,But it is not reflected in the Reports Pre-view for Bottom ,Top & Right Sides in the Reports?Any clue why this is happening & for removing this & getting the right results would be helpful .
Thanks
I had an issue where the BorderStyle did not seem to change. I was attempting to set the border to None on the Bottom of a cell but did not change the BorderStyle of the cell below it. Once I changed the Top BorderStyle to None of the cell below then I saw the desired affect.
Hope this helps.
Boots Performance
Hi ,
I already create clustered and non clustered index in order to improve the
reports performance. But after I test several times on my reports , the
processing time almost the same as before I index the table.
Any other method to increase the performance ? Can I index the "view" I
created ?
Travis Tan
Travis,
The group will need substantially more information in order to help diagnose
your performance issue. The basic answers to your questions are Yes. and
most likely yes depending on the version you are running.
Please post more information including:
SQL Server version
Basic hardware configuration
The query
The estimated query plan
What is the database used for (OLTP, DSS, Reporting, etc.)
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:5A01556F-70F4-4CC4-9779-2CAB8D4710F4@.microsoft.com...
> Hi ,
> I already create clustered and non clustered index in order to improve
> the
> reports performance. But after I test several times on my reports , the
> processing time almost the same as before I index the table.
> Any other method to increase the performance ? Can I index the "view" I
> created ?
>
> --
> Travis Tan
I already create clustered and non clustered index in order to improve the
reports performance. But after I test several times on my reports , the
processing time almost the same as before I index the table.
Any other method to increase the performance ? Can I index the "view" I
created ?
Travis Tan
Travis,
The group will need substantially more information in order to help diagnose
your performance issue. The basic answers to your questions are Yes. and
most likely yes depending on the version you are running.
Please post more information including:
SQL Server version
Basic hardware configuration
The query
The estimated query plan
What is the database used for (OLTP, DSS, Reporting, etc.)
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:5A01556F-70F4-4CC4-9779-2CAB8D4710F4@.microsoft.com...
> Hi ,
> I already create clustered and non clustered index in order to improve
> the
> reports performance. But after I test several times on my reports , the
> processing time almost the same as before I index the table.
> Any other method to increase the performance ? Can I index the "view" I
> created ?
>
> --
> Travis Tan
Boots Performance
Hi ,
I already create clustered and non clustered index in order to improve the
reports performance. But after I test several times on my reports , the
processing time almost the same as before I index the table.
Any other method to increase the performance ? Can I index the "view" I
created ?
Travis TanTravis,
The group will need substantially more information in order to help diagnose
your performance issue. The basic answers to your questions are Yes. and
most likely yes depending on the version you are running.
Please post more information including:
SQL Server version
Basic hardware configuration
The query
The estimated query plan
What is the database used for (OLTP, DSS, Reporting, etc.)
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:5A01556F-70F4-4CC4-9779-2CAB8D4710F4@.microsoft.com...
> Hi ,
> I already create clustered and non clustered index in order to improve
> the
> reports performance. But after I test several times on my reports , the
> processing time almost the same as before I index the table.
> Any other method to increase the performance ? Can I index the "view" I
> created ?
>
> --
> Travis Tan
I already create clustered and non clustered index in order to improve the
reports performance. But after I test several times on my reports , the
processing time almost the same as before I index the table.
Any other method to increase the performance ? Can I index the "view" I
created ?
Travis TanTravis,
The group will need substantially more information in order to help diagnose
your performance issue. The basic answers to your questions are Yes. and
most likely yes depending on the version you are running.
Please post more information including:
SQL Server version
Basic hardware configuration
The query
The estimated query plan
What is the database used for (OLTP, DSS, Reporting, etc.)
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:5A01556F-70F4-4CC4-9779-2CAB8D4710F4@.microsoft.com...
> Hi ,
> I already create clustered and non clustered index in order to improve
> the
> reports performance. But after I test several times on my reports , the
> processing time almost the same as before I index the table.
> Any other method to increase the performance ? Can I index the "view" I
> created ?
>
> --
> Travis Tan
Subscribe to:
Posts (Atom)