Report Error, Help!

Hi
I have beening trying to build a report with 2 parameters. When I run it
under VS.net, it all went well, but after I deploy it to the server, I got
the message as following: Reporting Services Error--The path of the item ''
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) Get Online Help
what went wrong, please help. TIAYou sure have to post your URL to help you.
Jens Suessmeyer.
"wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> Hi
> I have beening trying to build a report with 2 parameters. When I run it
> under VS.net, it all went well, but after I deploy it to the server, I got
> the message as following: Reporting Services Error--The path of the item
> ''
> is not valid. The full path must be less than 260 characters long, must
> start
> with slash; other restrictions apply. Check the documentation for complete
> set of restrictions. (rsInvalidItemPath) Get Online Help
> what went wrong, please help. TIA
>
>|||Sorry, the URL as following:
http://localhost/reportserver?%2fRev_Stats%2fRev_Stats&rs:Command=Render
"Jens Sü�meyer" wrote:
> You sure have to post your URL to help you.
> Jens Suessmeyer.
>
> "wd1153" <wd1153@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5138A906-7AA9-4D7A-A1B5-E3C9756BE7E1@.microsoft.com...
> > Hi
> >
> > I have beening trying to build a report with 2 parameters. When I run it
> > under VS.net, it all went well, but after I deploy it to the server, I got
> > the message as following: Reporting Services Error--The path of the item
> > ''
> > is not valid. The full path must be less than 260 characters long, must
> > start
> > with slash; other restrictions apply. Check the documentation for complete
> > set of restrictions. (rsInvalidItemPath) Get Online Help
> > what went wrong, please help. TIA
> >
> >
> >
>
>

Report Error when 2 pages for multiple records

