Hi,
the problem in one of our reports is, that there are a lot of detail lines
for each group, so if you scroll down to see them, the table header is not
visible. Our customers are complaining about that, because they have to
scroll up and down to see to which field the detail belongs.
Moreover it is not possible to split the table, because all details are a
logical group.
My question: Is it possible to fix a table header like the fixing function
in excel, so it can always be seen when you scroll down the details?
Thanks,
BjörnTable headers can be repeated on each page, but you can not do the excel
like thing... You can make your page smaller, but that's about it I think.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Björn Grünberg" <BjrnGrnberg@.discussions.microsoft.com> wrote in message
news:DE7380C6-C5A0-47C0-9C0E-F267976BCC4A@.microsoft.com...
> Hi,
> the problem in one of our reports is, that there are a lot of detail lines
> for each group, so if you scroll down to see them, the table header is not
> visible. Our customers are complaining about that, because they have to
> scroll up and down to see to which field the detail belongs.
> Moreover it is not possible to split the table, because all details are a
> logical group.
> My question: Is it possible to fix a table header like the fixing function
> in excel, so it can always be seen when you scroll down the details?
> Thanks,
> Björn|||Wayne is right, Reporting Services 2000 does not this particular feature.
Look for this in Reporting Services 2005 (shipping as part of Yukon),
though.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhCnpeBRFHA.3020@.TK2MSFTNGP12.phx.gbl...
> Table headers can be repeated on each page, but you can not do the excel
> like thing... You can make your page smaller, but that's about it I think.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Björn Grünberg" <BjrnGrnberg@.discussions.microsoft.com> wrote in message
> news:DE7380C6-C5A0-47C0-9C0E-F267976BCC4A@.microsoft.com...
>> Hi,
>> the problem in one of our reports is, that there are a lot of detail
>> lines
>> for each group, so if you scroll down to see them, the table header is
>> not
>> visible. Our customers are complaining about that, because they have to
>> scroll up and down to see to which field the detail belongs.
>> Moreover it is not possible to split the table, because all details are a
>> logical group.
>> My question: Is it possible to fix a table header like the fixing
>> function
>> in excel, so it can always be seen when you scroll down the details?
>> Thanks,
>> Björn
>|||On Mon, 18 Apr 2005 03:57:19 -0700, "Björn Grünberg"
<BjrnGrnberg@.discussions.microsoft.com> wrote:
>Hi,
>the problem in one of our reports is, that there are a lot of detail lines
>for each group, so if you scroll down to see them, the table header is not
>visible. Our customers are complaining about that, because they have to
>scroll up and down to see to which field the detail belongs.
>Moreover it is not possible to split the table, because all details are a
>logical group.
>My question: Is it possible to fix a table header like the fixing function
>in excel, so it can always be seen when you scroll down the details?
>Thanks,
>Björn
Bjorn,
It's a little bit of a kludge but why not add a table footer and
simply repeat the information that is in the table header? That should
make the relevant information visible in a larger part of the page.
Andrew Watt
MVP - InfoPath
2012年3月19日星期一
2012年3月11日星期日
Fixed reports in Reporting Services using SSAS
I am quite new with Reporting Services so appologies if I'm asking a
really simple question without relaising it.
I have a Analysis Services cube that I'm querying from Reporting
Services 2005, I'm wondering how I can create a fixed style report that
has specfic members from one dimension in one axis and specific members
from another dimension in another.
Eg:
Jan Feb Mar Apr May Jun Jul Aug
Cost1 2 6 5 8 88 0 8 8
Cost15 0 0 0 0 0 6 54 5
Cost65 52 5 545 1 42 55 54 455
Cost15 545 0 555 0 22 2252 5 55
Cost95
I have found that it's quite easy to create this format in a dymamic
fashion but I have had no hope in doing so with fixed members in both
axis.
Any help would be much appreciated.
Thanks
SimonI think that you can make 1,15,65,15,95 members as a 'named set'
hope that helps
-Aaron
sk wrote:
> I am quite new with Reporting Services so appologies if I'm asking a
> really simple question without relaising it.
> I have a Analysis Services cube that I'm querying from Reporting
> Services 2005, I'm wondering how I can create a fixed style report that
> has specfic members from one dimension in one axis and specific members
> from another dimension in another.
> Eg:
> Jan Feb Mar Apr May Jun Jul Aug
> Cost1 2 6 5 8 88 0 8 8
> Cost15 0 0 0 0 0 6 54 5
> Cost65 52 5 545 1 42 55 54 455
> Cost15 545 0 555 0 22 2252 5 55
> Cost95
> I have found that it's quite easy to create this format in a dymamic
> fashion but I have had no hope in doing so with fixed members in both
> axis.
> Any help would be much appreciated.
> Thanks
> Simon|||I think you need to organize the way your data gets outputed. If you manage
to create a "grid" of data in the form you want it to, you could just use a
fixed table and add the fields to the column or row that you want it to.
That would probably mean a lot of crossjoins or unions on the coloumns to
get the months tagged right, and have the different costs as rows.
Sorry to ask, but why do you want to do it fixed? This is sort of what
matrixes are made for, contrary to the tables.
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1159979952.751107.275360@.m73g2000cwd.googlegroups.com...
>I am quite new with Reporting Services so appologies if I'm asking a
> really simple question without relaising it.
> I have a Analysis Services cube that I'm querying from Reporting
> Services 2005, I'm wondering how I can create a fixed style report that
> has specfic members from one dimension in one axis and specific members
> from another dimension in another.
> Eg:
> Jan Feb Mar Apr May Jun Jul Aug
> Cost1 2 6 5 8 88 0 8 8
> Cost15 0 0 0 0 0 6 54 5
> Cost65 52 5 545 1 42 55 54 455
> Cost15 545 0 555 0 22 2252 5 55
> Cost95
> I have found that it's quite easy to create this format in a dymamic
> fashion but I have had no hope in doing so with fixed members in both
> axis.
> Any help would be much appreciated.
> Thanks
> Simon
>|||Thanks for your reply,
The report needs to look exactly the same as an Excel based matrix
report that we use. the format is defined by our corporate entity so I
can't change it.
Thanks
Simon|||Excel isn't a reporting platform.
Tell them to eat shit
-Aaron
sk wrote:
> Thanks for your reply,
> The report needs to look exactly the same as an Excel based matrix
> report that we use. the format is defined by our corporate entity so I
> can't change it.
>
> Thanks
> Simon|||Thanks for your suggestion, I'll give it a try!
Still, it must br possible to create a fixed grid report. I'll try your
suggestions and the others posted here..
Simon|||There's a discription in Chris Hays' blog about Horizontal Tables. Might be
what you need:
http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx
As for using a matrix, what parts are different between your Excel report
and a matix based report?
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1160074016.884219.105770@.i42g2000cwa.googlegroups.com...
> Thanks for your suggestion, I'll give it a try!
> Still, it must br possible to create a fixed grid report. I'll try your
> suggestions and the others posted here..
>
> Simon
>|||Thanks for that - I'll look into it.
The difference between my Excel report and a matrix based report is
that the Excel report is completely static. just a table with fixed
members in each axis. The members in each axis need to be fixed like a
PL report (see example)
http://www.ilytix.com/ImageFiles/Popup_P&L_Report.gif|||OK, the picture looks like a standard RS table. As long as your output is in
a usefull format, you could use a RS table. If you make sure you always get
the right data out (like you know you only get the same 4 rows of growth),
you can probably use a dynamic table. Or you can really hard code it,
returning several data sets with one row of data in each and creating
several single line tables put close in the report designer so they look
like one big table.
If your data set returns both dynamic growth and dates (months in your first
example), you could solve it by using a matrix. Make a row group for your
growth, and a column group for dates. "Pad" your data set to make sure you
always return the same number of months for dates, so you always get the
same number of month columns, and the same for the growth numbers. You might
have to tweak your mdx statemement a bit, but that's probably more usefull
than customizing the table.
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1160083140.237336.110450@.i3g2000cwc.googlegroups.com...
> Thanks for that - I'll look into it.
> The difference between my Excel report and a matrix based report is
> that the Excel report is completely static. just a table with fixed
> members in each axis. The members in each axis need to be fixed like a
> PL report (see example)
> http://www.ilytix.com/ImageFiles/Popup_P&L_Report.gif
>
really simple question without relaising it.
I have a Analysis Services cube that I'm querying from Reporting
Services 2005, I'm wondering how I can create a fixed style report that
has specfic members from one dimension in one axis and specific members
from another dimension in another.
Eg:
Jan Feb Mar Apr May Jun Jul Aug
Cost1 2 6 5 8 88 0 8 8
Cost15 0 0 0 0 0 6 54 5
Cost65 52 5 545 1 42 55 54 455
Cost15 545 0 555 0 22 2252 5 55
Cost95
I have found that it's quite easy to create this format in a dymamic
fashion but I have had no hope in doing so with fixed members in both
axis.
Any help would be much appreciated.
Thanks
SimonI think that you can make 1,15,65,15,95 members as a 'named set'
hope that helps
-Aaron
sk wrote:
> I am quite new with Reporting Services so appologies if I'm asking a
> really simple question without relaising it.
> I have a Analysis Services cube that I'm querying from Reporting
> Services 2005, I'm wondering how I can create a fixed style report that
> has specfic members from one dimension in one axis and specific members
> from another dimension in another.
> Eg:
> Jan Feb Mar Apr May Jun Jul Aug
> Cost1 2 6 5 8 88 0 8 8
> Cost15 0 0 0 0 0 6 54 5
> Cost65 52 5 545 1 42 55 54 455
> Cost15 545 0 555 0 22 2252 5 55
> Cost95
> I have found that it's quite easy to create this format in a dymamic
> fashion but I have had no hope in doing so with fixed members in both
> axis.
> Any help would be much appreciated.
> Thanks
> Simon|||I think you need to organize the way your data gets outputed. If you manage
to create a "grid" of data in the form you want it to, you could just use a
fixed table and add the fields to the column or row that you want it to.
That would probably mean a lot of crossjoins or unions on the coloumns to
get the months tagged right, and have the different costs as rows.
Sorry to ask, but why do you want to do it fixed? This is sort of what
matrixes are made for, contrary to the tables.
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1159979952.751107.275360@.m73g2000cwd.googlegroups.com...
>I am quite new with Reporting Services so appologies if I'm asking a
> really simple question without relaising it.
> I have a Analysis Services cube that I'm querying from Reporting
> Services 2005, I'm wondering how I can create a fixed style report that
> has specfic members from one dimension in one axis and specific members
> from another dimension in another.
> Eg:
> Jan Feb Mar Apr May Jun Jul Aug
> Cost1 2 6 5 8 88 0 8 8
> Cost15 0 0 0 0 0 6 54 5
> Cost65 52 5 545 1 42 55 54 455
> Cost15 545 0 555 0 22 2252 5 55
> Cost95
> I have found that it's quite easy to create this format in a dymamic
> fashion but I have had no hope in doing so with fixed members in both
> axis.
> Any help would be much appreciated.
> Thanks
> Simon
>|||Thanks for your reply,
The report needs to look exactly the same as an Excel based matrix
report that we use. the format is defined by our corporate entity so I
can't change it.
Thanks
Simon|||Excel isn't a reporting platform.
Tell them to eat shit
-Aaron
sk wrote:
> Thanks for your reply,
> The report needs to look exactly the same as an Excel based matrix
> report that we use. the format is defined by our corporate entity so I
> can't change it.
>
> Thanks
> Simon|||Thanks for your suggestion, I'll give it a try!
Still, it must br possible to create a fixed grid report. I'll try your
suggestions and the others posted here..
Simon|||There's a discription in Chris Hays' blog about Horizontal Tables. Might be
what you need:
http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx
As for using a matrix, what parts are different between your Excel report
and a matix based report?
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1160074016.884219.105770@.i42g2000cwa.googlegroups.com...
> Thanks for your suggestion, I'll give it a try!
> Still, it must br possible to create a fixed grid report. I'll try your
> suggestions and the others posted here..
>
> Simon
>|||Thanks for that - I'll look into it.
The difference between my Excel report and a matrix based report is
that the Excel report is completely static. just a table with fixed
members in each axis. The members in each axis need to be fixed like a
PL report (see example)
http://www.ilytix.com/ImageFiles/Popup_P&L_Report.gif|||OK, the picture looks like a standard RS table. As long as your output is in
a usefull format, you could use a RS table. If you make sure you always get
the right data out (like you know you only get the same 4 rows of growth),
you can probably use a dynamic table. Or you can really hard code it,
returning several data sets with one row of data in each and creating
several single line tables put close in the report designer so they look
like one big table.
If your data set returns both dynamic growth and dates (months in your first
example), you could solve it by using a matrix. Make a row group for your
growth, and a column group for dates. "Pad" your data set to make sure you
always return the same number of months for dates, so you always get the
same number of month columns, and the same for the growth numbers. You might
have to tweak your mdx statemement a bit, but that's probably more usefull
than customizing the table.
Kaisa M. Lindahl Lervik
"sk" <simon.m.knight@.gmail.com> wrote in message
news:1160083140.237336.110450@.i3g2000cwc.googlegroups.com...
> Thanks for that - I'll look into it.
> The difference between my Excel report and a matrix based report is
> that the Excel report is completely static. just a table with fixed
> members in each axis. The members in each axis need to be fixed like a
> PL report (see example)
> http://www.ilytix.com/ImageFiles/Popup_P&L_Report.gif
>
Fixed number of Intervals
Hi friends,
We are using SQL Server 2005 Reporting Services for developing our Reports. In one of our Reports having chart can we show fixed number of Intervals on X axis or Y axis ?
-sandyee
I believe that you can. In the y axis and x axis properties it gives you a minimum value, maximum value, and interval property to set.Fixed header rowin Reporting Services
Hi,
I've been devloping reports using Reporting Services. It's useful and fast.
However, I've this group of users who would like to fix the header row while
the data is able to scoll down and up without moving the header row. Is
there any configuration that can solve my problem? Below is a simple
illustration, hope anyone can help me in this.
| X header | Y header | Z header | ... | => This row must be fixed
| X data1 | Y data1 | Z data1 |... | ^
| X data2 | Y data2 | Z data2 |... | |
| X data3 | Y data3 | Z data3 |... | |
| X data4 | Y data4 | Z data4 |... | | These data rows
should be able to
| X data5 | Y data5 | Z data5 |... | | scroll up and down
| ........ | ........ | ........ |... | |
| X dataN | Y dataN | Z dataN |... | v
Best Regards,
Samie
I don't know how to do this.
I suspect that you will have a better response within the Reporting Services
newsgroup. I am including that group in this reply. Hopefully someone in
that group will be able to help.
Keith
"Samie" <Samie@.discussions.microsoft.com> wrote in message
news:D12C8438-E59D-49D5-9E2D-31C4D3A6B17C@.microsoft.com...
> Hi,
> I've been devloping reports using Reporting Services. It's useful and
fast.
> However, I've this group of users who would like to fix the header row
while
> the data is able to scoll down and up without moving the header row. Is
> there any configuration that can solve my problem? Below is a simple
> illustration, hope anyone can help me in this.
> | X header | Y header | Z header | ... | => This row must be fixed
> | X data1 | Y data1 | Z data1 |... | ^
> | X data2 | Y data2 | Z data2 |... | |
> | X data3 | Y data3 | Z data3 |... | |
> | X data4 | Y data4 | Z data4 |... | | These data rows
> should be able to
> | X data5 | Y data5 | Z data5 |... | | scroll up and down
> | ........ | ........ | ........ |... | |
> | X dataN | Y dataN | Z dataN |... | v
>
> Best Regards,
> Samie
>
|||Thanks Keith...
I'm hoping someone can help me too.
Regards,
samie
"Keith Kratochvil" wrote:
> I don't know how to do this.
> I suspect that you will have a better response within the Reporting Services
> newsgroup. I am including that group in this reply. Hopefully someone in
> that group will be able to help.
> --
> Keith
>
> "Samie" <Samie@.discussions.microsoft.com> wrote in message
> news:D12C8438-E59D-49D5-9E2D-31C4D3A6B17C@.microsoft.com...
> fast.
> while
>
|||Samie,
Fixed headers are not supported with version 1.0 but on the wish list for
2005.
Hope this helps.
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
"Samie" <Samie@.discussions.microsoft.com> wrote in message
news:119F060E-C479-4AF6-97E2-B59600B8D383@.microsoft.com...[vbcol=seagreen]
> Thanks Keith...
> I'm hoping someone can help me too.
> Regards,
> samie
>
> "Keith Kratochvil" wrote:
Services[vbcol=seagreen]
in[vbcol=seagreen]
row[vbcol=seagreen]
Is[vbcol=seagreen]
fixed[vbcol=seagreen]
rows[vbcol=seagreen]
down[vbcol=seagreen]
I've been devloping reports using Reporting Services. It's useful and fast.
However, I've this group of users who would like to fix the header row while
the data is able to scoll down and up without moving the header row. Is
there any configuration that can solve my problem? Below is a simple
illustration, hope anyone can help me in this.
| X header | Y header | Z header | ... | => This row must be fixed
| X data1 | Y data1 | Z data1 |... | ^
| X data2 | Y data2 | Z data2 |... | |
| X data3 | Y data3 | Z data3 |... | |
| X data4 | Y data4 | Z data4 |... | | These data rows
should be able to
| X data5 | Y data5 | Z data5 |... | | scroll up and down
| ........ | ........ | ........ |... | |
| X dataN | Y dataN | Z dataN |... | v
Best Regards,
Samie
I don't know how to do this.
I suspect that you will have a better response within the Reporting Services
newsgroup. I am including that group in this reply. Hopefully someone in
that group will be able to help.
Keith
"Samie" <Samie@.discussions.microsoft.com> wrote in message
news:D12C8438-E59D-49D5-9E2D-31C4D3A6B17C@.microsoft.com...
> Hi,
> I've been devloping reports using Reporting Services. It's useful and
fast.
> However, I've this group of users who would like to fix the header row
while
> the data is able to scoll down and up without moving the header row. Is
> there any configuration that can solve my problem? Below is a simple
> illustration, hope anyone can help me in this.
> | X header | Y header | Z header | ... | => This row must be fixed
> | X data1 | Y data1 | Z data1 |... | ^
> | X data2 | Y data2 | Z data2 |... | |
> | X data3 | Y data3 | Z data3 |... | |
> | X data4 | Y data4 | Z data4 |... | | These data rows
> should be able to
> | X data5 | Y data5 | Z data5 |... | | scroll up and down
> | ........ | ........ | ........ |... | |
> | X dataN | Y dataN | Z dataN |... | v
>
> Best Regards,
> Samie
>
|||Thanks Keith...
I'm hoping someone can help me too.
Regards,
samie
"Keith Kratochvil" wrote:
> I don't know how to do this.
> I suspect that you will have a better response within the Reporting Services
> newsgroup. I am including that group in this reply. Hopefully someone in
> that group will be able to help.
> --
> Keith
>
> "Samie" <Samie@.discussions.microsoft.com> wrote in message
> news:D12C8438-E59D-49D5-9E2D-31C4D3A6B17C@.microsoft.com...
> fast.
> while
>
|||Samie,
Fixed headers are not supported with version 1.0 but on the wish list for
2005.
Hope this helps.
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
"Samie" <Samie@.discussions.microsoft.com> wrote in message
news:119F060E-C479-4AF6-97E2-B59600B8D383@.microsoft.com...[vbcol=seagreen]
> Thanks Keith...
> I'm hoping someone can help me too.
> Regards,
> samie
>
> "Keith Kratochvil" wrote:
Services[vbcol=seagreen]
in[vbcol=seagreen]
row[vbcol=seagreen]
Is[vbcol=seagreen]
fixed[vbcol=seagreen]
rows[vbcol=seagreen]
down[vbcol=seagreen]
Fixed header in Sql Reporting
Hi All,
I have an issue with SQL reports. Once I set FixedHeader Property of Table
used in SQl report TURE. The detail of data getting overlapped on fixed
header of the report.
Is there any way to resolve this?
Thankin advance.
ShaileshSet you header line(s) BackgroundColor to White instead of the default
Transparent.
"Shailesh K" wrote:
> Hi All,
> I have an issue with SQL reports. Once I set FixedHeader Property of Table
> used in SQl report TURE. The detail of data getting overlapped on fixed
> header of the report.
> Is there any way to resolve this?
> Thankin advance.
> Shailesh|||Thanks William...It works well.
"William" wrote:
> Set you header line(s) BackgroundColor to White instead of the default
> Transparent.
>
> "Shailesh K" wrote:
> > Hi All,
> >
> > I have an issue with SQL reports. Once I set FixedHeader Property of Table
> > used in SQl report TURE. The detail of data getting overlapped on fixed
> > header of the report.
> > Is there any way to resolve this?
> > Thankin advance.
> >
> > Shailesh
I have an issue with SQL reports. Once I set FixedHeader Property of Table
used in SQl report TURE. The detail of data getting overlapped on fixed
header of the report.
Is there any way to resolve this?
Thankin advance.
ShaileshSet you header line(s) BackgroundColor to White instead of the default
Transparent.
"Shailesh K" wrote:
> Hi All,
> I have an issue with SQL reports. Once I set FixedHeader Property of Table
> used in SQl report TURE. The detail of data getting overlapped on fixed
> header of the report.
> Is there any way to resolve this?
> Thankin advance.
> Shailesh|||Thanks William...It works well.
"William" wrote:
> Set you header line(s) BackgroundColor to White instead of the default
> Transparent.
>
> "Shailesh K" wrote:
> > Hi All,
> >
> > I have an issue with SQL reports. Once I set FixedHeader Property of Table
> > used in SQl report TURE. The detail of data getting overlapped on fixed
> > header of the report.
> > Is there any way to resolve this?
> > Thankin advance.
> >
> > Shailesh
2012年3月9日星期五
Fit-to-page printing
How can I print reports to be fit-to-page. I have SP2 installed.
Are there any scripting or external assembly solutions ?
--
KolithaI have the same problem. I haven't installed SP yet...
Does anyone know how to do that?
Thanks
Chieko
"Kolitha de Silva" wrote:
> How can I print reports to be fit-to-page. I have SP2 installed.
> Are there any scripting or external assembly solutions ?
> --
> Kolitha
Are there any scripting or external assembly solutions ?
--
KolithaI have the same problem. I haven't installed SP yet...
Does anyone know how to do that?
Thanks
Chieko
"Kolitha de Silva" wrote:
> How can I print reports to be fit-to-page. I have SP2 installed.
> Are there any scripting or external assembly solutions ?
> --
> Kolitha
2012年2月26日星期日
First run of reports is SLOW
Hello all
I realize that the first time you run a report from RS it's slow because it
has to load everything up. Is there some way around this? Can I setup a
report to refresh itself every so often?
Anyway to turn this off? I hate the 30 second wait time to view the first
report...That is what I do, the official work around didn't work for me (IIS
configuration). If you have a report autorefresh every 5 minutes that will
keep everything ready to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
> Hello all
> I realize that the first time you run a report from RS it's slow because
> it
> has to load everything up. Is there some way around this? Can I setup a
> report to refresh itself every so often?
> Anyway to turn this off? I hate the 30 second wait time to view the first
> report...|||Link for official work around?
"Bruce L-C [MVP]" wrote:
> That is what I do, the official work around didn't work for me (IIS
> configuration). If you have a report autorefresh every 5 minutes that will
> keep everything ready to go.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John" <John@.discussions.microsoft.com> wrote in message
> news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
> > Hello all
> >
> > I realize that the first time you run a report from RS it's slow because
> > it
> > has to load everything up. Is there some way around this? Can I setup a
> > report to refresh itself every so often?
> >
> > Anyway to turn this off? I hate the 30 second wait time to view the first
> > report...
>
>|||I guess it is not "official" it is just less of a hack. I.e. adjust certain
IIS settings etc. Below is the posting from someone else describing this,
but I just have a report on my box that refreshes every 5 minutes (set this
via report properties I believe).
>>>>>>>
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris
>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:459E7222-BA43-436A-8980-96934C6FAC02@.microsoft.com...
> Link for official work around?
>
> "Bruce L-C [MVP]" wrote:
>> That is what I do, the official work around didn't work for me (IIS
>> configuration). If you have a report autorefresh every 5 minutes that
>> will
>> keep everything ready to go.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John" <John@.discussions.microsoft.com> wrote in message
>> news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
>> > Hello all
>> >
>> > I realize that the first time you run a report from RS it's slow
>> > because
>> > it
>> > has to load everything up. Is there some way around this? Can I setup
>> > a
>> > report to refresh itself every so often?
>> >
>> > Anyway to turn this off? I hate the 30 second wait time to view the
>> > first
>> > report...
>>|||Thanks Bruce. If the "hack" doesn't work I will just setup a report and have
it refresh every few minutes or so.
"Bruce L-C [MVP]" wrote:
> I guess it is not "official" it is just less of a hack. I.e. adjust certain
> IIS settings etc. Below is the posting from someone else describing this,
> but I just have a report on my box that refreshes every 5 minutes (set this
> via report properties I believe).
> >>>>>>>
> If you are running Windows 2003 server for your IIS reportserver, then this
> is a simple issue - I'll explain what happens:
> The report service engine, once it is idle for more than the default 20
> minutes, the worker process is shutdown.
> This is controlled by IIS.
> Open up the Internet Information Services (IIS) Manager
> Expand the server node then the application pools.
> On my IIS machine, I created an application pool dedicated to the
> reportserver & reportmanager virtual webs.
> But anyways, for the application pool that the reportserver is pointing to
> if you left everything to their defaults will be the DefaultAppPool.
> Right click the default app pool and select properties.
> There are two things that are checked by default - On the recycling tab
> there is a checkbox for recycling worker processes - it is currently set to
> 1740 minutes (29 hours). Leave it.
> The other one is on the performance tab - which is the one you are
> interested in changing...
> See the "Idle Timeout" section and increase the number of minutes to be 8
> hours a typical working day - 8*60 = 480 minutes.
> Next, to be sure the "morning person" that runs the first report doesn't get
> the delay, set up a schedule for either a dummy or adhoc report to fire off
> like at 6am so that the report component worker processes get loaded.
> I hope this helps you.
> There is no need to have a report fire off every minute to keep things
> alive - it is just that the report service was "unloaded" and needed to load
> back up.
> =-Chris
> >>>>>>>
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:459E7222-BA43-436A-8980-96934C6FAC02@.microsoft.com...
> > Link for official work around?
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> That is what I do, the official work around didn't work for me (IIS
> >> configuration). If you have a report autorefresh every 5 minutes that
> >> will
> >> keep everything ready to go.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "John" <John@.discussions.microsoft.com> wrote in message
> >> news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
> >> > Hello all
> >> >
> >> > I realize that the first time you run a report from RS it's slow
> >> > because
> >> > it
> >> > has to load everything up. Is there some way around this? Can I setup
> >> > a
> >> > report to refresh itself every so often?
> >> >
> >> > Anyway to turn this off? I hate the 30 second wait time to view the
> >> > first
> >> > report...
> >>
> >>
> >>
>
>|||I wouldn't call adjusting the properties of the app pool a "hack", but
really, "configuration".|||The reason I called it less of a hack is because the configuration of itself
doesn't do it. The last step was creating a subscription that ran every day.
My solution is a total hack but it is easy to do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"octavius@.gmail.com" <Octavius@.gmail.com> wrote in message
news:1126656232.440168.308260@.o13g2000cwo.googlegroups.com...
>I wouldn't call adjusting the properties of the app pool a "hack", but
> really, "configuration".
>
I realize that the first time you run a report from RS it's slow because it
has to load everything up. Is there some way around this? Can I setup a
report to refresh itself every so often?
Anyway to turn this off? I hate the 30 second wait time to view the first
report...That is what I do, the official work around didn't work for me (IIS
configuration). If you have a report autorefresh every 5 minutes that will
keep everything ready to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
> Hello all
> I realize that the first time you run a report from RS it's slow because
> it
> has to load everything up. Is there some way around this? Can I setup a
> report to refresh itself every so often?
> Anyway to turn this off? I hate the 30 second wait time to view the first
> report...|||Link for official work around?
"Bruce L-C [MVP]" wrote:
> That is what I do, the official work around didn't work for me (IIS
> configuration). If you have a report autorefresh every 5 minutes that will
> keep everything ready to go.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John" <John@.discussions.microsoft.com> wrote in message
> news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
> > Hello all
> >
> > I realize that the first time you run a report from RS it's slow because
> > it
> > has to load everything up. Is there some way around this? Can I setup a
> > report to refresh itself every so often?
> >
> > Anyway to turn this off? I hate the 30 second wait time to view the first
> > report...
>
>|||I guess it is not "official" it is just less of a hack. I.e. adjust certain
IIS settings etc. Below is the posting from someone else describing this,
but I just have a report on my box that refreshes every 5 minutes (set this
via report properties I believe).
>>>>>>>
If you are running Windows 2003 server for your IIS reportserver, then this
is a simple issue - I'll explain what happens:
The report service engine, once it is idle for more than the default 20
minutes, the worker process is shutdown.
This is controlled by IIS.
Open up the Internet Information Services (IIS) Manager
Expand the server node then the application pools.
On my IIS machine, I created an application pool dedicated to the
reportserver & reportmanager virtual webs.
But anyways, for the application pool that the reportserver is pointing to
if you left everything to their defaults will be the DefaultAppPool.
Right click the default app pool and select properties.
There are two things that are checked by default - On the recycling tab
there is a checkbox for recycling worker processes - it is currently set to
1740 minutes (29 hours). Leave it.
The other one is on the performance tab - which is the one you are
interested in changing...
See the "Idle Timeout" section and increase the number of minutes to be 8
hours a typical working day - 8*60 = 480 minutes.
Next, to be sure the "morning person" that runs the first report doesn't get
the delay, set up a schedule for either a dummy or adhoc report to fire off
like at 6am so that the report component worker processes get loaded.
I hope this helps you.
There is no need to have a report fire off every minute to keep things
alive - it is just that the report service was "unloaded" and needed to load
back up.
=-Chris
>>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John" <John@.discussions.microsoft.com> wrote in message
news:459E7222-BA43-436A-8980-96934C6FAC02@.microsoft.com...
> Link for official work around?
>
> "Bruce L-C [MVP]" wrote:
>> That is what I do, the official work around didn't work for me (IIS
>> configuration). If you have a report autorefresh every 5 minutes that
>> will
>> keep everything ready to go.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "John" <John@.discussions.microsoft.com> wrote in message
>> news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
>> > Hello all
>> >
>> > I realize that the first time you run a report from RS it's slow
>> > because
>> > it
>> > has to load everything up. Is there some way around this? Can I setup
>> > a
>> > report to refresh itself every so often?
>> >
>> > Anyway to turn this off? I hate the 30 second wait time to view the
>> > first
>> > report...
>>|||Thanks Bruce. If the "hack" doesn't work I will just setup a report and have
it refresh every few minutes or so.
"Bruce L-C [MVP]" wrote:
> I guess it is not "official" it is just less of a hack. I.e. adjust certain
> IIS settings etc. Below is the posting from someone else describing this,
> but I just have a report on my box that refreshes every 5 minutes (set this
> via report properties I believe).
> >>>>>>>
> If you are running Windows 2003 server for your IIS reportserver, then this
> is a simple issue - I'll explain what happens:
> The report service engine, once it is idle for more than the default 20
> minutes, the worker process is shutdown.
> This is controlled by IIS.
> Open up the Internet Information Services (IIS) Manager
> Expand the server node then the application pools.
> On my IIS machine, I created an application pool dedicated to the
> reportserver & reportmanager virtual webs.
> But anyways, for the application pool that the reportserver is pointing to
> if you left everything to their defaults will be the DefaultAppPool.
> Right click the default app pool and select properties.
> There are two things that are checked by default - On the recycling tab
> there is a checkbox for recycling worker processes - it is currently set to
> 1740 minutes (29 hours). Leave it.
> The other one is on the performance tab - which is the one you are
> interested in changing...
> See the "Idle Timeout" section and increase the number of minutes to be 8
> hours a typical working day - 8*60 = 480 minutes.
> Next, to be sure the "morning person" that runs the first report doesn't get
> the delay, set up a schedule for either a dummy or adhoc report to fire off
> like at 6am so that the report component worker processes get loaded.
> I hope this helps you.
> There is no need to have a report fire off every minute to keep things
> alive - it is just that the report service was "unloaded" and needed to load
> back up.
> =-Chris
> >>>>>>>
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:459E7222-BA43-436A-8980-96934C6FAC02@.microsoft.com...
> > Link for official work around?
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> That is what I do, the official work around didn't work for me (IIS
> >> configuration). If you have a report autorefresh every 5 minutes that
> >> will
> >> keep everything ready to go.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "John" <John@.discussions.microsoft.com> wrote in message
> >> news:BE1E4369-E18A-4AE2-8931-F8BC56E8D609@.microsoft.com...
> >> > Hello all
> >> >
> >> > I realize that the first time you run a report from RS it's slow
> >> > because
> >> > it
> >> > has to load everything up. Is there some way around this? Can I setup
> >> > a
> >> > report to refresh itself every so often?
> >> >
> >> > Anyway to turn this off? I hate the 30 second wait time to view the
> >> > first
> >> > report...
> >>
> >>
> >>
>
>|||I wouldn't call adjusting the properties of the app pool a "hack", but
really, "configuration".|||The reason I called it less of a hack is because the configuration of itself
doesn't do it. The last step was creating a subscription that ran every day.
My solution is a total hack but it is easy to do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"octavius@.gmail.com" <Octavius@.gmail.com> wrote in message
news:1126656232.440168.308260@.o13g2000cwo.googlegroups.com...
>I wouldn't call adjusting the properties of the app pool a "hack", but
> really, "configuration".
>
2012年2月19日星期日
Firefox Rendering Issues
Hi,
Anyone know how I can make reports render properly using Firefox?
When I look at reports, they are all squashed up in side a 4 cm tall iframe.
TIA
TonyGUpgrade to SQL Server 2005 when it comes out. I don't think they fixed it in
RS SP2.
"TG" wrote:
> Hi,
> Anyone know how I can make reports render properly using Firefox?
> When I look at reports, they are all squashed up in side a 4 cm tall iframe.
> TIA
> TonyG
>|||write a small javascript to disable the style
attribute of images.
Kanchana
"TG" wrote:
> Hi,
> Anyone know how I can make reports render properly using Firefox?
> When I look at reports, they are all squashed up in side a 4 cm tall iframe.
> TIA
> TonyG
>
Anyone know how I can make reports render properly using Firefox?
When I look at reports, they are all squashed up in side a 4 cm tall iframe.
TIA
TonyGUpgrade to SQL Server 2005 when it comes out. I don't think they fixed it in
RS SP2.
"TG" wrote:
> Hi,
> Anyone know how I can make reports render properly using Firefox?
> When I look at reports, they are all squashed up in side a 4 cm tall iframe.
> TIA
> TonyG
>|||write a small javascript to disable the style
attribute of images.
Kanchana
"TG" wrote:
> Hi,
> Anyone know how I can make reports render properly using Firefox?
> When I look at reports, they are all squashed up in side a 4 cm tall iframe.
> TIA
> TonyG
>
FireFox challenge/response
Hi all,
We're having a problem with one of our major clients. We developed a series
of SRS reports that works fine in Internet Explorer. However, when we
navigate to the site using Firefox 1.0, we get prompted to enter a
UserName/Password, which doesn't happen w/ IE. I have tried a lot of
different things to try to get rid of this, but I haven't found a way to do
so. Essentially, we have the Report Users group, which has Browse access to
the reports. All Domain Users are a member of this group. I have even
tried turning on Anonymous access to both the Reports and ReportServer
virtual directories, to no avail - the prompt keeps coming up.
Unfortunately, our client isn't very MS friendly, and we don't have the
ability to control which browser they use ... and at least half the company
is now using FireFox!
Help!!!
Thanks, JimJim wrote:
> Hi all,
> We're having a problem with one of our major clients. We developed a series
> of SRS reports that works fine in Internet Explorer. However, when we
> navigate to the site using Firefox 1.0, we get prompted to enter a
> UserName/Password, which doesn't happen w/ IE. I have tried a lot of
> different things to try to get rid of this, but I haven't found a way to do
> so. Essentially, we have the Report Users group, which has Browse access to
> the reports. All Domain Users are a member of this group. I have even
> tried turning on Anonymous access to both the Reports and ReportServer
> virtual directories, to no avail - the prompt keeps coming up.
> Unfortunately, our client isn't very MS friendly, and we don't have the
> ability to control which browser they use ... and at least half the company
> is now using FireFox!
> Help!!!
> Thanks, Jim
>|||Jim,
From my experience the only reason it doesn't happen in IE is because
you've set your RS site as a "Local Intranet" site within the Internet
Settings in Windows. IE then passes the users domain ID/PW
automatically thus bypassing the prompt to login. Firefox/Mozilla can't
do this so you the prompt will always comeup. You can tell your end
users they need to login then click the 'remember password' so they
atleast don't have to type in each time.
Re-reading you posting the above may not really apply, I guess it sounds
like you are linking directly to a report - and that report's datasource
is set to use the users creds for authentication when the report is run?
Same issue as above Firefox can't pass these autmagically like IE -
I'd suggest having the data source use a fixed domain ID/PW.
David
Jim wrote:
> Hi all,
> We're having a problem with one of our major clients. We developed a series
> of SRS reports that works fine in Internet Explorer. However, when we
> navigate to the site using Firefox 1.0, we get prompted to enter a
> UserName/Password, which doesn't happen w/ IE. I have tried a lot of
> different things to try to get rid of this, but I haven't found a way to do
> so. Essentially, we have the Report Users group, which has Browse access to
> the reports. All Domain Users are a member of this group. I have even
> tried turning on Anonymous access to both the Reports and ReportServer
> virtual directories, to no avail - the prompt keeps coming up.
> Unfortunately, our client isn't very MS friendly, and we don't have the
> ability to control which browser they use ... and at least half the company
> is now using FireFox!
> Help!!!
> Thanks, Jim
>
We're having a problem with one of our major clients. We developed a series
of SRS reports that works fine in Internet Explorer. However, when we
navigate to the site using Firefox 1.0, we get prompted to enter a
UserName/Password, which doesn't happen w/ IE. I have tried a lot of
different things to try to get rid of this, but I haven't found a way to do
so. Essentially, we have the Report Users group, which has Browse access to
the reports. All Domain Users are a member of this group. I have even
tried turning on Anonymous access to both the Reports and ReportServer
virtual directories, to no avail - the prompt keeps coming up.
Unfortunately, our client isn't very MS friendly, and we don't have the
ability to control which browser they use ... and at least half the company
is now using FireFox!
Help!!!
Thanks, JimJim wrote:
> Hi all,
> We're having a problem with one of our major clients. We developed a series
> of SRS reports that works fine in Internet Explorer. However, when we
> navigate to the site using Firefox 1.0, we get prompted to enter a
> UserName/Password, which doesn't happen w/ IE. I have tried a lot of
> different things to try to get rid of this, but I haven't found a way to do
> so. Essentially, we have the Report Users group, which has Browse access to
> the reports. All Domain Users are a member of this group. I have even
> tried turning on Anonymous access to both the Reports and ReportServer
> virtual directories, to no avail - the prompt keeps coming up.
> Unfortunately, our client isn't very MS friendly, and we don't have the
> ability to control which browser they use ... and at least half the company
> is now using FireFox!
> Help!!!
> Thanks, Jim
>|||Jim,
From my experience the only reason it doesn't happen in IE is because
you've set your RS site as a "Local Intranet" site within the Internet
Settings in Windows. IE then passes the users domain ID/PW
automatically thus bypassing the prompt to login. Firefox/Mozilla can't
do this so you the prompt will always comeup. You can tell your end
users they need to login then click the 'remember password' so they
atleast don't have to type in each time.
Re-reading you posting the above may not really apply, I guess it sounds
like you are linking directly to a report - and that report's datasource
is set to use the users creds for authentication when the report is run?
Same issue as above Firefox can't pass these autmagically like IE -
I'd suggest having the data source use a fixed domain ID/PW.
David
Jim wrote:
> Hi all,
> We're having a problem with one of our major clients. We developed a series
> of SRS reports that works fine in Internet Explorer. However, when we
> navigate to the site using Firefox 1.0, we get prompted to enter a
> UserName/Password, which doesn't happen w/ IE. I have tried a lot of
> different things to try to get rid of this, but I haven't found a way to do
> so. Essentially, we have the Report Users group, which has Browse access to
> the reports. All Domain Users are a member of this group. I have even
> tried turning on Anonymous access to both the Reports and ReportServer
> virtual directories, to no avail - the prompt keeps coming up.
> Unfortunately, our client isn't very MS friendly, and we don't have the
> ability to control which browser they use ... and at least half the company
> is now using FireFox!
> Help!!!
> Thanks, Jim
>
Firefox and IE 7 access to Web SQL Server Reports
Why are there problems with using FireFox and IE 7 with accessing the Web
interface for SQL 2005 Reports? I know that the Frame is the issue for
FireFox (is there an easy way to fix this') but I am running into problems
where IE7 just crashes when it connects to SQL Server Reporting Services.
Any ideas?
--
Matthew David
PH: 920.475.2972
FAX: 775.239.8171
mdavid@.matthewdavid.ws
New Books at http://www.cafepress.com/matthewdavid on Flash Rich Internet
ApplicationsI am running into this same problem. IE 7 with SQL Server Reports
shows the wrong information (none) and the frame is messed up.|||I am not having these issues at all and I'm running IE 7.
Can you tell me where it is crashing?
=-Chris
"Matthew David" <mdavid@.matthewdavid.ws> wrote in message
news:%23lhEq%23c%23GHA.3352@.TK2MSFTNGP03.phx.gbl...
> Why are there problems with using FireFox and IE 7 with accessing the Web
> interface for SQL 2005 Reports? I know that the Frame is the issue for
> FireFox (is there an easy way to fix this') but I am running into
> problems
> where IE7 just crashes when it connects to SQL Server Reporting Services.
> Any ideas?
> --
> Matthew David
> PH: 920.475.2972
> FAX: 775.239.8171
> mdavid@.matthewdavid.ws
> New Books at http://www.cafepress.com/matthewdavid on Flash Rich Internet
> Applications
>
interface for SQL 2005 Reports? I know that the Frame is the issue for
FireFox (is there an easy way to fix this') but I am running into problems
where IE7 just crashes when it connects to SQL Server Reporting Services.
Any ideas?
--
Matthew David
PH: 920.475.2972
FAX: 775.239.8171
mdavid@.matthewdavid.ws
New Books at http://www.cafepress.com/matthewdavid on Flash Rich Internet
ApplicationsI am running into this same problem. IE 7 with SQL Server Reports
shows the wrong information (none) and the frame is messed up.|||I am not having these issues at all and I'm running IE 7.
Can you tell me where it is crashing?
=-Chris
"Matthew David" <mdavid@.matthewdavid.ws> wrote in message
news:%23lhEq%23c%23GHA.3352@.TK2MSFTNGP03.phx.gbl...
> Why are there problems with using FireFox and IE 7 with accessing the Web
> interface for SQL 2005 Reports? I know that the Frame is the issue for
> FireFox (is there an easy way to fix this') but I am running into
> problems
> where IE7 just crashes when it connects to SQL Server Reporting Services.
> Any ideas?
> --
> Matthew David
> PH: 920.475.2972
> FAX: 775.239.8171
> mdavid@.matthewdavid.ws
> New Books at http://www.cafepress.com/matthewdavid on Flash Rich Internet
> Applications
>
Firefox
Does anyone know if Firefox rendering for HTML reports has been imporved in Katmai RS?
Michael
Did you try installing SP2? We made some fixes there. If there is a specific report that isn't working, you could post it to http://connect.microsoft.com. We don't have anything major planned for 2008.
|||Brian,
My matrix report still comes out very narrow (just a few pixels) per column, even with SP2. Is there a way to avoid this besides putting transparent gif's in the column?
Michael
|||Are you using the ReportViewer control to view the report? Or are you using Report Manager?
|||Actually, I'm calling the report through a web service, and having it render the HTML directly.
Michael
|||
Hi Michael,
We did address the issue you described in Service Pack 2 of SQL 2005. The fix required that we output slightly different HTML for IE vs. FireFox. When looking at the report through the ReportViewer control, all the appropriate user agent information is sent to the server so that the renderer can return the proper output. However, when rendering reports via the web service there is nothing that sends the user agent -- the solution is to do it yourself.
You should add the DeviceInfo parameter "UserAgent" and set the value to "Gecko". This will tell the renderer to emit FireFox HTML.
Best regards,
Chris
|||
Ah! Perfect. I'll give that a try. Thanks for the tip. I didn't see it in the instruction manual.
Michael
|||
Chris,
I tried that, and the result was a little better, although most of my borders did not display, the column width for the first two columns was off, and for some reason, the page brought my Firefox browser to a sluggish standstill, the kind you'd expect if you were viewing a 25MB HTML page. I can send you the before and after versions if you'd like.
Michael
|||Hi Michael, yes I would like to see the output that you are getting. Can you send me the HTML files?
Thanks,
Chris
|||
Yes, I will e-mail them right now.
Michael
|||
Chris,
I tried sending you the files to the e-mail listed in your profile, but my server said "Sorry, I couldn't find any host named online.microsoft.com.". What is the best way to get you the files?
Michael
|||
Hi Michael, that's weird... try removing the "online." part and try agian.
Thanks for your patience,
Chris
Firefox
Does anyone know if Firefox rendering for HTML reports has been imporved in Katmai RS?
Michael
Did you try installing SP2? We made some fixes there. If there is a specific report that isn't working, you could post it to http://connect.microsoft.com. We don't have anything major planned for 2008.
|||Brian,
My matrix report still comes out very narrow (just a few pixels) per column, even with SP2. Is there a way to avoid this besides putting transparent gif's in the column?
Michael
|||Are you using the ReportViewer control to view the report? Or are you using Report Manager?
|||Actually, I'm calling the report through a web service, and having it render the HTML directly.
Michael
|||
Hi Michael,
We did address the issue you described in Service Pack 2 of SQL 2005. The fix required that we output slightly different HTML for IE vs. FireFox. When looking at the report through the ReportViewer control, all the appropriate user agent information is sent to the server so that the renderer can return the proper output. However, when rendering reports via the web service there is nothing that sends the user agent -- the solution is to do it yourself.
You should add the DeviceInfo parameter "UserAgent" and set the value to "Gecko". This will tell the renderer to emit FireFox HTML.
Best regards,
Chris
|||
Ah! Perfect. I'll give that a try. Thanks for the tip. I didn't see it in the instruction manual.
Michael
|||
Chris,
I tried that, and the result was a little better, although most of my borders did not display, the column width for the first two columns was off, and for some reason, the page brought my Firefox browser to a sluggish standstill, the kind you'd expect if you were viewing a 25MB HTML page. I can send you the before and after versions if you'd like.
Michael
|||Hi Michael, yes I would like to see the output that you are getting. Can you send me the HTML files?
Thanks,
Chris
|||
Yes, I will e-mail them right now.
Michael
|||
Chris,
I tried sending you the files to the e-mail listed in your profile, but my server said "Sorry, I couldn't find any host named online.microsoft.com.". What is the best way to get you the files?
Michael
|||
Hi Michael, that's weird... try removing the "online." part and try agian.
Thanks for your patience,
Chris
Firefox
I'm currently developing a ASP.NET v2 application in VS 2005. Historically,
I've used Crystal Reports and I'm very familiar with that system. However,
this application needs to be hosted by an ISP on the internet so I'm now
constrained by the services offered by the hosting service.
When I've investigated Crystal hosting, the price jumps up significantly and
I was told by one hosting company that if I did find a Crystal hosting
service, they are probably using a dodgy licensing model. This project is
also cost constrained...
However, companies like www.discountasp.net offer SQL Server 2005 with
reporting services for just $15 a month which is great. I'm just watching
the webcasts from Microsoft and reporting services looks ideal and pretty
neat.
But I'm little concerned about cross-browser compatibility... does anyone
have any comments on this? Firefox is probably the only other browser that I
must support.
Thanks, Rob.
PS.On Jan 16, 5:51 pm, "Rob" <rob_nicholson@.nospam_unforgettable.com>
wrote:
> I'm currently developing a ASP.NET v2 application in VS 2005. Historically,
> I've used Crystal Reports and I'm very familiar with that system. However,
> this application needs to be hosted by an ISP on the internet so I'm now
> constrained by the services offered by the hosting service.
> When I've investigated Crystal hosting, the price jumps up significantly and
> I was told by one hosting company that if I did find a Crystal hosting
> service, they are probably using a dodgy licensing model. This project is
> also cost constrained...
> However, companies likewww.discountasp.netoffer SQL Server 2005 with
> reporting services for just $15 a month which is great. I'm just watching
> the webcasts from Microsoft and reporting services looks ideal and pretty
> neat.
> But I'm little concerned about cross-browser compatibility... does anyone
> have any comments on this? Firefox is probably the only other browser that I
> must support.
> Thanks, Rob.
> PS
Generally speaking, the compatibility is pretty good with Firefox in
comparison with IE6 and IE7. There are a few drawbacks however. One is
that when viewing reports directly in the Report Manager, IE shows the
entire report page in the initial view; whereas, Firefox has a
scrunched down version about one-third the normal height of the report
page, which requires vertical scrolling to view the entire report. The
search control that is naturally a part of the toolbar in the Report
Manager for IE, does not exist in Firefox (though the user can select
Ctrl+F to do a search on the current page in Firefox; but, not quite
the same thing). Also, drill through report functionality does not
work as well in Firefox as it does in IE. Otherwise, the main
differences between Crystal Reports and SSRS are that: there are
slightly different export options, they have a different production
licensing scheme and that Crystal Reports expression syntax is
different than that of SSRS, which uses VB.NET syntax. Also, CR has
been around longer and has a few minor functionality options that SSRS
does not. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
I've used Crystal Reports and I'm very familiar with that system. However,
this application needs to be hosted by an ISP on the internet so I'm now
constrained by the services offered by the hosting service.
When I've investigated Crystal hosting, the price jumps up significantly and
I was told by one hosting company that if I did find a Crystal hosting
service, they are probably using a dodgy licensing model. This project is
also cost constrained...
However, companies like www.discountasp.net offer SQL Server 2005 with
reporting services for just $15 a month which is great. I'm just watching
the webcasts from Microsoft and reporting services looks ideal and pretty
neat.
But I'm little concerned about cross-browser compatibility... does anyone
have any comments on this? Firefox is probably the only other browser that I
must support.
Thanks, Rob.
PS.On Jan 16, 5:51 pm, "Rob" <rob_nicholson@.nospam_unforgettable.com>
wrote:
> I'm currently developing a ASP.NET v2 application in VS 2005. Historically,
> I've used Crystal Reports and I'm very familiar with that system. However,
> this application needs to be hosted by an ISP on the internet so I'm now
> constrained by the services offered by the hosting service.
> When I've investigated Crystal hosting, the price jumps up significantly and
> I was told by one hosting company that if I did find a Crystal hosting
> service, they are probably using a dodgy licensing model. This project is
> also cost constrained...
> However, companies likewww.discountasp.netoffer SQL Server 2005 with
> reporting services for just $15 a month which is great. I'm just watching
> the webcasts from Microsoft and reporting services looks ideal and pretty
> neat.
> But I'm little concerned about cross-browser compatibility... does anyone
> have any comments on this? Firefox is probably the only other browser that I
> must support.
> Thanks, Rob.
> PS
Generally speaking, the compatibility is pretty good with Firefox in
comparison with IE6 and IE7. There are a few drawbacks however. One is
that when viewing reports directly in the Report Manager, IE shows the
entire report page in the initial view; whereas, Firefox has a
scrunched down version about one-third the normal height of the report
page, which requires vertical scrolling to view the entire report. The
search control that is naturally a part of the toolbar in the Report
Manager for IE, does not exist in Firefox (though the user can select
Ctrl+F to do a search on the current page in Firefox; but, not quite
the same thing). Also, drill through report functionality does not
work as well in Firefox as it does in IE. Otherwise, the main
differences between Crystal Reports and SSRS are that: there are
slightly different export options, they have a different production
licensing scheme and that Crystal Reports expression syntax is
different than that of SSRS, which uses VB.NET syntax. Also, CR has
been around longer and has a few minor functionality options that SSRS
does not. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
订阅：
博文 (Atom)