GetImage=8.00.878.00f1_rsc_htmlviewer.html

Hi
I am trying to get the HTML viewer help file to appear. When I click the
help icon I go get a new window with the URL
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
which is blank ( file exixts on the server )
when I goto another server
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
the file pops right up.
I have changed some of the report renderings on both servers 1 & 2
( Identical changes ).
THere is no documentation that really helps here ( especially if 8.00.878.00
is getting the english language version)
Do I have to set some language setting in RS ?
TIA
Ray
--
Illusion is the first of all pleasures.I can't really think of a reason why you would not see the file. Here are
some things you can try:
Try a ctrl-F5 refresh, the help page is set to live on the client for 30
days, perhaps the client copy is corrupt.
Ensure each language folder has the help file and that they are not blank.
As for the language, RS will query the browser language and select the help
file based on that. If the language is not supported then you should get
English.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> Hi
> I am trying to get the HTML viewer help file to appear. When I click the
> help icon I go get a new window with the URL
>
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> which is blank ( file exixts on the server )
> when I goto another server
>
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> the file pops right up.
> I have changed some of the report renderings on both servers 1 & 2
> ( Identical changes ).
> THere is no documentation that really helps here ( especially if
8.00.878.00
> is getting the english language version)
> Do I have to set some language setting in RS ?
> TIA
> Ray
>
> --
> Illusion is the first of all pleasures.|||Daniel
I did the refresh with no luck, I also checked to make sure the files were
there and they were. I have seen two other posts that were basically the same
as mine, is this issue on a defect list ?
Ray
"Daniel Reib [MSFT]" wrote:
> I can't really think of a reason why you would not see the file. Here are
> some things you can try:
> Try a ctrl-F5 refresh, the help page is set to live on the client for 30
> days, perhaps the client copy is corrupt.
> Ensure each language folder has the help file and that they are not blank.
> As for the language, RS will query the browser language and select the help
> file based on that. If the language is not supported then you should get
> English.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
> news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> > Hi
> > I am trying to get the HTML viewer help file to appear. When I click the
> > help icon I go get a new window with the URL
> >
> http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > which is blank ( file exixts on the server )
> > when I goto another server
> >
> http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > the file pops right up.
> >
> > I have changed some of the report renderings on both servers 1 & 2
> > ( Identical changes ).
> > THere is no documentation that really helps here ( especially if
> 8.00.878.00
> > is getting the english language version)
> > Do I have to set some language setting in RS ?
> >
> > TIA
> > Ray
> >
> >
> >
> > --
> > Illusion is the first of all pleasures.
>
>|||I'm not sure what would cause this behavior. I will investigate this
further and see if I can come up with a resolution.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
news:65BA2102-916C-4879-A99D-EFA6DD59E7F0@.microsoft.com...
> Daniel
> I did the refresh with no luck, I also checked to make sure the files were
> there and they were. I have seen two other posts that were basically the
same
> as mine, is this issue on a defect list ?
> Ray
>
> "Daniel Reib [MSFT]" wrote:
> > I can't really think of a reason why you would not see the file. Here
are
> > some things you can try:
> >
> > Try a ctrl-F5 refresh, the help page is set to live on the client for 30
> > days, perhaps the client copy is corrupt.
> >
> > Ensure each language folder has the help file and that they are not
blank.
> >
> > As for the language, RS will query the browser language and select the
help
> > file based on that. If the language is not supported then you should
get
> > English.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "punchcardRay" <punchcardRay@.discussions.microsoft.com> wrote in message
> > news:42B3F70D-1383-4789-8CF1-9091C20DAFC7@.microsoft.com...
> > > Hi
> > > I am trying to get the HTML viewer help file to appear. When I click
the
> > > help icon I go get a new window with the URL
> > >
> >
http://myserver1/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > > which is blank ( file exixts on the server )
> > > when I goto another server
> > >
> >
http://myserver2/ReportServer?rs:Command=Get&rc:GetImage=8.00.878.00f1_rsc_htmlviewer.htm
> > > the file pops right up.
> > >
> > > I have changed some of the report renderings on both servers 1 & 2
> > > ( Identical changes ).
> > > THere is no documentation that really helps here ( especially if
> > 8.00.878.00
> > > is getting the english language version)
> > > Do I have to set some language setting in RS ?
> > >
> > > TIA
> > > Ray
> > >
> > >
> > >
> > > --
> > > Illusion is the first of all pleasures.
> >
> >
> >sql

Get the complete SQL Query

Hi !!!

I was told to generate in HTML the content of a crystal report, but without using Crystal Reports... The report is feeded from a sql server view, but inside the report there are many grouping and summarizing fields, so it's very difficult for me to build the sql query to feed my HTML report...

I'd like to know if there's a way to obtain (programatically or not) the complete SQL statement (that is, the original query from datasource plus any modification done in the crystal report such as grouping and summarizing).

Thank you !!!if u have crystal reports installed, open rpt file and
click database menu select show sql query.
U can see the rpt query.

regarding summary fields, u need to find it in rpt, in group footers or group headers.

Hope it helps|||Thank you sraheem !

The "show sql query" just shows the datasource sql query, but not the final sql that is built using that datasource AND grouping and summarizing fields...

Maybe it's not possible to obtain that final sql query ?

Thanks for help !