We have a web app, built in .Net, with reporting services as our reporting
tool. The problem we are having is when we have a report that goes to
numerous people and the report is 2 pages long. When we make it 1 page,
legal size, it works fine (avg records are 500-900). When this report is
generated it is created in a pdf format. I can run it on report services
manager and in the viewer it takes approx 10 secs or less to run and render,
but when we create the pdf it spikes the processor up to 90% and if it's a 2
page report it generates an error.PDF's take significantly longer than HTML but it surprises me that a 2 page
report you see much of a difference. Do you have any service packs
installed. If not, my advice is to install SP2.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> We have a web app, built in .Net, with reporting services as our reporting
> tool. The problem we are having is when we have a report that goes to
> numerous people and the report is 2 pages long. When we make it 1 page,
> legal size, it works fine (avg records are 500-900). When this report is
> generated it is created in a pdf format. I can run it on report services
> manager and in the viewer it takes approx 10 secs or less to run and
> render,
> but when we create the pdf it spikes the processor up to 90% and if it's a
> 2
> page report it generates an error.|||I have all of the service packs installed. This is a 2 page report that
generates approx 950 pages. I have similar reports, but set to legal single
page, that generate over 1000 pages in pdf. The error message I get is:
"Server Error in '/' Application.
The underlying connection was closed: An unexpected error occurred on a
receive.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Net.WebException: The underlying connection was
closed: An unexpected error occurred on a receive.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[WebException: The underlying connection was closed: An unexpected error
occurred on a receive.]
System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
t request) +58
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
quest request) +5
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +183
LAMS.SQLReportServer.ReportingService.Render(String Report, String
Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding,
String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds) +141
LAMS.ReportViewer.RenderPDFReport() +618
LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750"
"Bruce L-C [MVP]" wrote:
> PDF's take significantly longer than HTML but it surprises me that a 2 page
> report you see much of a difference. Do you have any service packs
> installed. If not, my advice is to install SP2.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> > We have a web app, built in .Net, with reporting services as our reporting
> > tool. The problem we are having is when we have a report that goes to
> > numerous people and the report is 2 pages long. When we make it 1 page,
> > legal size, it works fine (avg records are 500-900). When this report is
> > generated it is created in a pdf format. I can run it on report services
> > manager and in the viewer it takes approx 10 secs or less to run and
> > render,
> > but when we create the pdf it spikes the processor up to 90% and if it's a
> > 2
> > page report it generates an error.
>
>|||OK, we had a failure to communicate. You said a 2 page report and I thought
it was 2 pages long. You mean 2 pages per record.
RS renders everything in RAM. Formats make a big difference in CPU
utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
much much more intensive in resources required. My personal feeling is that
when you are talking about that many pages it is an inappropriate use of RS.
It is just not designed to be outputting 1000 pages of PDF. Users cannot
look at that many pages anyway. You should consider drill through technique.
Show the users what they need to see. I do know that sometimes users need to
pull data into another program but that is not what PDF format is used for.
Excel is another matter (although Excel can't handle 100,000 rows either).
For Excel you could use CSV to get around this. For PDF there is no work
around. More RAM helps but you really are overloading the server when you
are doing this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
>I have all of the service packs installed. This is a 2 page report that
> generates approx 950 pages. I have similar reports, but set to legal
> single
> page, that generate over 1000 pages in pdf. The error message I get is:
> "Server Error in '/' Application.
> The underlying connection was closed: An unexpected error occurred on a
> receive.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Net.WebException: The underlying connection was
> closed: An unexpected error occurred on a receive.
> Source Error:
> An unhandled exception was generated during the execution of the current
> web
> request. Information regarding the origin and location of the exception
> can
> be identified using the exception stack trace below.
> Stack Trace:
> [WebException: The underlying connection was closed: An unexpected error
> occurred on a receive.]
> System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> t request) +58
> System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> quest request) +5
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +183
> LAMS.SQLReportServer.ReportingService.Render(String Report, String
> Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
> DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> Encoding,
> String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds) +141
> LAMS.ReportViewer.RenderPDFReport() +618
> LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +750"
> "Bruce L-C [MVP]" wrote:
>> PDF's take significantly longer than HTML but it surprises me that a 2
>> page
>> report you see much of a difference. Do you have any service packs
>> installed. If not, my advice is to install SP2.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
>> > We have a web app, built in .Net, with reporting services as our
>> > reporting
>> > tool. The problem we are having is when we have a report that goes to
>> > numerous people and the report is 2 pages long. When we make it 1
>> > page,
>> > legal size, it works fine (avg records are 500-900). When this report
>> > is
>> > generated it is created in a pdf format. I can run it on report
>> > services
>> > manager and in the viewer it takes approx 10 secs or less to run and
>> > render,
>> > but when we create the pdf it spikes the processor up to 90% and if
>> > it's a
>> > 2
>> > page report it generates an error.
>>|||Thanks for the input. The only problem is this is our leasing application
and we have to print mass batch of renewals once a year. I am thinking of
setting it on a schedule but that would remove a data range filter that is in
place and is changable by the user. Any suggestions?
"Bruce L-C [MVP]" wrote:
> OK, we had a failure to communicate. You said a 2 page report and I thought
> it was 2 pages long. You mean 2 pages per record.
> RS renders everything in RAM. Formats make a big difference in CPU
> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
> much much more intensive in resources required. My personal feeling is that
> when you are talking about that many pages it is an inappropriate use of RS.
> It is just not designed to be outputting 1000 pages of PDF. Users cannot
> look at that many pages anyway. You should consider drill through technique.
> Show the users what they need to see. I do know that sometimes users need to
> pull data into another program but that is not what PDF format is used for.
> Excel is another matter (although Excel can't handle 100,000 rows either).
> For Excel you could use CSV to get around this. For PDF there is no work
> around. More RAM helps but you really are overloading the server when you
> are doing this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
> >I have all of the service packs installed. This is a 2 page report that
> > generates approx 950 pages. I have similar reports, but set to legal
> > single
> > page, that generate over 1000 pages in pdf. The error message I get is:
> >
> > "Server Error in '/' Application.
> > The underlying connection was closed: An unexpected error occurred on a
> > receive.
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information
> > about
> > the error and where it originated in the code.
> > Exception Details: System.Net.WebException: The underlying connection was
> > closed: An unexpected error occurred on a receive.
> > Source Error:
> > An unhandled exception was generated during the execution of the current
> > web
> > request. Information regarding the origin and location of the exception
> > can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> > [WebException: The underlying connection was closed: An unexpected error
> > occurred on a receive.]
> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> > t request) +58
> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> > quest request) +5
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +183
> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
> > Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters,
> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> > Encoding,
> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> > String[]& StreamIds) +141
> > LAMS.ReportViewer.RenderPDFReport() +618
> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> > System.Web.UI.Control.LoadRecursive() +35
> > System.Web.UI.Page.ProcessRequestMain() +750"
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> PDF's take significantly longer than HTML but it surprises me that a 2
> >> page
> >> report you see much of a difference. Do you have any service packs
> >> installed. If not, my advice is to install SP2.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> >> > We have a web app, built in .Net, with reporting services as our
> >> > reporting
> >> > tool. The problem we are having is when we have a report that goes to
> >> > numerous people and the report is 2 pages long. When we make it 1
> >> > page,
> >> > legal size, it works fine (avg records are 500-900). When this report
> >> > is
> >> > generated it is created in a pdf format. I can run it on report
> >> > services
> >> > manager and in the viewer it takes approx 10 secs or less to run and
> >> > render,
> >> > but when we create the pdf it spikes the processor up to 90% and if
> >> > it's a
> >> > 2
> >> > page report it generates an error.
> >>
> >>
> >>
>
>|||If you can have parameters that allows you to do a subset then schedule the
report multiple times just varying the parameter and print say 100 pages at
a time.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:6B4C566B-C41C-49FD-BF58-2FCD7B9656E3@.microsoft.com...
> Thanks for the input. The only problem is this is our leasing application
> and we have to print mass batch of renewals once a year. I am thinking of
> setting it on a schedule but that would remove a data range filter that is
> in
> place and is changable by the user. Any suggestions?
> "Bruce L-C [MVP]" wrote:
>> OK, we had a failure to communicate. You said a 2 page report and I
>> thought
>> it was 2 pages long. You mean 2 pages per record.
>> RS renders everything in RAM. Formats make a big difference in CPU
>> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
>> much much more intensive in resources required. My personal feeling is
>> that
>> when you are talking about that many pages it is an inappropriate use of
>> RS.
>> It is just not designed to be outputting 1000 pages of PDF. Users cannot
>> look at that many pages anyway. You should consider drill through
>> technique.
>> Show the users what they need to see. I do know that sometimes users need
>> to
>> pull data into another program but that is not what PDF format is used
>> for.
>> Excel is another matter (although Excel can't handle 100,000 rows
>> either).
>> For Excel you could use CSV to get around this. For PDF there is no work
>> around. More RAM helps but you really are overloading the server when you
>> are doing this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
>> >I have all of the service packs installed. This is a 2 page report that
>> > generates approx 950 pages. I have similar reports, but set to legal
>> > single
>> > page, that generate over 1000 pages in pdf. The error message I get
>> > is:
>> >
>> > "Server Error in '/' Application.
>> > The underlying connection was closed: An unexpected error occurred on a
>> > receive.
>> > Description: An unhandled exception occurred during the execution of
>> > the
>> > current web request. Please review the stack trace for more information
>> > about
>> > the error and where it originated in the code.
>> > Exception Details: System.Net.WebException: The underlying connection
>> > was
>> > closed: An unexpected error occurred on a receive.
>> > Source Error:
>> > An unhandled exception was generated during the execution of the
>> > current
>> > web
>> > request. Information regarding the origin and location of the exception
>> > can
>> > be identified using the exception stack trace below.
>> >
>> > Stack Trace:
>> > [WebException: The underlying connection was closed: An unexpected
>> > error
>> > occurred on a receive.]
>> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
>> > t request) +58
>> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
>> > quest request) +5
>> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
>> > methodName, Object[] parameters) +183
>> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
>> > Format, String HistoryID, String DeviceInfo, ParameterValue[]
>> > Parameters,
>> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
>> > Encoding,
>> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]&
>> > Warnings,
>> > String[]& StreamIds) +141
>> > LAMS.ReportViewer.RenderPDFReport() +618
>> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
>> > System.Web.UI.Control.OnLoad(EventArgs e) +67
>> > System.Web.UI.Control.LoadRecursive() +35
>> > System.Web.UI.Page.ProcessRequestMain() +750"
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> PDF's take significantly longer than HTML but it surprises me that a 2
>> >> page
>> >> report you see much of a difference. Do you have any service packs
>> >> installed. If not, my advice is to install SP2.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
>> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
>> >> > We have a web app, built in .Net, with reporting services as our
>> >> > reporting
>> >> > tool. The problem we are having is when we have a report that goes
>> >> > to
>> >> > numerous people and the report is 2 pages long. When we make it 1
>> >> > page,
>> >> > legal size, it works fine (avg records are 500-900). When this
>> >> > report
>> >> > is
>> >> > generated it is created in a pdf format. I can run it on report
>> >> > services
>> >> > manager and in the viewer it takes approx 10 secs or less to run and
>> >> > render,
>> >> > but when we create the pdf it spikes the processor up to 90% and if
>> >> > it's a
>> >> > 2
>> >> > page report it generates an error.
>> >>
>> >>
>> >>
>>|||Thanks a bunch for the info Bruce.
"Bruce L-C [MVP]" wrote:
> If you can have parameters that allows you to do a subset then schedule the
> report multiple times just varying the parameter and print say 100 pages at
> a time.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:6B4C566B-C41C-49FD-BF58-2FCD7B9656E3@.microsoft.com...
> > Thanks for the input. The only problem is this is our leasing application
> > and we have to print mass batch of renewals once a year. I am thinking of
> > setting it on a schedule but that would remove a data range filter that is
> > in
> > place and is changable by the user. Any suggestions?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> OK, we had a failure to communicate. You said a 2 page report and I
> >> thought
> >> it was 2 pages long. You mean 2 pages per record.
> >>
> >> RS renders everything in RAM. Formats make a big difference in CPU
> >> utilizations. CSV, HTML are very fast. PDF and Excel are much slower and
> >> much much more intensive in resources required. My personal feeling is
> >> that
> >> when you are talking about that many pages it is an inappropriate use of
> >> RS.
> >> It is just not designed to be outputting 1000 pages of PDF. Users cannot
> >> look at that many pages anyway. You should consider drill through
> >> technique.
> >> Show the users what they need to see. I do know that sometimes users need
> >> to
> >> pull data into another program but that is not what PDF format is used
> >> for.
> >> Excel is another matter (although Excel can't handle 100,000 rows
> >> either).
> >> For Excel you could use CSV to get around this. For PDF there is no work
> >> around. More RAM helps but you really are overloading the server when you
> >> are doing this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> news:790D7C48-1AB7-4F2A-A1C3-A1CF679B9B52@.microsoft.com...
> >> >I have all of the service packs installed. This is a 2 page report that
> >> > generates approx 950 pages. I have similar reports, but set to legal
> >> > single
> >> > page, that generate over 1000 pages in pdf. The error message I get
> >> > is:
> >> >
> >> > "Server Error in '/' Application.
> >> > The underlying connection was closed: An unexpected error occurred on a
> >> > receive.
> >> > Description: An unhandled exception occurred during the execution of
> >> > the
> >> > current web request. Please review the stack trace for more information
> >> > about
> >> > the error and where it originated in the code.
> >> > Exception Details: System.Net.WebException: The underlying connection
> >> > was
> >> > closed: An unexpected error occurred on a receive.
> >> > Source Error:
> >> > An unhandled exception was generated during the execution of the
> >> > current
> >> > web
> >> > request. Information regarding the origin and location of the exception
> >> > can
> >> > be identified using the exception stack trace below.
> >> >
> >> > Stack Trace:
> >> > [WebException: The underlying connection was closed: An unexpected
> >> > error
> >> > occurred on a receive.]
> >> > System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebReques
> >> > t request) +58
> >> > System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRe
> >> > quest request) +5
> >> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> >> > methodName, Object[] parameters) +183
> >> > LAMS.SQLReportServer.ReportingService.Render(String Report, String
> >> > Format, String HistoryID, String DeviceInfo, ParameterValue[]
> >> > Parameters,
> >> > DataSourceCredentials[] Credentials, String ShowHideToggle, String&
> >> > Encoding,
> >> > String& MimeType, ParameterValue[]& ParametersUsed, Warning[]&
> >> > Warnings,
> >> > String[]& StreamIds) +141
> >> > LAMS.ReportViewer.RenderPDFReport() +618
> >> > LAMS.ReportViewer.Page_Load(Object sender, EventArgs e) +88
> >> > System.Web.UI.Control.OnLoad(EventArgs e) +67
> >> > System.Web.UI.Control.LoadRecursive() +35
> >> > System.Web.UI.Page.ProcessRequestMain() +750"
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> PDF's take significantly longer than HTML but it surprises me that a 2
> >> >> page
> >> >> report you see much of a difference. Do you have any service packs
> >> >> installed. If not, my advice is to install SP2.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> >> >> news:BBA2388F-E062-4368-987A-62CD9298BD14@.microsoft.com...
> >> >> > We have a web app, built in .Net, with reporting services as our
> >> >> > reporting
> >> >> > tool. The problem we are having is when we have a report that goes
> >> >> > to
> >> >> > numerous people and the report is 2 pages long. When we make it 1
> >> >> > page,
> >> >> > legal size, it works fine (avg records are 500-900). When this
> >> >> > report
> >> >> > is
> >> >> > generated it is created in a pdf format. I can run it on report
> >> >> > services
> >> >> > manager and in the viewer it takes approx 10 secs or less to run and
> >> >> > render,
> >> >> > but when we create the pdf it spikes the processor up to 90% and if
> >> >> > it's a
> >> >> > 2
> >> >> > page report it generates an error.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

