hi,
i have a query working with crystal reports on oracle server.
--There is a table transaction_hist containing 'due_date' column(which is a number to be converted to date). In the report i want the summary of the amounts with current due_date, future due_date, past 1to30 days due_date,31to60,61to90 and 91to180 due_dates.
eg
current future 1_30 31_60 61_90 91_181
sum 99999 99999 99999 9999 9999 9999
PS: i have tried to make formula column for all these due_dates...but could not group by them and summarize them.Try uisng Cross tab reports. Read more in help file
Showing posts with label working. Show all posts
Showing posts with label working. Show all posts
Wednesday, March 28, 2012
Report width gets stretched
I'm new to Reporting Services (only about 2 1/2 weeks working with it, but
I'm catching on quickly). However one really annoying thing that I can't
figure out is how to prevent the report from resizing or "stretching"
horizontally once I render my report. In the report layout designer,
everything looks fine. This only happens when I render the report (either
under the preview tab, or in a web browser.) This is especially important to
fix as the reports will be displayed in a java-script opened window to
specified proportions where scrolling vertically is necessary, but scrolling
horizontally will cause problems with the interface.Just an addition to my above post. I noticed that this only happens when I
enable the report footer. When I disable it, the report sizes properly. Any
help will be greatly appreciated.
I'm catching on quickly). However one really annoying thing that I can't
figure out is how to prevent the report from resizing or "stretching"
horizontally once I render my report. In the report layout designer,
everything looks fine. This only happens when I render the report (either
under the preview tab, or in a web browser.) This is especially important to
fix as the reports will be displayed in a java-script opened window to
specified proportions where scrolling vertically is necessary, but scrolling
horizontally will cause problems with the interface.Just an addition to my above post. I noticed that this only happens when I
enable the report footer. When I disable it, the report sizes properly. Any
help will be greatly appreciated.
Report Viewer vs Report Server
Bonjour!
I deploy a report with Report viewer (Visual Studio 2005) on our web site
and it's working fine, I use the Integrated security. When I try to access
the same report but on the report server I have an authentication error but
with RV it's OK. This means it doesn't talk to the server the same way. Does
someone have hit that problem'
Regards, Joel:)On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> Bonjour!
> I deploy a report with Report viewer (Visual Studio 2005) on our web site
> and it's working fine, I use the Integrated security. When I try to access
> the same report but on the report server I have an authentication error but
> with RV it's OK. This means it doesn't talk to the server the same way. Does
> someone have hit that problem'
> Regards, Joel:)
Hello Joel, you may need to post more specifics on your authentication
setup.
I assume that by deploying "on our web site" you mean that you are
including a Reporting Services report as an object in a ASP.NET page
using the ReportViewer object. Authentication here is a local data
source connecting one-hop to a data source, pulling the data back to
the client and rendering on the client. When deploying to a Reporting
Server, the RS connects to the DS, pulls the data to the RS, renders
it to HTML, and sends the HTML to the client (you).
Check that you deployed to your Reporting Server using
"OverwriteDataSources" at least once, so the .ds files are actually
accessable. Then check the permissions on the Server, making sure
that the "user" that logs into the Reporting Services server has
permission to read from the data source.
Or you may have the "double hop" issue. You are at your desktop, NT
Authenticating to the Reporting Server, which should be sending your
authentication information to a SQL Server using NT Authentication.
This has failed at our company, and required a long process to get it
fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
or just search on "double hop" to find solutions.
-- Scott|||Thanks Scott, that's exactly what I'm doing, I will try the "Overwrite"
Regards, Joel :)
"Orne" wrote:
> On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> > Bonjour!
> > I deploy a report with Report viewer (Visual Studio 2005) on our web site
> > and it's working fine, I use the Integrated security. When I try to access
> > the same report but on the report server I have an authentication error but
> > with RV it's OK. This means it doesn't talk to the server the same way. Does
> > someone have hit that problem'
> >
> > Regards, Joel:)
> Hello Joel, you may need to post more specifics on your authentication
> setup.
> I assume that by deploying "on our web site" you mean that you are
> including a Reporting Services report as an object in a ASP.NET page
> using the ReportViewer object. Authentication here is a local data
> source connecting one-hop to a data source, pulling the data back to
> the client and rendering on the client. When deploying to a Reporting
> Server, the RS connects to the DS, pulls the data to the RS, renders
> it to HTML, and sends the HTML to the client (you).
> Check that you deployed to your Reporting Server using
> "OverwriteDataSources" at least once, so the .ds files are actually
> accessable. Then check the permissions on the Server, making sure
> that the "user" that logs into the Reporting Services server has
> permission to read from the data source.
> Or you may have the "double hop" issue. You are at your desktop, NT
> Authenticating to the Reporting Server, which should be sending your
> authentication information to a SQL Server using NT Authentication.
> This has failed at our company, and required a long process to get it
> fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
> or just search on "double hop" to find solutions.
> -- Scott
>
I deploy a report with Report viewer (Visual Studio 2005) on our web site
and it's working fine, I use the Integrated security. When I try to access
the same report but on the report server I have an authentication error but
with RV it's OK. This means it doesn't talk to the server the same way. Does
someone have hit that problem'
Regards, Joel:)On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> Bonjour!
> I deploy a report with Report viewer (Visual Studio 2005) on our web site
> and it's working fine, I use the Integrated security. When I try to access
> the same report but on the report server I have an authentication error but
> with RV it's OK. This means it doesn't talk to the server the same way. Does
> someone have hit that problem'
> Regards, Joel:)
Hello Joel, you may need to post more specifics on your authentication
setup.
I assume that by deploying "on our web site" you mean that you are
including a Reporting Services report as an object in a ASP.NET page
using the ReportViewer object. Authentication here is a local data
source connecting one-hop to a data source, pulling the data back to
the client and rendering on the client. When deploying to a Reporting
Server, the RS connects to the DS, pulls the data to the RS, renders
it to HTML, and sends the HTML to the client (you).
Check that you deployed to your Reporting Server using
"OverwriteDataSources" at least once, so the .ds files are actually
accessable. Then check the permissions on the Server, making sure
that the "user" that logs into the Reporting Services server has
permission to read from the data source.
Or you may have the "double hop" issue. You are at your desktop, NT
Authenticating to the Reporting Server, which should be sending your
authentication information to a SQL Server using NT Authentication.
This has failed at our company, and required a long process to get it
fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
or just search on "double hop" to find solutions.
-- Scott|||Thanks Scott, that's exactly what I'm doing, I will try the "Overwrite"
Regards, Joel :)
"Orne" wrote:
> On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> > Bonjour!
> > I deploy a report with Report viewer (Visual Studio 2005) on our web site
> > and it's working fine, I use the Integrated security. When I try to access
> > the same report but on the report server I have an authentication error but
> > with RV it's OK. This means it doesn't talk to the server the same way. Does
> > someone have hit that problem'
> >
> > Regards, Joel:)
> Hello Joel, you may need to post more specifics on your authentication
> setup.
> I assume that by deploying "on our web site" you mean that you are
> including a Reporting Services report as an object in a ASP.NET page
> using the ReportViewer object. Authentication here is a local data
> source connecting one-hop to a data source, pulling the data back to
> the client and rendering on the client. When deploying to a Reporting
> Server, the RS connects to the DS, pulls the data to the RS, renders
> it to HTML, and sends the HTML to the client (you).
> Check that you deployed to your Reporting Server using
> "OverwriteDataSources" at least once, so the .ds files are actually
> accessable. Then check the permissions on the Server, making sure
> that the "user" that logs into the Reporting Services server has
> permission to read from the data source.
> Or you may have the "double hop" issue. You are at your desktop, NT
> Authenticating to the Reporting Server, which should be sending your
> authentication information to a SQL Server using NT Authentication.
> This has failed at our company, and required a long process to get it
> fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
> or just search on "double hop" to find solutions.
> -- Scott
>
Friday, March 23, 2012
Report viewer - White Space on the right of the report
Hi,
I'm working on some reports in my project, for which I've used Reporting
services Report Viewer(RV).
Everything seems to be fine ( not actually, IE crashes as soon as I click on
the PRINT icon for the second time), but, the report viewer leaves in huge
white space on the right hand side of the report ( 4-5 inches or more). I
couldn't find any reason why it's coming up.
Tried reducing the width of the report in the layout wizard, didn't help.
Placed the RV in a table to restrict this, didn't help.
Has anyone come across this? Any suggestion / solution to this would be
greatly appreciated.
Thanks in advance
srinivasHere are some things to try...
1. Make sure that the vertical line to the right is as far to the left
as possible. Note the position ... say 7.5"
2. now select the WHOLE report ... click the uppermost top left
portion in layout mode
3. change the borders to say .5"
4. change the report width to 8.5"
You will not see the results in the preview panel ... only when you hit
the "preview" button ... or alternatively, when you export it to pdf
Hope this helps...
I'm working on some reports in my project, for which I've used Reporting
services Report Viewer(RV).
Everything seems to be fine ( not actually, IE crashes as soon as I click on
the PRINT icon for the second time), but, the report viewer leaves in huge
white space on the right hand side of the report ( 4-5 inches or more). I
couldn't find any reason why it's coming up.
Tried reducing the width of the report in the layout wizard, didn't help.
Placed the RV in a table to restrict this, didn't help.
Has anyone come across this? Any suggestion / solution to this would be
greatly appreciated.
Thanks in advance
srinivasHere are some things to try...
1. Make sure that the vertical line to the right is as far to the left
as possible. Note the position ... say 7.5"
2. now select the WHOLE report ... click the uppermost top left
portion in layout mode
3. change the borders to say .5"
4. change the report width to 8.5"
You will not see the results in the preview panel ... only when you hit
the "preview" button ... or alternatively, when you export it to pdf
Hope this helps...
Tuesday, March 20, 2012
Report Template
Created my first report...working fine...copied it created a new .RDL, added
to the solution, cleared the dataportion from the layout and deleted the
datasets...created new datasets and dropped a matrix in the data
portion...after assigning the values for the matrix when I preview, i get a
message "The definition of report is invalid...The datasetname is missing in
the data set region 'Data Set Name'...
Should we Not copy! Thats what we do in IT :)Ignore...Added the dataset to the matrix property "DataSetName"...
"Ranga" wrote:
> Created my first report...working fine...copied it created a new .RDL, added
> to the solution, cleared the dataportion from the layout and deleted the
> datasets...created new datasets and dropped a matrix in the data
> portion...after assigning the values for the matrix when I preview, i get a
> message "The definition of report is invalid...The datasetname is missing in
> the data set region 'Data Set Name'...
>
> Should we Not copy! Thats what we do in IT :)
>
to the solution, cleared the dataportion from the layout and deleted the
datasets...created new datasets and dropped a matrix in the data
portion...after assigning the values for the matrix when I preview, i get a
message "The definition of report is invalid...The datasetname is missing in
the data set region 'Data Set Name'...
Should we Not copy! Thats what we do in IT :)Ignore...Added the dataset to the matrix property "DataSetName"...
"Ranga" wrote:
> Created my first report...working fine...copied it created a new .RDL, added
> to the solution, cleared the dataportion from the layout and deleted the
> datasets...created new datasets and dropped a matrix in the data
> portion...after assigning the values for the matrix when I preview, i get a
> message "The definition of report is invalid...The datasetname is missing in
> the data set region 'Data Set Name'...
>
> Should we Not copy! Thats what we do in IT :)
>
Report subscription ...help !
I am facing problem today with subscription..it was working fine...but it stopped working today after I tried to make some changes in config file.. ..after I corrected again...its still not working.Here is my problem...I create subsctiptoon for file share ..I enter all required info in page and then click on OK button. but instead of showing my subscription list, it shows this error "The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding) Get Online Help " I have checked agent service hundred times in last few hours, its started ...I restarted it again ..I restarted Report Server service too...but its of no use..I am getting the same error again and again... Its quite critical issue for me ...so help me if u have any idea... Thanks !prashant
restart your SQL Agent service and then is should work
Monday, March 12, 2012
Report Services and Web Services?
Hi All,
I have spent the last few weeks working with SQL Server 2000 Reporting
Services and have gotten to the point of successfully creating EMail
Subscriptions. I now want to extend this so this process is performed
automatically, ie by clicking an 'Add me to this Reports Subscription list'
from within ur web application along side the link to run the report.
I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
thinking this might lie within Web Services, as I hear Reporting Services is
basically a collection of such WSs which the localhost reporting services
interface plugs into.
So I'm wondering if this is correct and if so how I go about plugging into
the WSs to script the creation of a Report Subscription. I'm guessing it
might be possible to create the required subscriptions and then just use the
script/WSs to add a users email to the email list for the subscription,
although I'm wondering if it'll be that simple!
Thanks in advance,
Stephen
.ive done this using the reporting services soap api (although i am
using 2005, it was available in 2000)
heres a starting point ..
http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
its not too difficult, especially if your contriving much of the
schedule type values in your app rather than having to recreate a
scheduling interface for the user.
db
http://www.osix.net
the open source institute
home of the geek programming challenges
StephenMcC wrote:
> Hi All,
> I have spent the last few weeks working with SQL Server 2000 Reporting
> Services and have gotten to the point of successfully creating EMail
> Subscriptions. I now want to extend this so this process is performed
> automatically, ie by clicking an 'Add me to this Reports Subscription list'
> from within ur web application along side the link to run the report.
> I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> thinking this might lie within Web Services, as I hear Reporting Services is
> basically a collection of such WSs which the localhost reporting services
> interface plugs into.
> So I'm wondering if this is correct and if so how I go about plugging into
> the WSs to script the creation of a Report Subscription. I'm guessing it
> might be possible to create the required subscriptions and then just use the
> script/WSs to add a users email to the email list for the subscription,
> although I'm wondering if it'll be that simple!
> Thanks in advance,
> Stephen
> .|||Thanks for the reply bb, but is this .Net, migth it be poss to plug into this
from VB6 or Classic ASP, as the app is in old school VS?!
Thanks,
Sephen
"bb" wrote:
> ive done this using the reporting services soap api (although i am
> using 2005, it was available in 2000)
> heres a starting point ..
> http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
> its not too difficult, especially if your contriving much of the
> schedule type values in your app rather than having to recreate a
> scheduling interface for the user.
> db
>
> http://www.osix.net
> the open source institute
> home of the geek programming challenges
>
>
> StephenMcC wrote:
> > Hi All,
> >
> > I have spent the last few weeks working with SQL Server 2000 Reporting
> > Services and have gotten to the point of successfully creating EMail
> > Subscriptions. I now want to extend this so this process is performed
> > automatically, ie by clicking an 'Add me to this Reports Subscription list'
> > from within ur web application along side the link to run the report.
> >
> > I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> > thinking this might lie within Web Services, as I hear Reporting Services is
> > basically a collection of such WSs which the localhost reporting services
> > interface plugs into.
> >
> > So I'm wondering if this is correct and if so how I go about plugging into
> > the WSs to script the creation of a Report Subscription. I'm guessing it
> > might be possible to create the required subscriptions and then just use the
> > script/WSs to add a users email to the email list for the subscription,
> > although I'm wondering if it'll be that simple!
> >
> > Thanks in advance,
> >
> > Stephen
> >
> > .
>
I have spent the last few weeks working with SQL Server 2000 Reporting
Services and have gotten to the point of successfully creating EMail
Subscriptions. I now want to extend this so this process is performed
automatically, ie by clicking an 'Add me to this Reports Subscription list'
from within ur web application along side the link to run the report.
I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
thinking this might lie within Web Services, as I hear Reporting Services is
basically a collection of such WSs which the localhost reporting services
interface plugs into.
So I'm wondering if this is correct and if so how I go about plugging into
the WSs to script the creation of a Report Subscription. I'm guessing it
might be possible to create the required subscriptions and then just use the
script/WSs to add a users email to the email list for the subscription,
although I'm wondering if it'll be that simple!
Thanks in advance,
Stephen
.ive done this using the reporting services soap api (although i am
using 2005, it was available in 2000)
heres a starting point ..
http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
its not too difficult, especially if your contriving much of the
schedule type values in your app rather than having to recreate a
scheduling interface for the user.
db
http://www.osix.net
the open source institute
home of the geek programming challenges
StephenMcC wrote:
> Hi All,
> I have spent the last few weeks working with SQL Server 2000 Reporting
> Services and have gotten to the point of successfully creating EMail
> Subscriptions. I now want to extend this so this process is performed
> automatically, ie by clicking an 'Add me to this Reports Subscription list'
> from within ur web application along side the link to run the report.
> I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> thinking this might lie within Web Services, as I hear Reporting Services is
> basically a collection of such WSs which the localhost reporting services
> interface plugs into.
> So I'm wondering if this is correct and if so how I go about plugging into
> the WSs to script the creation of a Report Subscription. I'm guessing it
> might be possible to create the required subscriptions and then just use the
> script/WSs to add a users email to the email list for the subscription,
> although I'm wondering if it'll be that simple!
> Thanks in advance,
> Stephen
> .|||Thanks for the reply bb, but is this .Net, migth it be poss to plug into this
from VB6 or Classic ASP, as the app is in old school VS?!
Thanks,
Sephen
"bb" wrote:
> ive done this using the reporting services soap api (although i am
> using 2005, it was available in 2000)
> heres a starting point ..
> http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx
> its not too difficult, especially if your contriving much of the
> schedule type values in your app rather than having to recreate a
> scheduling interface for the user.
> db
>
> http://www.osix.net
> the open source institute
> home of the geek programming challenges
>
>
> StephenMcC wrote:
> > Hi All,
> >
> > I have spent the last few weeks working with SQL Server 2000 Reporting
> > Services and have gotten to the point of successfully creating EMail
> > Subscriptions. I now want to extend this so this process is performed
> > automatically, ie by clicking an 'Add me to this Reports Subscription list'
> > from within ur web application along side the link to run the report.
> >
> > I'm aware of the RS.EXE utility but I'm not sure this is the answer, I'm
> > thinking this might lie within Web Services, as I hear Reporting Services is
> > basically a collection of such WSs which the localhost reporting services
> > interface plugs into.
> >
> > So I'm wondering if this is correct and if so how I go about plugging into
> > the WSs to script the creation of a Report Subscription. I'm guessing it
> > might be possible to create the required subscriptions and then just use the
> > script/WSs to add a users email to the email list for the subscription,
> > although I'm wondering if it'll be that simple!
> >
> > Thanks in advance,
> >
> > Stephen
> >
> > .
>
Report Service Seems to Go to Sleep
Hi,
I have a report server that is working almost fine and dandy. The only
little snafu seems to be if no one hits the server for "a while" the
report server seems to "go to sleep". Bringing up a report after it
has done this can take a little time, but any subsequent reports come
up nice and fast as they should. I also notice on the first hit in a
long time that the following message in the event log shows up:
"The ReportServer service has been activated."
Occassionally I will even see a timeout error occur the first time I
try to go to a report. But if I try it a second time it comes up nice
and quick. Is there a way to tune report server so that it doesn't do
this? Has anyone else run into this?
Thanks,
BillThis is a property in ASP.Net and your website. You can change worker
process recycling on the Application Pool of IIS6.0 to be just about as
long as you like.
--
| From: "zinck74" <bkelly3@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Report Service Seems to Go to Sleep
| Date: 5 Jul 2005 17:13:56 -0700
| Organization: http://groups.google.com
| Lines: 18
| Message-ID: <1120608836.572936.22790@.g43g2000cwa.googlegroups.com>
| NNTP-Posting-Host: 131.107.0.103
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1120608842 16730 127.0.0.1 (6 Jul 2005
00:14:02 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Wed, 6 Jul 2005 00:14:02 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: g43g2000cwa.googlegroups.com; posting-host=131.107.0.103;
| posting-account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g4
3g2000cwa.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47443
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
| I have a report server that is working almost fine and dandy. The only
| little snafu seems to be if no one hits the server for "a while" the
| report server seems to "go to sleep". Bringing up a report after it
| has done this can take a little time, but any subsequent reports come
| up nice and fast as they should. I also notice on the first hit in a
| long time that the following message in the event log shows up:
|
| "The ReportServer service has been activated."
|
| Occassionally I will even see a timeout error occur the first time I
| try to go to a report. But if I try it a second time it comes up nice
| and quick. Is there a way to tune report server so that it doesn't do
| this? Has anyone else run into this?
|
| Thanks,
| Bill
|
|
I have a report server that is working almost fine and dandy. The only
little snafu seems to be if no one hits the server for "a while" the
report server seems to "go to sleep". Bringing up a report after it
has done this can take a little time, but any subsequent reports come
up nice and fast as they should. I also notice on the first hit in a
long time that the following message in the event log shows up:
"The ReportServer service has been activated."
Occassionally I will even see a timeout error occur the first time I
try to go to a report. But if I try it a second time it comes up nice
and quick. Is there a way to tune report server so that it doesn't do
this? Has anyone else run into this?
Thanks,
BillThis is a property in ASP.Net and your website. You can change worker
process recycling on the Application Pool of IIS6.0 to be just about as
long as you like.
--
| From: "zinck74" <bkelly3@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Report Service Seems to Go to Sleep
| Date: 5 Jul 2005 17:13:56 -0700
| Organization: http://groups.google.com
| Lines: 18
| Message-ID: <1120608836.572936.22790@.g43g2000cwa.googlegroups.com>
| NNTP-Posting-Host: 131.107.0.103
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1120608842 16730 127.0.0.1 (6 Jul 2005
00:14:02 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Wed, 6 Jul 2005 00:14:02 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: g43g2000cwa.googlegroups.com; posting-host=131.107.0.103;
| posting-account=H4pdeQ0AAACXytwviGUvL2hDckWajAKB
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g4
3g2000cwa.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47443
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
| I have a report server that is working almost fine and dandy. The only
| little snafu seems to be if no one hits the server for "a while" the
| report server seems to "go to sleep". Bringing up a report after it
| has done this can take a little time, but any subsequent reports come
| up nice and fast as they should. I also notice on the first hit in a
| long time that the following message in the event log shows up:
|
| "The ReportServer service has been activated."
|
| Occassionally I will even see a timeout error occur the first time I
| try to go to a report. But if I try it a second time it comes up nice
| and quick. Is there a way to tune report server so that it doesn't do
| this? Has anyone else run into this?
|
| Thanks,
| Bill
|
|
Friday, March 9, 2012
Report Service calculation
Hi
i am working with report service in sql server 2005.
I have a problem with calculation.
what i want to do is something like this
i am working with report service in sql server 2005.
I have a problem with calculation.
what i want to do is something like this
=IIf Fields!total_spb_week_this_year.Value= 0 then 0
else
100 * (Fields!total_xch_comp_week_this_year.Value +
Fields!total_xch_1_4_1_week_this_year.Value) /
Fields!total_spb_week_this_year.Value
but i dont know what shall i add and wher shall i put.
i put this command in expression in the filed but it didnt work.
thanks alot for any help.
voroojaki just tried this and it seems that it is working, but i dont know how can i round it.
=IIF (Fields!total_spb_week_this_year.Value>0 ,
(Fields!total_xch_comp_week_this_year.Value +
Fields!total_xch_1_4_1_week_this_year.Value) * 100 /
Fields!total_spb_week_this_year.Value,0)
but thre result is 72.256471568124
but i want to get 72
or if it is 72.68545121654 i want to get 73
how is it possible.
i put ROUND at the begining but it didnt work.
thanks|||You can use Formatting
Format (value,"N").....|||thanks,
i tried to use round and it worked some how, can u please explain this function to me, because i also need to have with one digit decimal. i used round (X,1) but in some rows that it is for example 2.4000001, it dowsnt give me me 2,4 or if it is 2.5.99999 it is not giving me 2.6.
thanks alot for ur help.|||This is the formatting options provided in the reporting service.
Format (value,"N") -- two decimal points
Format(value,"N1") -- one decimal point
etc..,
Wednesday, March 7, 2012
Report Server publish error 400
I have been working my way through the Report Server tutorials. All went
well until I got to Lesson 7
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/d313b097-a04c-4e26-b2d9-9a0b421aa61d.htm#seeAlsoSection).
There it described how to publish a report. When I do that step, I get "The
request failed with HTTP status 400: Bad Request."
I am using "http://localhost/reportserver" for the TargetServerURL, and this
URL does exist (I can open it in IE). There I see the two subdirectories,
Tutorial and Data Sources, but neither has anything in them.
Can you point me in the right direction to get this to work?
Thanks.Hello acsla,
Based on my research, you need to check whether you have use host header in
your IIS for your web site.
If does,we had to modify two config files:
In RSWebApplication.config we added the url to ReportServer using the host
header
name in the ReportServerUrl element.
In rsreportserver.config, we modified the UrlRoot element to use the host
header
name rather than the machine name in the url to ReportServer.
Hope this information will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thanks.
I don't see anywhere in IIS where use host header is set. I certainly
haven't changed any default setting on that. Where exactly in IIS would this
be?
Thanks.
"Wei Lu [MSFT]" wrote:
> Hello acsla,
> Based on my research, you need to check whether you have use host header in
> your IIS for your web site.
> If does,we had to modify two config files:
> In RSWebApplication.config we added the url to ReportServer using the host
> header
> name in the ReportServerUrl element.
> In rsreportserver.config, we modified the UrlRoot element to use the host
> header
> name rather than the machine name in the url to ReportServer.
> Hope this information will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Acsla,
Then, could you check the two configuration files I mentioned in the
previous post and use the correct value for the element?
You need to use the http://servername/reportserver in those elements.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
well until I got to Lesson 7
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/d313b097-a04c-4e26-b2d9-9a0b421aa61d.htm#seeAlsoSection).
There it described how to publish a report. When I do that step, I get "The
request failed with HTTP status 400: Bad Request."
I am using "http://localhost/reportserver" for the TargetServerURL, and this
URL does exist (I can open it in IE). There I see the two subdirectories,
Tutorial and Data Sources, but neither has anything in them.
Can you point me in the right direction to get this to work?
Thanks.Hello acsla,
Based on my research, you need to check whether you have use host header in
your IIS for your web site.
If does,we had to modify two config files:
In RSWebApplication.config we added the url to ReportServer using the host
header
name in the ReportServerUrl element.
In rsreportserver.config, we modified the UrlRoot element to use the host
header
name rather than the machine name in the url to ReportServer.
Hope this information will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Thanks.
I don't see anywhere in IIS where use host header is set. I certainly
haven't changed any default setting on that. Where exactly in IIS would this
be?
Thanks.
"Wei Lu [MSFT]" wrote:
> Hello acsla,
> Based on my research, you need to check whether you have use host header in
> your IIS for your web site.
> If does,we had to modify two config files:
> In RSWebApplication.config we added the url to ReportServer using the host
> header
> name in the ReportServerUrl element.
> In rsreportserver.config, we modified the UrlRoot element to use the host
> header
> name rather than the machine name in the url to ReportServer.
> Hope this information will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Acsla,
Then, could you check the two configuration files I mentioned in the
previous post and use the correct value for the element?
You need to use the http://servername/reportserver in those elements.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Report Server Password
I am in a panic right about now. We had to change the Admin (server) password and it is working fine to log on to Windows, but when I click on IE and navigate to the report server, it is asking me for the old password still. I am new to SRS, so I am learning as I go. I found some threads on using the rsconfig.exe and I fiddled around in it and now (in addition to requesting the old password to log on to the report server) all of the reports I created have a user name and password field that requires the SA password for connecting to the data source.
Is there any way I can fix this or do I just need to uninstall SRS from the server and re-install it? I found the following thread, but am a little skiddish about doing anything else in light of the current state I put the report server in.
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1031391&SiteID=1
Any suggestions?I got it, amd it was actually pretty simple. I just had to delete the folders from the Report Server (the ones you see when you go to the http://) and then re-build them.Report Server Instance
How do I reference a URL for a Report Server Running on an instance in SQL
Server 2005. I thought it was a $ sign but this is not working (i.e.
http://REPORTSERVER$DEVDW/Reports)
Default Instance : REPORTSERVER
URL: http://REPORTSERVER/Reports
Instance 1: REPORTSERVER\DEVDW
http://?/Reports
Instance 2; REPORTSERVER\PRODDW
http://?/ReportsGot it!!!
http://REPORTSERVER/Reports$INSTANCENAME
"Scott" wrote:
> How do I reference a URL for a Report Server Running on an instance in SQL
> Server 2005. I thought it was a $ sign but this is not working (i.e.
> http://REPORTSERVER$DEVDW/Reports)
> Default Instance : REPORTSERVER
> URL: http://REPORTSERVER/Reports
> Instance 1: REPORTSERVER\DEVDW
> http://?/Reports
> Instance 2; REPORTSERVER\PRODDW
> http://?/Reports
Server 2005. I thought it was a $ sign but this is not working (i.e.
http://REPORTSERVER$DEVDW/Reports)
Default Instance : REPORTSERVER
URL: http://REPORTSERVER/Reports
Instance 1: REPORTSERVER\DEVDW
http://?/Reports
Instance 2; REPORTSERVER\PRODDW
http://?/ReportsGot it!!!
http://REPORTSERVER/Reports$INSTANCENAME
"Scott" wrote:
> How do I reference a URL for a Report Server Running on an instance in SQL
> Server 2005. I thought it was a $ sign but this is not working (i.e.
> http://REPORTSERVER$DEVDW/Reports)
> Default Instance : REPORTSERVER
> URL: http://REPORTSERVER/Reports
> Instance 1: REPORTSERVER\DEVDW
> http://?/Reports
> Instance 2; REPORTSERVER\PRODDW
> http://?/Reports
Saturday, February 25, 2012
Report server does not initialize
I am using ms sql 2005 standard edition on windows Nt
Everything is working fine except the report server..
when i run the configuration tool and try to start the report server, it fails to start.. i am using sql on the local machine .
i have set p lmy database on the windows credentials..
i am using my machine name/user name as the account name for the database setup.
i have also used rsconfig utility to configure the report server but nothing happens after that..
pls help
SQL Server 2005 introduces a new inteface for configuring the report server. It is located under Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> Reporting Services Configuration. YOu can reinitialize your report also from here with the graphical UI. If that doens′t solve the problem, try to get the error messages fromt he log directory and the event log to see what is going on behind the scenes.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
Thanks Jens
I did manage to start my report server.But when i try to build reports in Business intelligence, i get an error saying "out of memory exception".
Everything seems to be running fine in the configuration manager..i even tried to run the service pack 1 but it doesnt work. i get an error which says " setup is not able to access sql with the login details.
I have checked the login details as well.... both RS and SQL server use windows credentials
Please help..what do i do?
|||That sounds strange. Are you getting the errors while deploying the reports on the server or during the creation of a Reporting Services project ? Although it could be that there is a problem within your SQL Server (you might check the event logs for abnormalities) there is sure a problem with your client if the error occurs during the creation of the reports. Before finding the needle in the hay, deinstall the tools / client components and reinstall them. Afterwards apply Service Pack 1 and the post hotfixes that you will have the current built of 2153. Let see if that helps.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
i am getting the error when i click the preview button in report server for generating the reports...
i have checked the error log and everything seems to be running fine. i have done the reistallation but it still it does not help. i applied the service pack 1 but it does not run properly. it gives me the error " setup cannot access the sql server with the login deails".. i have checked the logins as well. i am using windows credentials for both sql server and report server. please help me as our entire business is developing report and sending it to our clients...
Report Server Database
I forgot where I installed my Report Server Database! Reporting Services is
working fine but I just want to make sure we are backing up the database.
Help!The database(s) for SQLRS are usually stored in the local SQL instance,
unless you tried to specify elsewhere that is.
"peetyport" wrote:
> I forgot where I installed my Report Server Database! Reporting Services is
> working fine but I just want to make sure we are backing up the database.
> Help!
working fine but I just want to make sure we are backing up the database.
Help!The database(s) for SQLRS are usually stored in the local SQL instance,
unless you tried to specify elsewhere that is.
"peetyport" wrote:
> I forgot where I installed my Report Server Database! Reporting Services is
> working fine but I just want to make sure we are backing up the database.
> Help!
Monday, February 20, 2012
Report render to PDF hangs
I've got a complex report with many subreports that is running on a reporting services 2005 machine with sp2 installed. The report was working well, producing a 2800 page report in under 10 minutes. I made a change to an expression in a table's column header and one change to the detail and the report stopped working. It would just hang for hours with no messages in the logs.
I tried to simplify what the report server had to do by removing the sum's to the database side's stored proc but that didn't work. I finally managed to get the report to work by removing a totals section to a subreport. I've also had the same hanging condition occur when I merged some columns in the table. I also found a workaround for this problem.
Is anyone else finding problems like this? They don't seem to be code related.
Is there a limit to how complex a report can be in reporting services or the PDF rendering part of the process?
Thanks for any info
There is no easy to define limit to how "much" of a report can be rendered to PDF. It depends on size and complexity of the report and muscle of the server(s). Can you describe the hardware a bit? If you capture a perfmon while the hang is occuring, how does CPU, memory, disk, and network look? Also, is this reproducible? If you revert the change, does the report export?
Thank you.
|||
The machines running are 4 processor 3.2Ghz zeon's with 3GB Ram.
We didn't run perfmon, but normally get paged if there are performance issues.
I am able to reproduce this problem. I narrowed the recordset down to a particular agency, a subset of the full recordset The subset recordset contains 59 rows for the main report and 20 rows for the subreport, so it's not a large amount of data. We have agencies that are many times more complicated that print fine.
Strangely enough, I got it to work, when I pushed off the totals section to a subreport. That section had 2 running sums in it and some expressions based on data fields. I passed those over to the subreport as parameters and it worked fine.
This is not the only time, we've had this hang and had to look for a workaround. I also had a problem like this when I merged some columns in a table. The problem was happening to a completely different agency than before. Now when I develop in this report, I do one thing at a time, then deploy and run to be sure I didn't introduce another hang situation.
Is this behavior common to reporting services?
|||If the dataset is large, the report is complex, the hardware is underpowered, or some combination of the three, exporting to PDF can get bogged down, even in SQL Server 2005 SP2. One way to figure out what's going on is to look at the ExecutionLog table in the ReportServer database.
Execute the report and then look at the last 5 columns. If RowCount is large, consider pushing off some data filtering into the TSQL - this should also decrease TimeDataRetrieval. If TimeProcessing is large, see if there is anything you're doing in the report that can be better handled by SQL server - like, sorting or aggregation. Also, try and reduce the complexity of any expressions you have in the report. If TimeRendering is large, it could be you're running into inefficiencies in the rendering engine. We've made good progress and improved perf in RS 2005 but we're still not where I'd like us to be so have more work to do. If ByteCount is large, consider breaking the report up so users don't have to deal with 50M PDF files. If archival is your goal, you might consider a different format like HTML that is much easier to grep later than PDF. Tudor has some suggestions as well on http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx.
"Hanging" is not common, though slow rendering when there's a lot to do or not enough hardware to do it on is more common.
I don't understand why merging columns would make that much of an impact, however. If you have a repro, please open a bug so I can take a look. If you can't get to http://connect.microsoft.com, you can email me the details directly (click on my name to the left and you'll find my email address).
Thank you.
|||Hi Donovan,
Thanks for your help.
I've got a question still, I'm not sure that this is bug ticket worthy so I figured I'll run it by you here first.
This is from the ExecutionLog table.
This report was successful. This record is the full recordset and produced. I moved a totals section to a sub report to get it to work.
RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount
-- -- -- -- -- - --
0 PDF 2007-03-09 10:14:42.723 2007-03-09 10:22:30.500 19070 269112 179356 1 rsSuccess 8969543 8569
This recordset here, is one that didn't work. This code is prior to me moving the totals section out to a subreport. Also, this recordset is a subset, just one agency and it's associated records. After a half hour I cancelled the job.
The TimeRendering is very large and the TimeDataRetrieval also seems large for that recordset.
RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount
-- - -- -- -- -- - - --
0 PDF 2007-03-08 10:47:09.303 2007-03-08 11:15:53.803 20642 2690 1700930 1 rsJobWasCanceled 0 131
The difference between the 2 versions of code, is that the one that's failing has 3 footer rows for the same grouping, 4 of the text boxes contain =FormatCurrency(Fields!XYZ.Value) type values and one contains an =IIF(Fields!CompType.Value = "SA", "XYZ Based Compensation", "ABC Based Compensation") + " Totals For This Period:"
I replaced those 3 footers, with one footer that calls a subreport, ironically, the sub reports parameters contains the same formatcurrency items and the iif.
I'm not sure what to think, it looks like a bug, but wouldn't TimeDataRetrieval indicate database side inefficiency?
What do you think?
Scott
|||That doesn't sound right - time rendering seems too high. Would you please email me a copy of the rdls so I can see what's happening in the code?
The TIFF and PDF renderer share a lot of the same code. Is TIFF also that slow in exporting that report?
Regarding the TimeDataRetrieval column, if you take the queries out of the reports and run them against the server manually, how do the times compare?
Thank you.
Report render to PDF hangs
I've got a complex report with many subreports that is running on a reporting services 2005 machine with sp2 installed. The report was working well, producing a 2800 page report in under 10 minutes. I made a change to an expression in a table's column header and one change to the detail and the report stopped working. It would just hang for hours with no messages in the logs.
I tried to simplify what the report server had to do by removing the sum's to the database side's stored proc but that didn't work. I finally managed to get the report to work by removing a totals section to a subreport. I've also had the same hanging condition occur when I merged some columns in the table. I also found a workaround for this problem.
Is anyone else finding problems like this? They don't seem to be code related.
Is there a limit to how complex a report can be in reporting services or the PDF rendering part of the process?
Thanks for any info
There is no easy to define limit to how "much" of a report can be rendered to PDF. It depends on size and complexity of the report and muscle of the server(s). Can you describe the hardware a bit? If you capture a perfmon while the hang is occuring, how does CPU, memory, disk, and network look? Also, is this reproducible? If you revert the change, does the report export?
Thank you.
|||The machines running are 4 processor 3.2Ghz zeon's with 3GB Ram.
We didn't run perfmon, but normally get paged if there are performance issues.
I am able to reproduce this problem. I narrowed the recordset down to a particular agency, a subset of the full recordset The subset recordset contains 59 rows for the main report and 20 rows for the subreport, so it's not a large amount of data. We have agencies that are many times more complicated that print fine.
Strangely enough, I got it to work, when I pushed off the totals section to a subreport. That section had 2 running sums in it and some expressions based on data fields. I passed those over to the subreport as parameters and it worked fine.
This is not the only time, we've had this hang and had to look for a workaround. I also had a problem like this when I merged some columns in a table. The problem was happening to a completely different agency than before. Now when I develop in this report, I do one thing at a time, then deploy and run to be sure I didn't introduce another hang situation.
Is this behavior common to reporting services?
|||If the dataset is large, the report is complex, the hardware is underpowered, or some combination of the three, exporting to PDF can get bogged down, even in SQL Server 2005 SP2. One way to figure out what's going on is to look at the ExecutionLog table in the ReportServer database.
Execute the report and then look at the last 5 columns. If RowCount is large, consider pushing off some data filtering into the TSQL - this should also decrease TimeDataRetrieval. If TimeProcessing is large, see if there is anything you're doing in the report that can be better handled by SQL server - like, sorting or aggregation. Also, try and reduce the complexity of any expressions you have in the report. If TimeRendering is large, it could be you're running into inefficiencies in the rendering engine. We've made good progress and improved perf in RS 2005 but we're still not where I'd like us to be so have more work to do. If ByteCount is large, consider breaking the report up so users don't have to deal with 50M PDF files. If archival is your goal, you might consider a different format like HTML that is much easier to grep later than PDF. Tudor has some suggestions as well on http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx.
"Hanging" is not common, though slow rendering when there's a lot to do or not enough hardware to do it on is more common.
I don't understand why merging columns would make that much of an impact, however. If you have a repro, please open a bug so I can take a look. If you can't get to http://connect.microsoft.com, you can email me the details directly (click on my name to the left and you'll find my email address).
Thank you.
|||Hi Donovan,
Thanks for your help.
I've got a question still, I'm not sure that this is bug ticket worthy so I figured I'll run it by you here first.
This is from the ExecutionLog table.
This report was successful. This record is the full recordset and produced. I moved a totals section to a sub report to get it to work.
RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount -- -- -- -- -- - -- 0 PDF 2007-03-09 10:14:42.723 2007-03-09 10:22:30.500 19070 269112 179356 1 rsSuccess 8969543 8569This recordset here, is one that didn't work. This code is prior to me moving the totals section out to a subreport. Also, this recordset is a subset, just one agency and it's associated records. After a half hour I cancelled the job.
The TimeRendering is very large and the TimeDataRetrieval also seems large for that recordset.
RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount -- - -- -- -- -- - - -- 0 PDF 2007-03-08 10:47:09.303 2007-03-08 11:15:53.803 20642 2690 1700930 1 rsJobWasCanceled 0 131The difference between the 2 versions of code, is that the one that's failing has 3 footer rows for the same grouping, 4 of the text boxes contain =FormatCurrency(Fields!XYZ.Value) type values and one contains an =IIF(Fields!CompType.Value = "SA", "XYZ Based Compensation", "ABC Based Compensation") + " Totals For This Period:"
I replaced those 3 footers, with one footer that calls a subreport, ironically, the sub reports parameters contains the same formatcurrency items and the iif.
I'm not sure what to think, it looks like a bug, but wouldn't TimeDataRetrieval indicate database side inefficiency?
What do you think?
Scott
|||That doesn't sound right - time rendering seems too high. Would you please email me a copy of the rdls so I can see what's happening in the code?
The TIFF and PDF renderer share a lot of the same code. Is TIFF also that slow in exporting that report?
Regarding the TimeDataRetrieval column, if you take the queries out of the reports and run them against the server manually, how do the times compare?
Thank you.
Subscribe to:
Posts (Atom)