Hi,
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
RajCan I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"ë'ì?´ ì'ì?±í' ë?´ì?©:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schema
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Friday, March 30, 2012
IF funcionality in SQL server views
Hi,
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
Raj
Can I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will
|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"?? ??? ??:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>
|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schema
sql
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
Raj
Can I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will
|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"?? ??? ??:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>
|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schema
sql
IF funcionality in SQL server views
Hi,
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
RajCan I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"?? ??? ??:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schem
a
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
RajCan I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"?? ??? ??:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schem
a
IF funcionality in SQL server views
Hi,
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
RajCan I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"?? ??? ??:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schem
a
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
RajCan I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will|||If you want to conditional view, you can make a view using Multi-statement
Function.
"the_raj"?? ??? ??:
> Hi,
> I am working with several tables and views. My goal is to create a view
> with critical reporting data from these tables and views. I have
> managed to get the majority of data but am having difficultly with the
> final step.
> For a record in the master dataview, add additional record information
> by appending data from another view based on the first 2 letters of the
> document number and the document number i.e
> Document number
> SC11111
> DN22222
> SI33333
> For SC11111 look up data in Sales Credit table/view for doument SC11111
> and append to that line
> For DN22222 look up data in Delivery Note table/view for document
> DN22222and append to that line
> For SI33333 look up data in Sales Invoice table/view for document
> SI33333 and append to that line
> Any help appreciated.
> Thank you in advance,
> Raj
>|||Since you haven't provided the ddls I will try to explain it with a snippet.
CREATE VIEW MASTER_VIEW
AS
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_CREDIT B
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SC'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, C.*
FROM MASTER_DATA A, DELIVERY_NOTE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'DN'
AND <JOIN CODITIONS>
UNION ALL
SELECT A.*, B.*
FROM MASTER_DATA A, SALES_INVOICE C
WHERE SUBSTRING(A. DOCUMENT_NUMBER,1,2) = 'SI'
AND <JOIN CODITIONS>
--Note: do not use select *
-- and I assume the 3 selects that are unioned will be having the same schem
a
IF funcionality in SQL server views
Hi,
I am working with several tables and views. My goal is to create a view
with critical reporting data from these tables and views. I have
managed to get the majority of data but am having difficultly with the
final step.
For a record in the master dataview, add additional record information
by appending data from another view based on the first 2 letters of the
document number and the document number i.e
Document number
SC11111
DN22222
SI33333
For SC11111 look up data in Sales Credit table/view for doument SC11111
and append to that line
For DN22222 look up data in Delivery Note table/view for document
DN22222and append to that line
For SI33333 look up data in Sales Invoice table/view for document
SI33333 and append to that line
Any help appreciated.
Thank you in advance,
RajCan I just clarify what you're trying to do...
as I understand it, you want to select from different tables/views
depending on what the data is.
if so, could you left join on all 3 tables, then using join filters and
using isnull() in your select you could just get the data from the
relevant table.
Otherwise, could you explain a bit further what the problem is.
Cheers
Will
Monday, March 26, 2012
IE7 and SSRS Document Map
The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.
Reporting Services version is SQL2000.
Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.
Can anyone help or at least comment?
I have raised in a number of places...but no response.
The document map works when running against SQL 2005 - but that doesn't help my customers.
I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.
When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade
User string agent utility doesn't work for me either.
At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.
|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||Howdy,
We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.
Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.
|||The document map does not display SQL Express Reporting Service reports from IE7 browsers.
I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.
|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out
http://connect.microsoft.com
where I logged this problem and got a "Won't fix" answer.
|||I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000
This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.
|||Have got an acknowledgement from someone at MS:
"Document map base its dynamic behavior on an htc file: TreeView.htc.
1) In IE6, when an html page includes an import namespace like the following:
<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>
It shows the document map correctly
In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response
2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.
It seems IE7 needs the content type set in order to import an htc correctly."
Can any one figure out a workaround based on this information?
|||Does anyone had this issue in IE6?
I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?
|||
HELP, how do we implement this solution?
We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000
I see the virtual directory and can add text/x-component but what is the value we attached to it,
Or are we suppose to add this some where else?
|||Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.
IE7 and SSRS Document Map
The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.
Reporting Services version is SQL2000.
Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.
Can anyone help or at least comment?
I have raised in a number of places...but no response.
The document map works when running against SQL 2005 - but that doesn't help my customers.
I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.
When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade
User string agent utility doesn't work for me either.
At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.
|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||Howdy,
We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.
Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.
|||The document map does not display SQL Express Reporting Service reports from IE7 browsers.
I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.
|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out
http://connect.microsoft.com
where I logged this problem and got a "Won't fix" answer.
|||I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000
This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.
|||Have got an acknowledgement from someone at MS:
"Document map base its dynamic behavior on an htc file: TreeView.htc.
1) In IE6, when an html page includes an import namespace like the following:
<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>
It shows the document map correctly
In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response
2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.
It seems IE7 needs the content type set in order to import an htc correctly."
Can any one figure out a workaround based on this information?
|||Does anyone had this issue in IE6?
I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?
|||HELP, how do we implement this solution?
We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000
I see the virtual directory and can add text/x-component but what is the value we attached to it,
Or are we suppose to add this some where else?
|||Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.
IE7 and SSRS Document Map
The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.
Reporting Services version is SQL2000.
Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.
Can anyone help or at least comment?
I have raised in a number of places...but no response.
The document map works when running against SQL 2005 - but that doesn't help my customers.
I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.
When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade
User string agent utility doesn't work for me either.
At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.
|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||Howdy,
We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.
Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.
|||The document map does not display SQL Express Reporting Service reports from IE7 browsers.
I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.
|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out
http://connect.microsoft.com
where I logged this problem and got a "Won't fix" answer.
|||I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000
This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.
|||Have got an acknowledgement from someone at MS:
"Document map base its dynamic behavior on an htc file: TreeView.htc.
1) In IE6, when an html page includes an import namespace like the following:
<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>
It shows the document map correctly
In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response
2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.
It seems IE7 needs the content type set in order to import an htc correctly."
Can any one figure out a workaround based on this information?
|||Does anyone had this issue in IE6?
I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?
|||HELP, how do we implement this solution?
We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000
I see the virtual directory and can add text/x-component but what is the value we attached to it,
Or are we suppose to add this some where else?
|||Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.
IE7 and SSRS Document Map
The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.
Reporting Services version is SQL2000.
Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.
Can anyone help or at least comment?
I have raised in a number of places...but no response.
The document map works when running against SQL 2005 - but that doesn't help my customers.
I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.
When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade
User string agent utility doesn't work for me either.
At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.
|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||Howdy,
We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.
Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.
|||The document map does not display SQL Express Reporting Service reports from IE7 browsers.
I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.
|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out
http://connect.microsoft.com
where I logged this problem and got a "Won't fix" answer.
|||I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000
This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.
|||Have got an acknowledgement from someone at MS:
"Document map base its dynamic behavior on an htc file: TreeView.htc.
1) In IE6, when an html page includes an import namespace like the following:
<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>
It shows the document map correctly
In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response
2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.
It seems IE7 needs the content type set in order to import an htc correctly."
Can any one figure out a workaround based on this information?
|||Does anyone had this issue in IE6?
I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?
|||HELP, how do we implement this solution?
We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000
I see the virtual directory and can add text/x-component but what is the value we attached to it,
Or are we suppose to add this some where else?
|||Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.
IE7 and SSRS Document Map
The contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.
Reporting Services version is SQL2000.
Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.
Can anyone help or at least comment?
I have raised in a number of places...but no response.
The document map works when running against SQL 2005 - but that doesn't help my customers.
I have also tried to use the "user string agent utility" and set IE to think it is version 6 - but that didn't make any difference.
When is SQL 2000 - officially unsupported , as I suspect that will be answer.. they will ignore it and tell you upgrade
User string agent utility doesn't work for me either.
At least if I was being told to upgarde I would know where I stood; some sort of definitive response from MS ought to be in order. It seems to be getting ignored at the moment.
|||This is a known issue with RS 2000. Contact product support for a hotfix.|||Have you got a reference to a Tech Article or the hotfix id as our local support did not know about this and I cant seem to find a Q Article number for it.|||There isn't one yet that I know of. However, the RS development team is aware of this issue. I reported it when IE 7 got out. Just tell the product support that you need a hotfix.|||Howdy,
We're getting a handle on this right now. We had issues with document map on RS 2005 before IE7 shipped, which no longer reproed on IE7 RTM, so we thought the problem was fixed. Apparently there's some other problem with RS 2000 and IE7.
Yes, RS 2000 is still supported. We're taking QFE's, but as you can expect, the bar is somewhat higher than it would be for RS 2005.
|||The document map does not display SQL Express Reporting Service reports from IE7 browsers.
I have about 200 1 tiered items to display in the document map. IE6 works like a champ. IE7 populates all 200 entries however the scrollbar will not allow you to scroll all the way down to access all 200 items. You can however place your cursor in the document map window and by pressing the arror down key scroll through all the entries.
|||Denpro: I presume you are on SQL2005? It doesn't work at all on SQL2000.|||It seems the bar is high enough that this one won't be fixed, at least if the reply from connect is accurate. Check out
http://connect.microsoft.com
where I logged this problem and got a "Won't fix" answer.
|||I've also logged this issue on connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243000
This was done at the request of one of the SSRS team. Hopefully this means the issue should be getting looked at.
|||Have got an acknowledgement from someone at MS:
"Document map base its dynamic behavior on an htc file: TreeView.htc.
1) In IE6, when an html page includes an import namespace like the following:
<?IMPORT NAMESPACE="dm" IMPLEMENTATION="http://[Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc"/>
It shows the document map correctly
In IE7, document map is not shown because the response returned by http:// [Servername]/ReportServer?rs:Command=Get&rc:GetImage=8.00.1038.00TreeView.htc does not have a content-type set in the response
2) If we modify ReportServer virtual directory to include the header Content-Type: text/x-component manually, then IE7 also shows the document map.
It seems IE7 needs the content type set in order to import an htc correctly."
Can any one figure out a workaround based on this information?
|||Does anyone had this issue in IE6?
I am trying to view RS 2000 report having document map in IE6, it is not getting displayed. What could be the reason, any solutions?
|||
HELP, how do we implement this solution?
We are having the same issues with IE7 NOT showing the Document map for our reports in SRS 2000
I see the virtual directory and can add text/x-component but what is the value we attached to it,
Or are we suppose to add this some where else?
|||Can you help me please? Was there a resolution to this? Document map with RS2000 and IE6 okay. Document map with RS2000 and IE7 not displayed as you described. I tried changing settings on the IIS ReportServer virtual directory but can't find a fix, and can't find anything published elsewhere. Is there a published fix or workaround somewhere?Otherwise need to upgrade to RS2005? Regards.
sqlie5 authentication issues
Hi
We are having a problem with authentication on our reporting server. If the
user connecting is using IE version 5.0 they get a not authorised to view
page error (see below). It works fine for this same user if they use a
machine with ie 5.5 or greater. Other users also have the same problem but
always only if they are using ie5.0. Does anyone no what is causing this? Teh
users connect to the server using the standard
http:<reportservername>/Reports interface. Thanks
ERROR MESSAGE......
You are not authorized to view this page
You do not have permission to view this directory or page using the
credentials that you supplied because your Web browser is sending a
WWW-Authenticate header field that the Web server is not configured to
accept.
----
Please try the following:
Contact the Web site administrator if you believe you should be able to view
this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)
----
Technical Information (for support personnel)
Go to Microsoft Product Support Services and perform a title search for the
words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
topics titled About Security, Authentication, and About Custom Error
Messages.Meant to add the system is using windows authentication based on our domain.
"ag" wrote:
> Hi
> We are having a problem with authentication on our reporting server. If the
> user connecting is using IE version 5.0 they get a not authorised to view
> page error (see below). It works fine for this same user if they use a
> machine with ie 5.5 or greater. Other users also have the same problem but
> always only if they are using ie5.0. Does anyone no what is causing this? Teh
> users connect to the server using the standard
> http:<reportservername>/Reports interface. Thanks
> ERROR MESSAGE......
> You are not authorized to view this page
> You do not have permission to view this directory or page using the
> credentials that you supplied because your Web browser is sending a
> WWW-Authenticate header field that the Web server is not configured to
> accept.
> ----
> Please try the following:
> Contact the Web site administrator if you believe you should be able to view
> this directory or page.
> Click the Refresh button to try again with different credentials.
> HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
> Internet Information Services (IIS)
> ----
> Technical Information (for support personnel)
> Go to Microsoft Product Support Services and perform a title search for the
> words HTTP and 401.
> Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
> topics titled About Security, Authentication, and About Custom Error
> Messages.
>
We are having a problem with authentication on our reporting server. If the
user connecting is using IE version 5.0 they get a not authorised to view
page error (see below). It works fine for this same user if they use a
machine with ie 5.5 or greater. Other users also have the same problem but
always only if they are using ie5.0. Does anyone no what is causing this? Teh
users connect to the server using the standard
http:<reportservername>/Reports interface. Thanks
ERROR MESSAGE......
You are not authorized to view this page
You do not have permission to view this directory or page using the
credentials that you supplied because your Web browser is sending a
WWW-Authenticate header field that the Web server is not configured to
accept.
----
Please try the following:
Contact the Web site administrator if you believe you should be able to view
this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)
----
Technical Information (for support personnel)
Go to Microsoft Product Support Services and perform a title search for the
words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
topics titled About Security, Authentication, and About Custom Error
Messages.Meant to add the system is using windows authentication based on our domain.
"ag" wrote:
> Hi
> We are having a problem with authentication on our reporting server. If the
> user connecting is using IE version 5.0 they get a not authorised to view
> page error (see below). It works fine for this same user if they use a
> machine with ie 5.5 or greater. Other users also have the same problem but
> always only if they are using ie5.0. Does anyone no what is causing this? Teh
> users connect to the server using the standard
> http:<reportservername>/Reports interface. Thanks
> ERROR MESSAGE......
> You are not authorized to view this page
> You do not have permission to view this directory or page using the
> credentials that you supplied because your Web browser is sending a
> WWW-Authenticate header field that the Web server is not configured to
> accept.
> ----
> Please try the following:
> Contact the Web site administrator if you believe you should be able to view
> this directory or page.
> Click the Refresh button to try again with different credentials.
> HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
> Internet Information Services (IIS)
> ----
> Technical Information (for support personnel)
> Go to Microsoft Product Support Services and perform a title search for the
> words HTTP and 401.
> Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for
> topics titled About Security, Authentication, and About Custom Error
> Messages.
>
Friday, March 23, 2012
IE hangs after running Report viewer
Hi all,
I run a web application with form authentication. In my web application, I have some links to call some reports from a reporting server. When user clicks the link of web report, a login dialog box asks user to enter the id and password. It works fine. However some web pages sometime can not run as usual after calling the report server. Can anyone give me some advisement to fix the problem?
Thanks in advance.
Best regards,
Tom
Hi,
From your description, it seems that your IE Browser hangs after you run your report viewer, right?
In most cases, the cause of this kind of issue is that you have not installed the service pack for your IE or your SQLServer Reporting Service.
Here are some links which should be installed:
If you are using SQLServer2000.
SQLServer2000 Reporting Service SP2
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
If you are using SQLServer2005
SQLServer2005 SP2
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
If you are using IE6:
IE6 SP1
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e1550cb-5e5d-48f5-b02b-20b602228de6&DisplayLang=en
Thanks.
I tried to update the SP2 for the SQL server 2005, but the said error does not be fixed. I am using IE 7 for testing. Can anyone help me and give me some advisement?
Thanks a lot.
Tom
IE 7.0.5335.5 Beta 2 and SSRS 2000
Hi,
I'm trying to track and issue with IE 7 and reporting services.
First off, the report export to Excel works fine using IE 6
In IE 7 when I initially generate the report from a link in our website, the
report comes up correctly, but when I attempt to export that report to xls,
PDF, TIFF, HTML, etc I get an error that says:
"Internet Explorer cannon download Format=EXCEL from 192.168.0.250.
Internet Explorer was unable to open this Internet Site. The requested site
is either unavailable or cannot be found. Please try again later."
The site and format that it is trying to download is correct, but the
Certificate on the site is not working right (Known issue on our end). I
have added this site to the "Trusted Sites" under Internet Explorer"
Security.
Does anyone have a clue where this could come from?
Thanks
TrentAre you using SSL?
I had the same problem and found this topic which fixed my problem :
http://groups.google.co.nz/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/739f695f20237190/199c56a3165f6735?q=https&rnum=2#199c56a3165f6735|||That fixed it! Thank you for your response.
FYI - Solution is to uncheck "Do not save encrypted pages to disk"
This may be a long term security issue, but that is for another discussion.
Thanks again,
TTU
"CPNZ" wrote:
> Are you using SSL?
> I had the same problem and found this topic which fixed my problem :
> http://groups.google.co.nz/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/739f695f20237190/199c56a3165f6735?q=https&rnum=2#199c56a3165f6735
>sql
I'm trying to track and issue with IE 7 and reporting services.
First off, the report export to Excel works fine using IE 6
In IE 7 when I initially generate the report from a link in our website, the
report comes up correctly, but when I attempt to export that report to xls,
PDF, TIFF, HTML, etc I get an error that says:
"Internet Explorer cannon download Format=EXCEL from 192.168.0.250.
Internet Explorer was unable to open this Internet Site. The requested site
is either unavailable or cannot be found. Please try again later."
The site and format that it is trying to download is correct, but the
Certificate on the site is not working right (Known issue on our end). I
have added this site to the "Trusted Sites" under Internet Explorer"
Security.
Does anyone have a clue where this could come from?
Thanks
TrentAre you using SSL?
I had the same problem and found this topic which fixed my problem :
http://groups.google.co.nz/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/739f695f20237190/199c56a3165f6735?q=https&rnum=2#199c56a3165f6735|||That fixed it! Thank you for your response.
FYI - Solution is to uncheck "Do not save encrypted pages to disk"
This may be a long term security issue, but that is for another discussion.
Thanks again,
TTU
"CPNZ" wrote:
> Are you using SSL?
> I had the same problem and found this topic which fixed my problem :
> http://groups.google.co.nz/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/739f695f20237190/199c56a3165f6735?q=https&rnum=2#199c56a3165f6735
>sql
IE 7 RC 1 does not respond to Back history command while viewing a report
I have noticed a minor problem in IE 7 RC 1, while viewing a Microsoft
Reporting Services report the Back history command does not work.
Thanks,
Lonyes - I saw this too - I just now load RC 1 now thinking my older version
just had the problem.
Really bites - you think many would have noticed this on their end already.
"Lon" <lonuel@.gmail.com> wrote in message
news:1157478836.906147.116200@.d34g2000cwd.googlegroups.com...
>I have noticed a minor problem in IE 7 RC 1, while viewing a Microsoft
> Reporting Services report the Back history command does not work.
> Thanks,
> Lon
>sql
Reporting Services report the Back history command does not work.
Thanks,
Lonyes - I saw this too - I just now load RC 1 now thinking my older version
just had the problem.
Really bites - you think many would have noticed this on their end already.
"Lon" <lonuel@.gmail.com> wrote in message
news:1157478836.906147.116200@.d34g2000cwd.googlegroups.com...
>I have noticed a minor problem in IE 7 RC 1, while viewing a Microsoft
> Reporting Services report the Back history command does not work.
> Thanks,
> Lon
>sql
Subscribe to:
Posts (Atom)