Report error

Hi all,

I just setup SQL 2005 Report Service, and then I used the browser to view the "folder.aspx"

Nothing showed up but I received an error page with the message like the following:

"The request failed with HTTP status 400: Bad Request."

So, what did I do wrong?

Thanks,

Frank

System Engineer

Start debugging with your http://localhost/reportserver. How were the RS virtual directories created? Try creating them using the configuration tools, and re-apply the script mappings.|||If the suggestions from James is not working, try to dive deeper into the error of the reporting services engine, by setting the logging mode to verbose and see where the error is based on. If you have a blank report server with not much reports one, try to reinstall the whole thing, that is sometimes better than (try) fixing the issues that popup. I had that a while ago, the cause was that there were file locks on the files that needed to be changed. The installer didn′t pop up a message and *bump* there were many erros coming up regarding authentication etc.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report erroe

Hi All ,

i got tired from the component crytsal reports but i need it to finish an application i'm building .

i got the folloiwng error when i try to run the report.

ONE : Cannot implicitly convert type 'CrystalDecisions.Shared.TableLogOnInfos' to 'CrystalDecisions.Shared.TableLogOnInfo'

TWO: foreach statement cannot operate on variables of type 'CrystalDecisions.Shared.TableLogOnInfo' because 'CrystalDecisions.Shared.TableLogOnInfo' does not contain a public definition for 'GetEnumerator'

and here is the code that i'm using:

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace Hope
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void ConfigureCrystalReports()
{

ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "NorthWind";
connectionInfo.UserID = "";
connectionInfo.Password = "";

string reportPath = Application.StartupPath + "\\" +
"NorthwindCustomers.rpt";
crystalReportViewer.ReportSource = reportPath;



SetDBLogonForReport(connectionInfo);

}

private void Form1_Load(object sender, EventArgs e)
{
ConfigureCrystalReports();

}

private void SetDBLogonForReport(ConnectionInfo connectionInfo)
{
TableLogOnInfo tableLogOnInfos = crystalReportViewer.LogOnInfo;

foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
{
tableLogOnInfo.ConnectionInfo = connectionInfo;
}


please try to help me find out , what's the problem , i'll get mad soon,hi
this is saurabh

i have creating a crystal report. in this report i want inserting no. of images .
can i put these images directly into the folders.
without saving in database.

plz... give reply as soon as possible....!|||Are you jokking ,

why to post here in my thread , create your own.

i'm so amazed from your action ,

Report equivalent of a <BR> or a vbCrLf

What do I have to embed in my data to get a report cell to line break?

If I have:
ABC?XYZ

what do I have to store in the ? position to get it to look like:
ABC
XYZ

in my report?

Try with \n or \r or \n\r.
But I don't understand how you convert ? to this characters. Are you evaluating an expression or this is data from a dataset?
If you are evaluating an expression put "first string"+CHAR(13)+"last string"
Can you be more specific?|||

The data is from a Dataset. What I'm trying to figure out is what can I put in the data to make a Report perform a line break? Whatever I put in there is just take as part of the data. I've tried putting:ABC\n\rXYZ and that's exactly what shows up in the cell on the report.

|||If you are using T-SQL and you are making the dataset from a query try this:
SELECT field1+CHAR(13)+field2
or
SELECT field1+CHAR(10)+CHAR(13)+field2
tell me if it works!!!|||Yeah close enough. I embeded char(13) & char(10) when I save the data and it displayed fine in the report.

Thanks
Steve|||I think you can also split the column in an expression and use vbcrlf. e.g string1 & vbcrlf & string2|||It's faster solving that in the dataset than in the report side.
But it's valid too and it's good to know as many ways to solve problem as you can.sql

Report Engine

Does Report Services 2005 have a Report Distribution engine. So that I
can for instance say; I want user 'A' to get report 'B' in a format of
'C' at 17:05 every day.
Many thanks
DavidYes, it is called Subscriptions. You can specify all of that. It is
available both Standard and Enterprise. However, Enterprise adds data driven
subscriptions.
Here is from books online about data driven subscriptions:
>>>
A data-driven subscription provides a way to deliver reports to a list of
subscribers that is determined at run time. You can use data-driven
subscriptions as follows:
a.. Customize report output at run time for each recipient of a delivery.
b.. Support the wide distribution of a report with a fluctuating list of
subscribers. For example, you can use data-driven subscriptions to
distribute a report throughout a large organization where subscribers vary
from one month to the next, or use other criteria that determines group
membership from an existing set of users.
A data-driven subscription differs from a standard subscription in the way
it gets subscription information. A data-driven subscription gets some
settings from a data source at run time, and other settings from the
subscription definition. Fixed aspects of a data-driven subscription include
the report that is delivered, the delivery extension, connection information
to an external data source that contains subscriber data, and a query that
retrieves subscription information. Dynamic settings of the subscription are
obtained from the query, including a subscriber list and user-specific
delivery extension preferences or parameter values. This data is retrieved
from a data source each time the subscription is processed.
>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<davidswain2005@.yahoo.co.uk> wrote in message
news:1141318397.513927.57680@.i39g2000cwa.googlegroups.com...
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>|||Yes, it's called creating a subscription
"davidswain2005@.yahoo.co.uk" wrote:
> Does Report Services 2005 have a Report Distribution engine. So that I
> can for instance say; I want user 'A' to get report 'B' in a format of
> 'C' at 17:05 every day.
>
> Many thanks
> David
>

Report empty?

I have created a basic report that just shows some columns from a query, I'm using a dataadapter and the reportviewer component.

If I execute the query it calles it returns some rows, but the report is empty.

What's wrong with the reportviewer and the report objects?

I'm thinking about just using gridviews because the reports don't work, altough I'd like to use the reportviewer because it can export to excel/pdf.

Thanks.

HI,onishirox:

I can not debug it without any codes from your scenario, but you can have a check with this following walkround to make your codes work:

Binding Data to the ReportViewer Control Dynamically in ASP.NET 2.0 -

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/1/

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be

of assistance

|||

HI,onishirox:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

|||

Thanks. I think the problem was that I was using sqlserver2000, seems to work ok now with sql2005.

Report effective permissions for all users?

As our customers demand that we tighten our IT security in the company,
I've been asked to prepare a report quarterly showing, for each user in
Active directory, what his effective permissions are for every table in
every database that he has permission for on our SQL Server 2000 server. I
searched a bit for a tool to do this, but all I found was the PERMISSIONS()
function for showing effective permissions of the current user. Is there
any way to do it for an arbitrary user, without logging in as them?Ross Presser (rpresser@.imtek.com) writes:
> As our customers demand that we tighten our IT security in the company,
> I've been asked to prepare a report quarterly showing, for each user in
> Active directory, what his effective permissions are for every table in
> every database that he has permission for on our SQL Server 2000 server.
> I searched a bit for a tool to do this, but all I found was the
> PERMISSIONS() function for showing effective permissions of the current
> user. Is there any way to do it for an arbitrary user, without logging
> in as them?

You would have to trawl system tables like syspermissions for this. I
decline to provide any samples, because you need account for roles,
including fixed server roles.

This you would do per database. You could set up views for all system
tables that are of interest like:

CREATE VIEW serverpermissions AS
SELECT dbname = 'master', * FROM master.dbo.syspermissions
UNION ALL
SELECT 'model', * FROM model.dbo.syspermissions
UNION ALL
...

Preferably such views would be built dynamically.

I would estimate that the devlopment time for a correct report would be
at least 40 hours. And it might produces over 100 pages of output that
I doubt that no one will ever get through.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On Wed, 15 Sep 2004 22:19:42 +0000 (UTC), Erland Sommarskog wrote:

> Ross Presser (rpresser@.imtek.com) writes:
>> As our customers demand that we tighten our IT security in the company,
>> I've been asked to prepare a report quarterly showing, for each user in
>> Active directory, what his effective permissions are for every table in
>> every database that he has permission for on our SQL Server 2000 server.
>> I searched a bit for a tool to do this, but all I found was the
>> PERMISSIONS() function for showing effective permissions of the current
>> user. Is there any way to do it for an arbitrary user, without logging
>> in as them?
> You would have to trawl system tables like syspermissions for this. I
> decline to provide any samples, because you need account for roles,
> including fixed server roles.
> This you would do per database. You could set up views for all system
> tables that are of interest like:
> CREATE VIEW serverpermissions AS
> SELECT dbname = 'master', * FROM master.dbo.syspermissions
> UNION ALL
> SELECT 'model', * FROM model.dbo.syspermissions
> UNION ALL
> ...
> Preferably such views would be built dynamically.
> I would estimate that the devlopment time for a correct report would be
> at least 40 hours. And it might produces over 100 pages of output that
> I doubt that no one will ever get through.

Well, I may have talked them down somewhat. Here's what I offered them:

http://www.sql-server-performance.com/rd_auditing2.asp has a stored
procedure that will list all roles that each database user belongs to.

The system stored procedure sp_helprotect lists all explicitly granted
permissions in the database, whether to a role or a database user, but not
including the system defined server roles or database roles like db_reader.

The system stored procedure sp_helplogins shows all the logins defined on
the server, and which database user and roles they map to in each database.

Between these three, I can picture a script that enumerates effective
permissions on each database object. for each sql login. Such a chart would
probably be 10-30 pages long at our site.

The last piece would be a script that takes each Active Directory user and
determines which sql login would apply. Determining a user's permissions
would then require looking up their AD user to find the sql login, then
looking up the sql login to find the permissions.

Looking forward, we plan to revise our security so that:
(a) all permissions are set at the user-defined role level
(b) no logins (except sa) are assigned to any system-defined server or
database roles
(c) sa is the dbo of all databases

What do you think?|||Ross Presser (rpresser@.imtek.com) writes:
> Looking forward, we plan to revise our security so that:
> (a) all permissions are set at the user-defined role level
> (b) no logins (except sa) are assigned to any system-defined server or
> database roles
> (c) sa is the dbo of all databases
> What do you think?

This does not sound right to me. It sounds almost right, but if I understand
this alright, all administration will be performed thruogh the "sa" account.
If you have exactly one DBA who knows this password, that is OK.

If you have more than one DBA, each one who is entitled to do admin
work on the server should be granted admin rights, either explicitly
or through BUILTIN/Administrators.

Anonymous high-power accounts like "sa" is not a good thing, since this
makes impossible to hold anyone accountable.

But plain users should be granted access through roles, and not by user.
And having only plain users and sysadmin users makes things a little easier.
But for security it's only good if you can afford to give anyone who needs
to something beyond simple access admin rights.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||>> What do you think?
> This does not sound right to me. It sounds almost right, but if I understand
> this alright, all administration will be performed thruogh the "sa" account.
> If you have exactly one DBA who knows this password, that is OK.
> If you have more than one DBA, each one who is entitled to do admin
> work on the server should be granted admin rights, either explicitly
> or through BUILTIN/Administrators.
> Anonymous high-power accounts like "sa" is not a good thing, since this
> makes impossible to hold anyone accountable.
> But plain users should be granted access through roles, and not by user.
> And having only plain users and sysadmin users makes things a little easier.
> But for security it's only good if you can afford to give anyone who needs
> to something beyond simple access admin rights.

Very good point, but not quite what I intended. Although sa would be the
dbo, administration would be done through non-sa accounts that belonged to
user-defined roles that had been granted the needed admin rights, at
whatever granularity was needed.

I just didn't want any users getting rights that were not from roles, by
virtue of them being the dbo of a database (or owner of a table, etc.)

But now that I type these words, I realize that to prevent users from
owning databases or other objects, I will have to do all admin as sa, just
like you said! That's not very good...

Can the owner of an object be reassigned by some stored proc? Then I could
create the table as rpresser then immediately reassign it to sa (still as
rpresser).|||Ross Presser (rpresser@.imtek.com) writes:
> Can the owner of an object be reassigned by some stored proc? Then I could
> create the table as rpresser then immediately reassign it to sa (still as
> rpresser).

sp_changeobjectowner. rpresser would then have to have dbo permissions to
do this.

And in such case you should just as well say CREATE TABLE dbo.ladida the
first time round.

But I would suggest that it is better that you are logged in as
DOMAIN\rpresser and this account is a member of BUILTIN\Administrator.

You may want to pursue the topic in microsoft.sqlserver.public.security.
I might not be able to contribute more on the thread, since I'm going away
on holiday tomorrow.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Report dynamic fields

Hi all,
I need to let my report user to select the columes in the report:
I want to make a report with all the relevant fileds .
the user will have window that read the rdl file and display all the reports
fields.
The user can select only the columes he need from the colume list.
How can I doit ?
Can I change the rdl file before the user use the report ?
10x,
Shachar.My suggestion if you decide to do this is to use RS 2005 (out in November).
RS 2005 along with the new controls shipping with Visual Studio 2005 will
make this much much easier than trying to do this with RS 2000. RS 2000 is
totally server based. You would have to deploy your new RDL (uniquely names,
remember you are server based) and then get your client to execute that
report (using either URL integration or web services). Then you would need
to remove it when done. With the new control with VS 2005 you can operate in
local mode where you give it a dataset and the rdl. No deployment necessary.
If all your reports are done this way then you don't even need the server
product, just the new controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shachar" <me@.use.com> wrote in message
news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I need to let my report user to select the columes in the report:
> I want to make a report with all the relevant fileds .
> the user will have window that read the rdl file and display all the
> reports fields.
> The user can select only the columes he need from the colume list.
> How can I doit ?
> Can I change the rdl file before the user use the report ?
> 10x,
> Shachar.
>|||What if the application is a web base apllication ?
What is the right colume filter solutuin ?
10x,
Liz.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> My suggestion if you decide to do this is to use RS 2005 (out in
November).
> RS 2005 along with the new controls shipping with Visual Studio 2005 will
> make this much much easier than trying to do this with RS 2000. RS 2000 is
> totally server based. You would have to deploy your new RDL (uniquely
names,
> remember you are server based) and then get your client to execute that
> report (using either URL integration or web services). Then you would need
> to remove it when done. With the new control with VS 2005 you can operate
in
> local mode where you give it a dataset and the rdl. No deployment
necessary.
> If all your reports are done this way then you don't even need the server
> product, just the new controls.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shachar" <me@.use.com> wrote in message
> news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > I need to let my report user to select the columes in the report:
> > I want to make a report with all the relevant fileds .
> > the user will have window that read the rdl file and display all the
> > reports fields.
> > The user can select only the columes he need from the colume list.
> >
> > How can I doit ?
> > Can I change the rdl file before the user use the report ?
> >
> > 10x,
> >
> > Shachar.
> >
>|||I use RS 2005 .
"Liz Matyas" <lizmts@.mail.com> wrote in message
news:Ozf7%23yopFHA.3064@.TK2MSFTNGP15.phx.gbl...
> What if the application is a web base apllication ?
> What is the right colume filter solutuin ?
> 10x,
> Liz.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OlEEZcmpFHA.272@.TK2MSFTNGP15.phx.gbl...
> > My suggestion if you decide to do this is to use RS 2005 (out in
> November).
> > RS 2005 along with the new controls shipping with Visual Studio 2005
will
> > make this much much easier than trying to do this with RS 2000. RS 2000
is
> > totally server based. You would have to deploy your new RDL (uniquely
> names,
> > remember you are server based) and then get your client to execute that
> > report (using either URL integration or web services). Then you would
need
> > to remove it when done. With the new control with VS 2005 you can
operate
> in
> > local mode where you give it a dataset and the rdl. No deployment
> necessary.
> > If all your reports are done this way then you don't even need the
server
> > product, just the new controls.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Shachar" <me@.use.com> wrote in message
> > news:OXJyiTlpFHA.3040@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > I need to let my report user to select the columes in the report:
> > > I want to make a report with all the relevant fileds .
> > > the user will have window that read the rdl file and display all the
> > > reports fields.
> > > The user can select only the columes he need from the colume list.
> > >
> > > How can I doit ?
> > > Can I change the rdl file before the user use the report ?
> > >
> > > 10x,
> > >
> > > Shachar.
> > >
> >
> >
>

Report drilldown still a major issue - HotFix needed!

While testing the latest RC1 SRS software and trying to get report drill down
in a chart working, I found that it was not working as expected. I thought
that this might be a Dundas issue, but has since learned that this is a MS
issue.
I understand that MS is aware of this and I strongly believe that this needs
to be fixed via HotFix rather than waiting until release time or later. We
are working towards a Spring 2006 release of our software and report
drilldown is one of the most important elements of our application.
Has anyone else ran into this issue?
Thanks!
KeithThis sound like you need a fix. I would contact Microsoft Product Support
Services. If it is indeed a fix and not user error, all fees are refunded.
If you specific details on what the bug is, I can look it up and see if it
is fixed if it is something we know about.
bradsy@.microsoft.com
--
| Thread-Topic: Report drilldown still a major issue - HotFix needed!!
| thread-index: AcXERUgoHQxmMZhhRD29mQIbnrU+Aw==| X-WBNR-Posting-Host: 66.89.74.203
| From: "=?Utf-8?B?S2VpdGg=?=" <Keith@.discussions.microsoft.com>
| Subject: Report drilldown still a major issue - HotFix needed!!
| Date: Wed, 28 Sep 2005 08:57:09 -0700
| Lines: 14
| Message-ID: <E55E5CE0-899D-46CA-87F2-11F58CAF6787@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53277
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| While testing the latest RC1 SRS software and trying to get report drill
down
| in a chart working, I found that it was not working as expected. I
thought
| that this might be a Dundas issue, but has since learned that this is a
MS
| issue.
|
| I understand that MS is aware of this and I strongly believe that this
needs
| to be fixed via HotFix rather than waiting until release time or later.
We
| are working towards a Spring 2006 release of our software and report
| drilldown is one of the most important elements of our application.
|
| Has anyone else ran into this issue?
|
| Thanks!
| Keith
|sql

Report doesn't work when deployed

I have a report that works perfectly in the development enviroment but when I
deploy it and run it in the report server I get this message:
"An error has occurred during report processing. (rsProcessingAborted)
Obtener ayuda en línea
Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
Obtener ayuda en línea
Object reference not set to an instance of an object. "
I tried recreating the data set bu it was worthless.
--
Pato Connonensure your datasource is pointing to the correct location, and that the
report uses the correct datasource. also ensure your datasource has the
correct connection information
"Pato Connon" wrote:
> I have a report that works perfectly in the development enviroment but when I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en línea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en línea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> --
> Pato Connon|||If you are using an ODBC datasource, you might have to create the
datasource on the SSRS server as well. When you run the report in the
designer, it is looking for the ODBC connection on your computer, but
when it runs on the server, it is looking on the server.
-Josh
Pato Connon wrote:
> I have a report that works perfectly in the development enviroment but wh=en I
> deploy it and run it in the report server I get this message:
> "An error has occurred during report processing. (rsProcessingAborted)
> Obtener ayuda en l=EDnea
> Query execution failed for data set 'All_TTs'. (rsErrorExecutingCommand)
> Obtener ayuda en l=EDnea
> Object reference not set to an instance of an object. "
> I tried recreating the data set bu it was worthless.
> -- > Pato Connon

Report doesn''t work from client side

Hi everyone,

Primary platform is XP as client side and 2003 as server.

When I press F5 in order to see my report from IE appears this error:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SQL1.BDADMIN'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

However, preview button works properly and data are showed.
Let me know where am I failing.

Regards,

Can you verify that the account that you are using to connect to the SQL1.BDADMIN database has permissions to connect?

Jarret

|||

Hi Jarret,

At the end of the day it worked properly. Thanks for your post.

|||

Enric how did you solve your problem. I have the same message. Somboby helllppp!!!!

Report doesn't work from client side

Hi everyone,

Primary platform is XP as client side and 2003 as server.

When I press F5 in order to see my report from IE appears this error:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SQL1.BDADMIN'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

However, preview button works properly and data are showed.
Let me know where am I failing.

Regards,

Can you verify that the account that you are using to connect to the SQL1.BDADMIN database has permissions to connect?

Jarret

|||

Hi Jarret,

At the end of the day it worked properly. Thanks for your post.

|||

Enric how did you solve your problem. I have the same message. Somboby helllppp!!!!

Report doesnt sortPlease help

Hi everyone,
I created a report where I display informations about travels.

Data are grouped by a unique code (travel code), but they're not sorted chronologically, even though in my ASP page I specify ORDER BY date_beginning.

I also created a new group (for date_beginning) within Crystal Report, and then I moved it at the first position, but nothing changes.

I'm really in trouble, any help is appreciated
Thanks in advanceHi,

the best way to Handle this is to Order the way want in the SQL
Query and bring the Data, then on the Report just set the Group order to
'Original', first set the All the Group order to Original if u have other group as well then try this sql order it will work then one by one set the other gouping order to see which couses the prob... surely another gouping order is effecting the Order.

FaFa

report does not show a table

Hi,

We have a report published to two report servers ( same configuration). this report displays data in two side by side tables. on server 1, the left side table does not get displayed where as both the tables show fine on server 2.

What could be the reason for this

Any help greatly appreciated.

Thanks,

Phani

I assume that the reports are pointing to different databases, so is there any data being returned for the table that doesn't show?|||

Hi,

It is the same report deployed on two webservers so they pull from the same database. One report shows both the tables with data and the second one shows only the right side table with data and does not show left hand side table.

Thanks,

Phani

|||

are the two tables using the same datasource?

could it be a time out issue from sql?

Have you looked into the reportserver log files and compared the results from each report server?

sql

Report Does Not Render!

Hello,
I am trying to get my report to render on the Report Server, but it
fails to do so. I am able to see that the report is generating, but
after a period of 30 or more minutes, the same image is displayed on
the screen. I know, for sure, that the query that is grabbing the data
takes about 10 minutes. What could be the problem? I have increased
the timeouts in every place possible: IIS, Report Manager, the data
source. Am I missing something? Please help! Thanks!
-MichaelHow many rows of data are being returned? Are you using filters or query
parameters? How is it being rendered (the default is html)? Or are you
specifying PDF?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<mjhaddad@.gmail.com> wrote in message
news:1119397987.766833.119040@.f14g2000cwb.googlegroups.com...
> Hello,
> I am trying to get my report to render on the Report Server, but it
> fails to do so. I am able to see that the report is generating, but
> after a period of 30 or more minutes, the same image is displayed on
> the screen. I know, for sure, that the query that is grabbing the data
> takes about 10 minutes. What could be the problem? I have increased
> the timeouts in every place possible: IIS, Report Manager, the data
> source. Am I missing something? Please help! Thanks!
> -Michael
>|||Bruce,
Thanks for your reply. Originally I was returning 10,000 rows of data,
but I have limited it to 100 rows. I am using 4 query parameters: a
start date, an end date, sort by, and hotel property. It is being
rendered by the default, HTML. I also want to mention that the report
does show up when the query execution time is around 3 minutes or so.
Thank you for your help!|||Michael:
Have you received any further feedback on this? I am experiencing a similar
issue when i have a report that returns about 10,000 rows. With less rows
and a quicker query execution (6 minutes or less) the report comes back.
-Jeff
"Michael" wrote:
> Bruce,
> Thanks for your reply. Originally I was returning 10,000 rows of data,
> but I have limited it to 100 rows. I am using 4 query parameters: a
> start date, an end date, sort by, and hotel property. It is being
> rendered by the default, HTML. I also want to mention that the report
> does show up when the query execution time is around 3 minutes or so.
> Thank you for your help!
>|||RS renders in RAM. How much data it handles without major slowdown depends
on the format. 10,000 rows is not something for a human to look at. That
much data in my mind is a data export to another program (like Excel).
Rendering to HTML and to CSV format is very fast and can handle much larger
datasets without a massive slowdown. PDF and Excel export really slows down.
The default CSV export is Unicode that Excel doesn't handle well. Use jump
to URL and render as ASCII CSV. Very very fast and I have done 60,000 rows
that way.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JeffW" <JeffW@.discussions.microsoft.com> wrote in message
news:1E215FB6-73A5-483C-9744-600ACA0D37F0@.microsoft.com...
> Michael:
> Have you received any further feedback on this? I am experiencing a
> similar
> issue when i have a report that returns about 10,000 rows. With less rows
> and a quicker query execution (6 minutes or less) the report comes back.
> -Jeff
> "Michael" wrote:
>> Bruce,
>> Thanks for your reply. Originally I was returning 10,000 rows of data,
>> but I have limited it to 100 rows. I am using 4 query parameters: a
>> start date, an end date, sort by, and hotel property. It is being
>> rendered by the default, HTML. I also want to mention that the report
>> does show up when the query execution time is around 3 minutes or so.
>> Thank you for your help!
>>|||Thanks for the prompt follow up Bruce.
Your point about the amount of data a human might look at is well taken. I
may need to revisit my SQL, as the report i am working with takes the 10,00
rows and transposes them into 15-20 columns of data. So, I really only end
up with a couple hundred rows by 15-20 columns. I've tried using matrix
style reporting for this, but could never really get all the formatting quite
right as i can with just a table style report. I may need to get the data
coming back to resemble the report a bit more closely so RS doesn't need to
do so much processing.
The only odd part is that when i watch the aspnet_wp on the report server as
the db server finsihes up it's query, the worker process does not start
gobbling up memory. It grabs a chunk of cpu for a few seconds, but barely
budges on memory. in the past, i have had exports where the wp maxes out the
memory (1.5 gig of RAM ro so) and then i get the RS out of memory error. For
the report i was originally referring to in this post, this never happens.
Instead, the report just never comes back. It's as if RS never even tried to
return the report.
Also, i did not know that about the csv export. i will begin using that
immediately so thank you for that tip.
-JeffW
"Bruce L-C [MVP]" wrote:
> RS renders in RAM. How much data it handles without major slowdown depends
> on the format. 10,000 rows is not something for a human to look at. That
> much data in my mind is a data export to another program (like Excel).
> Rendering to HTML and to CSV format is very fast and can handle much larger
> datasets without a massive slowdown. PDF and Excel export really slows down.
> The default CSV export is Unicode that Excel doesn't handle well. Use jump
> to URL and render as ASCII CSV. Very very fast and I have done 60,000 rows
> that way.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "JeffW" <JeffW@.discussions.microsoft.com> wrote in message
> news:1E215FB6-73A5-483C-9744-600ACA0D37F0@.microsoft.com...
> > Michael:
> >
> > Have you received any further feedback on this? I am experiencing a
> > similar
> > issue when i have a report that returns about 10,000 rows. With less rows
> > and a quicker query execution (6 minutes or less) the report comes back.
> >
> > -Jeff
> >
> > "Michael" wrote:
> >
> >> Bruce,
> >>
> >> Thanks for your reply. Originally I was returning 10,000 rows of data,
> >> but I have limited it to 100 rows. I am using 4 query parameters: a
> >> start date, an end date, sort by, and hotel property. It is being
> >> rendered by the default, HTML. I also want to mention that the report
> >> does show up when the query execution time is around 3 minutes or so.
> >> Thank you for your help!
> >>
> >>
>
>|||Thanks to Bruce and Jeff for the replies, but I am still unsure what to
do to solve my issue. I am only returning 100 rows and the report is
not displaying. In the ReportServer database and in the ExecutionLog,
it shows that the report has completed execution, but there is no
report displaying. What is going on? Please help! Thanks!|||Does it work from the development environment? Where are you displaying this
report, i.e. from your own web page or from Report Manager? If from your own
web page then does the report work from Report Manager?
100 rows should definitely work.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael" <mjhaddad@.gmail.com> wrote in message
news:1119472105.958590.53550@.g44g2000cwa.googlegroups.com...
> Thanks to Bruce and Jeff for the replies, but I am still unsure what to
> do to solve my issue. I am only returning 100 rows and the report is
> not displaying. In the ReportServer database and in the ExecutionLog,
> it shows that the report has completed execution, but there is no
> report displaying. What is going on? Please help! Thanks!
>|||Bruce, it does preview fine in VS .NET. I have deployed the report to
the ReportServer and then try to run it and nothing happens. The same
thing occurs in the ReportManager. Let me know what you think. Thanks!|||Check your credentials datasource for the report.
How fast does it return from the development environment?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael" <mjhaddad@.gmail.com> wrote in message
news:1119473999.367244.23380@.o13g2000cwo.googlegroups.com...
> Bruce, it does preview fine in VS .NET. I have deployed the report to
> the ReportServer and then try to run it and nothing happens. The same
> thing occurs in the ReportManager. Let me know what you think. Thanks!
>|||Bruce, credentials are fine and the report returns in a little over 10
minutes from the development environment.|||100 rows should not be a problem. Plus you say that if the report comes back
in 3 minutes you are OK. This makes me think that it is an IIS issue. That
IIS is timing out on you. I have heard of people adjusting something in IIS
for this but I am not sure where it is done.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael" <mjhaddad@.gmail.com> wrote in message
news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
> Bruce, credentials are fine and the report returns in a little over 10
> minutes from the development environment.
>|||Bruce, I have adjusted the time out for IIS, but it did not resolve the
issue. I am lost, to be honest with you. Thanks for your help!|||Hi Bruce,
I have a similar issue but much more data on a server with 3G memory. I use
RS to render 200,000 rows to CSV and thought that would be better than PDF,
but it took more than 30 minutes and then threw OutOfMemory exeception and RS
got restarted many times according to Event log. We already raise MaxMemory
to 120 in the config file, but just don't know why RS still can not render a
csv file. We really need to render that much data into a report for clients.
Does anyone know how to use RS deal with that much amount of data? Is there
some other way I can try? Thank you.
Charles
"Bruce L-C [MVP]" wrote:
> 100 rows should not be a problem. Plus you say that if the report comes back
> in 3 minutes you are OK. This makes me think that it is an IIS issue. That
> IIS is timing out on you. I have heard of people adjusting something in IIS
> for this but I am not sure where it is done.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Michael" <mjhaddad@.gmail.com> wrote in message
> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
> > Bruce, credentials are fine and the report returns in a little over 10
> > minutes from the development environment.
> >
>
>|||Michael,
Try to adjust to MaxMemory in RS config file(default is 60) and that may help.
Charles
"Michael" wrote:
> Bruce, I have adjusted the time out for IIS, but it did not resolve the
> issue. I am lost, to be honest with you. Thanks for your help!
>|||I have done about 60,000 rows but they were small (very few columns).
200,000 is just past what RS is designed for. My suggestion is to look at
other technologies to do this (like DTS etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:A08B17BA-1720-4324-A1ED-96B659CDBAE7@.microsoft.com...
> Hi Bruce,
> I have a similar issue but much more data on a server with 3G memory. I
> use
> RS to render 200,000 rows to CSV and thought that would be better than
> PDF,
> but it took more than 30 minutes and then threw OutOfMemory exeception and
> RS
> got restarted many times according to Event log. We already raise
> MaxMemory
> to 120 in the config file, but just don't know why RS still can not render
> a
> csv file. We really need to render that much data into a report for
> clients.
> Does anyone know how to use RS deal with that much amount of data? Is
> there
> some other way I can try? Thank you.
> Charles
> "Bruce L-C [MVP]" wrote:
>> 100 rows should not be a problem. Plus you say that if the report comes
>> back
>> in 3 minutes you are OK. This makes me think that it is an IIS issue.
>> That
>> IIS is timing out on you. I have heard of people adjusting something in
>> IIS
>> for this but I am not sure where it is done.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Michael" <mjhaddad@.gmail.com> wrote in message
>> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
>> > Bruce, credentials are fine and the report returns in a little over 10
>> > minutes from the development environment.
>> >
>>|||Hi Bruce,
Thanks for your reply. Is there any document that mentions about report
render limit for each report format (csv, pdf,...)? Thanks.
Charles
"Bruce L-C [MVP]" wrote:
> I have done about 60,000 rows but they were small (very few columns).
> 200,000 is just past what RS is designed for. My suggestion is to look at
> other technologies to do this (like DTS etc).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> news:A08B17BA-1720-4324-A1ED-96B659CDBAE7@.microsoft.com...
> > Hi Bruce,
> >
> > I have a similar issue but much more data on a server with 3G memory. I
> > use
> > RS to render 200,000 rows to CSV and thought that would be better than
> > PDF,
> > but it took more than 30 minutes and then threw OutOfMemory exeception and
> > RS
> > got restarted many times according to Event log. We already raise
> > MaxMemory
> > to 120 in the config file, but just don't know why RS still can not render
> > a
> > csv file. We really need to render that much data into a report for
> > clients.
> > Does anyone know how to use RS deal with that much amount of data? Is
> > there
> > some other way I can try? Thank you.
> >
> > Charles
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 100 rows should not be a problem. Plus you say that if the report comes
> >> back
> >> in 3 minutes you are OK. This makes me think that it is an IIS issue.
> >> That
> >> IIS is timing out on you. I have heard of people adjusting something in
> >> IIS
> >> for this but I am not sure where it is done.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Michael" <mjhaddad@.gmail.com> wrote in message
> >> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
> >> > Bruce, credentials are fine and the report returns in a little over 10
> >> > minutes from the development environment.
> >> >
> >>
> >>
> >>
>
>|||No, there is not a document. I'm sure it varies depending on the RAM you
have and other configuration issues. In general though I would say the
product is designed around human consumption not data loads. Sometimes a
relatively large amount of data is for use by a person for instance into
Excel. Until recently Excel had a limit of 64,000 which when doing CSV RS
can handle (at least on my box which has 2 gigs of RAM). One thing you might
want to try is to see if the user needs all the columns of the report when
you export to CSV. If not, then you could have an alternate report just for
that. What I do sometimes is have a report for viewing and a report to
exporting. I hide the exporting one in list view and then I add a link with
a jump to URL at the top of the report. It exports in CSV ASCII (very
important, default by RS is Unicode which Excel does not recognize).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:C9BBC97A-7E32-4241-ABF5-177FFA654E04@.microsoft.com...
> Hi Bruce,
> Thanks for your reply. Is there any document that mentions about report
> render limit for each report format (csv, pdf,...)? Thanks.
>
> Charles
> "Bruce L-C [MVP]" wrote:
>> I have done about 60,000 rows but they were small (very few columns).
>> 200,000 is just past what RS is designed for. My suggestion is to look at
>> other technologies to do this (like DTS etc).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
>> news:A08B17BA-1720-4324-A1ED-96B659CDBAE7@.microsoft.com...
>> > Hi Bruce,
>> >
>> > I have a similar issue but much more data on a server with 3G memory. I
>> > use
>> > RS to render 200,000 rows to CSV and thought that would be better than
>> > PDF,
>> > but it took more than 30 minutes and then threw OutOfMemory exeception
>> > and
>> > RS
>> > got restarted many times according to Event log. We already raise
>> > MaxMemory
>> > to 120 in the config file, but just don't know why RS still can not
>> > render
>> > a
>> > csv file. We really need to render that much data into a report for
>> > clients.
>> > Does anyone know how to use RS deal with that much amount of data? Is
>> > there
>> > some other way I can try? Thank you.
>> >
>> > Charles
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> 100 rows should not be a problem. Plus you say that if the report
>> >> comes
>> >> back
>> >> in 3 minutes you are OK. This makes me think that it is an IIS issue.
>> >> That
>> >> IIS is timing out on you. I have heard of people adjusting something
>> >> in
>> >> IIS
>> >> for this but I am not sure where it is done.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Michael" <mjhaddad@.gmail.com> wrote in message
>> >> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
>> >> > Bruce, credentials are fine and the report returns in a little over
>> >> > 10
>> >> > minutes from the development environment.
>> >> >
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Currently I use data driven subscription to render CSV file. How do I render
CSV in ASCII from the subscription? Would it be faster and less memory
intensive? Thanks.
Charles
"Bruce L-C [MVP]" wrote:
> No, there is not a document. I'm sure it varies depending on the RAM you
> have and other configuration issues. In general though I would say the
> product is designed around human consumption not data loads. Sometimes a
> relatively large amount of data is for use by a person for instance into
> Excel. Until recently Excel had a limit of 64,000 which when doing CSV RS
> can handle (at least on my box which has 2 gigs of RAM). One thing you might
> want to try is to see if the user needs all the columns of the report when
> you export to CSV. If not, then you could have an alternate report just for
> that. What I do sometimes is have a report for viewing and a report to
> exporting. I hide the exporting one in list view and then I add a link with
> a jump to URL at the top of the report. It exports in CSV ASCII (very
> important, default by RS is Unicode which Excel does not recognize).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> news:C9BBC97A-7E32-4241-ABF5-177FFA654E04@.microsoft.com...
> > Hi Bruce,
> >
> > Thanks for your reply. Is there any document that mentions about report
> > render limit for each report format (csv, pdf,...)? Thanks.
> >
> >
> > Charles
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> I have done about 60,000 rows but they were small (very few columns).
> >> 200,000 is just past what RS is designed for. My suggestion is to look at
> >> other technologies to do this (like DTS etc).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> >> news:A08B17BA-1720-4324-A1ED-96B659CDBAE7@.microsoft.com...
> >> > Hi Bruce,
> >> >
> >> > I have a similar issue but much more data on a server with 3G memory. I
> >> > use
> >> > RS to render 200,000 rows to CSV and thought that would be better than
> >> > PDF,
> >> > but it took more than 30 minutes and then threw OutOfMemory exeception
> >> > and
> >> > RS
> >> > got restarted many times according to Event log. We already raise
> >> > MaxMemory
> >> > to 120 in the config file, but just don't know why RS still can not
> >> > render
> >> > a
> >> > csv file. We really need to render that much data into a report for
> >> > clients.
> >> > Does anyone know how to use RS deal with that much amount of data? Is
> >> > there
> >> > some other way I can try? Thank you.
> >> >
> >> > Charles
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> 100 rows should not be a problem. Plus you say that if the report
> >> >> comes
> >> >> back
> >> >> in 3 minutes you are OK. This makes me think that it is an IIS issue.
> >> >> That
> >> >> IIS is timing out on you. I have heard of people adjusting something
> >> >> in
> >> >> IIS
> >> >> for this but I am not sure where it is done.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Michael" <mjhaddad@.gmail.com> wrote in message
> >> >> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
> >> >> > Bruce, credentials are fine and the report returns in a little over
> >> >> > 10
> >> >> > minutes from the development environment.
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It takes the same amount of time. The difference is that Excel recognizes it
as CSV so it does not put it all in one column. This is what I use in jump
to URL. Perhaps it will help you with your subscriptions:
This causes Excel to come up with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:43871106-CE27-47D9-8E6D-66B35B83CF8F@.microsoft.com...
> Hi Bruce,
> Currently I use data driven subscription to render CSV file. How do I
> render
> CSV in ASCII from the subscription? Would it be faster and less memory
> intensive? Thanks.
> Charles
> "Bruce L-C [MVP]" wrote:
>> No, there is not a document. I'm sure it varies depending on the RAM you
>> have and other configuration issues. In general though I would say the
>> product is designed around human consumption not data loads. Sometimes a
>> relatively large amount of data is for use by a person for instance into
>> Excel. Until recently Excel had a limit of 64,000 which when doing CSV RS
>> can handle (at least on my box which has 2 gigs of RAM). One thing you
>> might
>> want to try is to see if the user needs all the columns of the report
>> when
>> you export to CSV. If not, then you could have an alternate report just
>> for
>> that. What I do sometimes is have a report for viewing and a report to
>> exporting. I hide the exporting one in list view and then I add a link
>> with
>> a jump to URL at the top of the report. It exports in CSV ASCII (very
>> important, default by RS is Unicode which Excel does not recognize).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
>> news:C9BBC97A-7E32-4241-ABF5-177FFA654E04@.microsoft.com...
>> > Hi Bruce,
>> >
>> > Thanks for your reply. Is there any document that mentions about report
>> > render limit for each report format (csv, pdf,...)? Thanks.
>> >
>> >
>> > Charles
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> I have done about 60,000 rows but they were small (very few columns).
>> >> 200,000 is just past what RS is designed for. My suggestion is to look
>> >> at
>> >> other technologies to do this (like DTS etc).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
>> >> news:A08B17BA-1720-4324-A1ED-96B659CDBAE7@.microsoft.com...
>> >> > Hi Bruce,
>> >> >
>> >> > I have a similar issue but much more data on a server with 3G
>> >> > memory. I
>> >> > use
>> >> > RS to render 200,000 rows to CSV and thought that would be better
>> >> > than
>> >> > PDF,
>> >> > but it took more than 30 minutes and then threw OutOfMemory
>> >> > exeception
>> >> > and
>> >> > RS
>> >> > got restarted many times according to Event log. We already raise
>> >> > MaxMemory
>> >> > to 120 in the config file, but just don't know why RS still can not
>> >> > render
>> >> > a
>> >> > csv file. We really need to render that much data into a report for
>> >> > clients.
>> >> > Does anyone know how to use RS deal with that much amount of data?
>> >> > Is
>> >> > there
>> >> > some other way I can try? Thank you.
>> >> >
>> >> > Charles
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> 100 rows should not be a problem. Plus you say that if the report
>> >> >> comes
>> >> >> back
>> >> >> in 3 minutes you are OK. This makes me think that it is an IIS
>> >> >> issue.
>> >> >> That
>> >> >> IIS is timing out on you. I have heard of people adjusting
>> >> >> something
>> >> >> in
>> >> >> IIS
>> >> >> for this but I am not sure where it is done.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Michael" <mjhaddad@.gmail.com> wrote in message
>> >> >> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
>> >> >> > Bruce, credentials are fine and the report returns in a little
>> >> >> > over
>> >> >> > 10
>> >> >> > minutes from the development environment.
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi Bruce,
Thank you for your hints. But still wondering why RS uses so much memory for
rendering a big report. Have you heard this would be improved in Sql Server
RS 2005?
Charles
"Bruce L-C [MVP]" wrote:
> It takes the same amount of time. The difference is that Excel recognizes it
> as CSV so it does not put it all in one column. This is what I use in jump
> to URL. Perhaps it will help you with your subscriptions:
> This causes Excel to come up with the data in a separate window:
>
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> news:43871106-CE27-47D9-8E6D-66B35B83CF8F@.microsoft.com...
> > Hi Bruce,
> >
> > Currently I use data driven subscription to render CSV file. How do I
> > render
> > CSV in ASCII from the subscription? Would it be faster and less memory
> > intensive? Thanks.
> >
> > Charles
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, there is not a document. I'm sure it varies depending on the RAM you
> >> have and other configuration issues. In general though I would say the
> >> product is designed around human consumption not data loads. Sometimes a
> >> relatively large amount of data is for use by a person for instance into
> >> Excel. Until recently Excel had a limit of 64,000 which when doing CSV RS
> >> can handle (at least on my box which has 2 gigs of RAM). One thing you
> >> might
> >> want to try is to see if the user needs all the columns of the report
> >> when
> >> you export to CSV. If not, then you could have an alternate report just
> >> for
> >> that. What I do sometimes is have a report for viewing and a report to
> >> exporting. I hide the exporting one in list view and then I add a link
> >> with
> >> a jump to URL at the top of the report. It exports in CSV ASCII (very
> >> important, default by RS is Unicode which Excel does not recognize).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> >> news:C9BBC97A-7E32-4241-ABF5-177FFA654E04@.microsoft.com...
> >> > Hi Bruce,
> >> >
> >> > Thanks for your reply. Is there any document that mentions about report
> >> > render limit for each report format (csv, pdf,...)? Thanks.
> >> >
> >> >
> >> > Charles
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> I have done about 60,000 rows but they were small (very few columns).
> >> >> 200,000 is just past what RS is designed for. My suggestion is to look
> >> >> at
> >> >> other technologies to do this (like DTS etc).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Chuck" <Chuck@.discussions.microsoft.com> wrote in message
> >> >> news:A08B17BA-1720-4324-A1ED-96B659CDBAE7@.microsoft.com...
> >> >> > Hi Bruce,
> >> >> >
> >> >> > I have a similar issue but much more data on a server with 3G
> >> >> > memory. I
> >> >> > use
> >> >> > RS to render 200,000 rows to CSV and thought that would be better
> >> >> > than
> >> >> > PDF,
> >> >> > but it took more than 30 minutes and then threw OutOfMemory
> >> >> > exeception
> >> >> > and
> >> >> > RS
> >> >> > got restarted many times according to Event log. We already raise
> >> >> > MaxMemory
> >> >> > to 120 in the config file, but just don't know why RS still can not
> >> >> > render
> >> >> > a
> >> >> > csv file. We really need to render that much data into a report for
> >> >> > clients.
> >> >> > Does anyone know how to use RS deal with that much amount of data?
> >> >> > Is
> >> >> > there
> >> >> > some other way I can try? Thank you.
> >> >> >
> >> >> > Charles
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> 100 rows should not be a problem. Plus you say that if the report
> >> >> >> comes
> >> >> >> back
> >> >> >> in 3 minutes you are OK. This makes me think that it is an IIS
> >> >> >> issue.
> >> >> >> That
> >> >> >> IIS is timing out on you. I have heard of people adjusting
> >> >> >> something
> >> >> >> in
> >> >> >> IIS
> >> >> >> for this but I am not sure where it is done.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Michael" <mjhaddad@.gmail.com> wrote in message
> >> >> >> news:1119475785.897599.226260@.o13g2000cwo.googlegroups.com...
> >> >> >> > Bruce, credentials are fine and the report returns in a little
> >> >> >> > over
> >> >> >> > 10
> >> >> >> > minutes from the development environment.
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||What about matrix report?
I have about 150.000 records which make my matrix report 150 rows and
90 columns.
It does not render to excel:( because of low resources.
please help|||Is this the number of rows returned or the size of the table. It doesn't
matter how big the table is (I go against tables with 50 million rows), what
matters is the number of rows returned. If you have that many rows returned
then you need to look at your query and have the database do more of the
work. The best strategy (not just for RS but for any application) is to
return the smallest number of rows possible. Have SQL Server DB do the work,
not RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kamel" <kwiciak@.gmail.com> wrote in message
news:1119644816.435274.296140@.g43g2000cwa.googlegroups.com...
> What about matrix report?
> I have about 150.000 records which make my matrix report 150 rows and
> 90 columns.
> It does not render to excel:( because of low resources.
> please help
>|||My query returns at the moment about 150.000 - 200.000 records.
I use this data on my matrix report.
I have 3 levels of grouping on rows and 3 levels of grouping on columns
and in cells I have also some calculations.
Finally I came up with matrix with about 150 rows and 90 columns.
I does not want to render to excel.