Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Friday, March 30, 2012

rsExecutionNotFound error

Hello,

I am developing a report viewer application in ASP.NEt 2.0 and in that I have a page called ReportViewer.aspx page which has a report viewer control. The processing mode is remote and it is a SQL Server 2005. There are a couple of dropdownlists one which defines the names of the different reports and the other the reporting periods. Depending on the selection made by the user, the call is made to the reporting server and reporst are displayed. Initially when the page loads, the reports show up without any problems. But if a user is inactive for a while, and the user tries to the view the report, I get the following error

"Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound) "

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: Microsoft.Reporting.WebForms.ReportServerException: Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound).

I did some research and came across this post which is the exact error which i am getting.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124525

The above link is not working for some reason but if you click on the link below, it says that the issue has been fixed. But there is no information as to how to fix this. Does anybody have any idea as to what the solution is?This is the exact same error which I am getting and any help to resolve this error would be great.

http://64.233.183.104/search?q=cache:H2UEJj42ypcJ:connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx%3FFeedbackID%3D124525+rsExecutionNotFound+%2B+2005&hl=en&ct=clnk&cd=1&gl=us

There are some posts which advise to add the a guid at the end of the url but if you are using a viewer you cannot add anything else to the .ServerReport.ReportURL property other than the path to the report or else it returns an error.

As per my knowledge, the report veiwer control should be keeping the session alive using keep alive messages. There is also the possibility of IE caching and one can disable it by going to Tools -> Options and disabling the caching. But this is not something which I can tell my customers to do.

Any help would be greatly appreciated.

Regards,

arpan

Arpan,

My team came across this error a while ago, and found that Reporting Services has it's own session that is timing out. In the ReportServer database, there is a table called ConfigurationInfo. In this table there are values for a SessionTimeout and SessionAccessTimeout. I think the default is set to '600'. This value corresponds to the number of seconds that the report session will be open.

Our solution was to bump this number way up, say to a couple of hours or more. The problem with this is then you get a lot of data in the ReportServerTempDB, which may cause headaches. It's not a perfect solution, and this property should be more easily editable.

The other way to set this property is to use some Reporting Service Scripting, .rss files, and run them using the rs.exe utility that was installed with Reporting Services. There is a Good blog about this by John Gallardo (?) I think.

Good Luck,

Mac

blog url: http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

|||

Mac.

Thanks for the quick reply. I shall try it out tomorrow and see if that helps.

Regards.

arpan

Wednesday, March 28, 2012

RSClientPrint problem

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

Hi Ian,

I am also getting same problem . do you have any solutions for it ?

suresh babu

|||Ian did you solve this issue?.. if you did it.. please let me know to ayoplac@.hotmail.com
|||No, sadly it was never resolved other than using a different reporting system that actually works.

RSClientPrint problem

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

Hi Ian,

I am also getting same problem . do you have any solutions for it ?

suresh babu

|||Ian did you solve this issue?.. if you did it.. please let me know to ayoplac@.hotmail.com|||No, sadly it was never resolved other than using a different reporting system that actually works.

RSClientPrint problem

I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following:

1. Print dialog box appears as expected

2. Press print

3. Dialog box appears saying "Print in progress"

4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005.

I get the same error if I try to preview instad of print.

The (relevent) code is:

<object id="RSClientPrint" classid="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3" codebase="Bin/RSClientPrint.cab#Version=2005,90,1399,0"></object>

<script language="javascript" type="text/javascript">
function printIt() {
RSClientPrint.Print('http://localhost/ReportServer$SQL2005',
'/LMI Reports/GoodsIn&OrderID=1000'),
'Goodsin');
}
</script>

<body onload="printIt()">

Does anybody know what this error is and how I can get the control to work? Its not clear to me what the version on the object statement should be. This example uses the version string from the control but I've also tried 1.0 with the same result. Its also not clear if I should be using RSClientPrint.Authenticate or not. I've tried both true and false with the same result.

Many thanks

Ian

Hi Ian,

I am also getting same problem . do you have any solutions for it ?

suresh babu

|||Ian did you solve this issue?.. if you did it.. please let me know to ayoplac@.hotmail.com
|||No, sadly it was never resolved other than using a different reporting system that actually works.

Monday, March 26, 2012

rsClientPrint Active X question

After loading the object clause for rsClientPrint on my ASPX page, I get the
message at the client that Microsoft is blocking the software because the
publisher is unknown. Can anyone tell me what I might need to do to get past
that.
--
Thanks,
CGWFound my problem.
--
Thanks,
CGW
"CGW" wrote:
> After loading the object clause for rsClientPrint on my ASPX page, I get the
> message at the client that Microsoft is blocking the software because the
> publisher is unknown. Can anyone tell me what I might need to do to get past
> that.
> --
> Thanks,
> CGW|||Hi, how did you fix your problem? I have the same problem, that is
preventing me from using a program download (from american greetings.com)
that I've been using all along. I need a new Active-X plugin, but the
publisher is unverifiable. Thanks much!
Mary
"CGW" wrote:
> Found my problem.
> --
> Thanks,
> CGW
>
> "CGW" wrote:
> > After loading the object clause for rsClientPrint on my ASPX page, I get the
> > message at the client that Microsoft is blocking the software because the
> > publisher is unknown. Can anyone tell me what I might need to do to get past
> > that.
> > --
> > Thanks,
> >
> > CGW|||I wish I could remember. We ended up taking a different approach and I didn't
keep my work on that. I know I googled around for an answer and it seems that
it had to do with getting the cab file in the right location. Sorry. If I
remember, I'll send it to you. And from now on, when I find a solution, I'll
mention what it was while it's still fresh on my mind.
--
Thanks,
CGW
"Mary" wrote:
> Hi, how did you fix your problem? I have the same problem, that is
> preventing me from using a program download (from american greetings.com)
> that I've been using all along. I need a new Active-X plugin, but the
> publisher is unverifiable. Thanks much!
> Mary
> "CGW" wrote:
> > Found my problem.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "CGW" wrote:
> >
> > > After loading the object clause for rsClientPrint on my ASPX page, I get the
> > > message at the client that Microsoft is blocking the software because the
> > > publisher is unknown. Can anyone tell me what I might need to do to get past
> > > that.
> > > --
> > > Thanks,
> > >
> > > CGW

rsAccessDenied

The permissions granted to user 'localmachine\ASPNET' are insufficient for performing this operation.

am using a report viewer on an aspx page that i call using javascript. the report work if the url have the port number for examplehttp://localhost:4254/adressofthereport but if i put for examplehttp://localmachinename/adressofthereport i get the permission error.

why this happen to me... please help.

i fix this inserting the localmachine\ASPNET user in the reports permissions

BUILTIN\administrator

localmachine\ASPNET

maybe you need to add dbowner o sysad access level to this user.

|||

Thanks.I am having same problem and i found the solution thanks.

rsAccessDenied

Hi i am having this error when i am running my default1.aspx page in localhost.I am using sql server 2005 reporting services and i have made one report in business intelligence tools reporting service through wizard.And deploy it it is running in report server.I am using one page that is default1.aspx and using report viewer and set the path that is debugging and showing that report but when i am running that in url writehttp://localhost/testdemo/default1.aspx so it is giving error

that error is"The Permission Granted to user "UserName/ASPNET" is insufficient for performing this operation.(rsAccess Denied)

Please help me to solve this problem.

Hiswapnil.malviya ,

See posthttp://forums.asp.net/t/1168322.aspx

Please do not make duplicated posts. Thanks for your cooperatoin. thanks

Friday, March 23, 2012

RS2k5 Crashes exporting to Excel

We've got a clinet that has no issues exporting reports to excel about 95%
of the time. However, about once a month, they get the error page "For more
information abou this error navigate to the report server on the local
server machine, or enable remote errors."
In the app event logs, there is the following error: Report Server
(MSSQLSERVER) cannot connect to the report server database.
I'm not finding anything useful in the groups. Thanks for any help.Hi Jack,
One good place to look is in the actual SRS error logs. This can usually be
found at <SRS Install Directory>\Reporting Services\LogFiles. Check the
ReportServer logs for the day of the error. Often times, the stack trace of
the error is there and can help you diagnose the root cause of the issue.
Brian
--
Brian Knight
Quaere SQL Server Blog
http://dba.typepad.com
"Jack" wrote:
> We've got a clinet that has no issues exporting reports to excel about 95%
> of the time. However, about once a month, they get the error page "For more
> information abou this error navigate to the report server on the local
> server machine, or enable remote errors."
> In the app event logs, there is the following error: Report Server
> (MSSQLSERVER) cannot connect to the report server database.
> I'm not finding anything useful in the groups. Thanks for any help.
>
>

RS2005 Report Paper / Page / Scaling - Setup

Hi,
I've a report with more than 20 columns in it. I want to print this
report in "1 page wide/Multi page tall" scaling & also in "Legal paper
- Landscape orientation". I was able to set the Landscape in the Page
setup, but not the scaling/Paper selection! Is there any way to do this
setting for each report in RS? Right now, the columns are getting
printed in multiple pages.
Actually I've this report in Excel as well. As you know, in excel I can
set the "Print Area and all the Page setup" through a macro which is
running properly. Now, I cannot ask the users to generate the report in
RS and export the report to Excel, then set the "Print Area & Page
setup" & then Print it, which I don't think they'll buy it. I also dont
want to have a separate front-end in .Net or something else to do this
setup!
Is there any way to do this in RS 2005?
Thanks,
GaneshThe only way I have managed to do this is programmatically. I get the
report as a Metafile image using the webservice and can then print this
image scaled to the paper afterwards.
Craig
"Ganesh" <imsganesh2@.gmail.com> wrote in message
news:1142364252.533688.323570@.i39g2000cwa.googlegroups.com...
> Hi,
> I've a report with more than 20 columns in it. I want to print this
> report in "1 page wide/Multi page tall" scaling & also in "Legal paper
> - Landscape orientation". I was able to set the Landscape in the Page
> setup, but not the scaling/Paper selection! Is there any way to do this
> setting for each report in RS? Right now, the columns are getting
> printed in multiple pages.
> Actually I've this report in Excel as well. As you know, in excel I can
> set the "Print Area and all the Page setup" through a macro which is
> running properly. Now, I cannot ask the users to generate the report in
> RS and export the report to Excel, then set the "Print Area & Page
> setup" & then Print it, which I don't think they'll buy it. I also dont
> want to have a separate front-end in .Net or something else to do this
> setup!
> Is there any way to do this in RS 2005?
> Thanks,
> Ganesh
>|||Thanks Craig!
Can't we do this any other reporting tool? How about in Crystal
Reports. I remember doing this when I was on Crystal Reports a year
back. Is there no other way to do this? I can't sell RS to my users
(who are very comfortable with Excel 2000) without this option.
or Can you tell me how you did this programmatically to get report as a
Metafile and print it?
Thank you!|||Hi All,
Can anyone please tell me whether this is not possible at all in
RS2005, so that I don't have to waste much time in searching for this
all over the net?
Thanks!

RS2005 Print Legal

Hello,
I'm trying to automate printing to legal size paper from the web
ReportViewer control.
In my Report Properties / Layout I have Page Width= 14in and Page
Height= 8.5in.
When the report renders I hit the print icon. It shows that the report
will print to landscape,
but the paper size is set to Letter.
Is there a way to programatically set the paper size to legal?
TIA,
JimNo you can not set this on the fly, and there have been bugs regarding the
portrait/landscape issue..
However you may have the settings backward... Width should be 8.5in and
height should be 14in...(myabe you just typed it backward in your post.)
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jhcorey@.yahoo.com" wrote:
> Hello,
> I'm trying to automate printing to legal size paper from the web
> ReportViewer control.
> In my Report Properties / Layout I have Page Width= 14in and Page
> Height= 8.5in.
> When the report renders I hit the print icon. It shows that the report
> will print to landscape,
> but the paper size is set to Letter.
> Is there a way to programatically set the paper size to legal?
> TIA,
> Jim
>

Tuesday, March 20, 2012

RS-2000 Report Manager time out(?)

I have a query that takes about 2 minutes to complete, but Report Manager displays the Web Page Cannot be Found message at precisely 1 minute after submitting. I'm assuming that this is a time limit that is set somewhere. Is there a setting I can change, either in IIS or in Reporting Services, to extend this time limit? I have looked and whatever I have changed doesn't seem to make any difference?

Thanks,

Al

There are settings on both individual reports and on the server as a whole.

You can get to the system wide settings by going to 'Site Settings' in Report Manager.

Individual reports can be changed by going to the report properties, then 'Execution' within Report Manager.

Regards

Paul

RS2000 - getting Page Numbers of SubReport to print in Main Report

We have a report that calls several other subreports. These subreports in and
of themselves are reports and in the footer of these reports are page number.
When we run the reports independently they have page numbers. Unfortunately,
from the main report the page numbers of each sub report do not print. Is
this a Reporting Service bug?
OR
Does anybody have any suggestions if there are say 10 "daily reports" that
need printed at once? Is there a way to queue them all up and have them print
with Page numbers of each?
Thanks!I have the same question.
Any one who knows a good way to render several reports at the same time? Or
the same report with different data. For example one report for each member
of a group?
The user should be able to se all the pages with page numbers and total
pages of the sub report. I have a work around solution for the page numbers,
but not for the total pages.
See: http://blogs.msdn.com/bwelcker/archive/2005/05/19/420046.aspx
Note that the solution for the page numbers only works if one user opens the
report.
"CraigZello" wrote:
> We have a report that calls several other subreports. These subreports in and
> of themselves are reports and in the footer of these reports are page number.
> When we run the reports independently they have page numbers. Unfortunately,
> from the main report the page numbers of each sub report do not print. Is
> this a Reporting Service bug?
> OR
> Does anybody have any suggestions if there are say 10 "daily reports" that
> need printed at once? Is there a way to queue them all up and have them print
> with Page numbers of each?
> Thanks!

Monday, March 12, 2012

RS Web Part Scrolling

I have installed 4 RS Viewer Web Parts on a share point page. When I
click on the + sign to expand the detail of a report the detail area
scrolls to the top of the sharepoint page. If all four web parts were
viewable and you were on the 2nd one down from the top, the first one
completely disappears. The only way to see it is to use the scroll bar
to move to the top of the page again. This behavior only happens with
RS Web Parts. This is very anoying as you must find your place on the
page everytime you click on a + or - sign. The page is always jumping
around.
Does anybody know how to stop this?Hi
It would be great if anyone can responde to this question since I'm having
the same problem. My end users are getting so anoyed that they have no
interest in using any drill-down reports. As soon as a report is anything
other than a very basic report with only one or two grouping levels,
drill-down functionality is useless.
This is very bad for those of us that recommended SQL RS to our
organizations as an enterprise reporting solution.
Can someone please help us with this?
"Jiles" wrote:
> I have installed 4 RS Viewer Web Parts on a share point page. When I
> click on the + sign to expand the detail of a report the detail area
> scrolls to the top of the sharepoint page. If all four web parts were
> viewable and you were on the 2nd one down from the top, the first one
> completely disappears. The only way to see it is to use the scroll bar
> to move to the top of the page again. This behavior only happens with
> RS Web Parts. This is very anoying as you must find your place on the
> page everytime you click on a + or - sign. The page is always jumping
> around.
> Does anybody know how to stop this?
>

Friday, March 9, 2012

RS prints only the first page

Hi,

I have several reports out of which only one report is acting weirdly.
The report displays fine when I open it up but when I try to print it,
it only prints the first page. I tried exporting it to PDF and the same
thing, the PDF has only one page. I tried exporting in all formats and
found that PDF and TIF are not working but the other formats (web
archive, HTML, XML and CSV) are fine. The excel format gives me this
error:

Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index

I need the PDF format to work. Any ideas why this particular report is
bad? Another note of interest. This report uses only a subreport that works
fine in another report. Please help.

Thanks,

Anand

Hey what's up Anand. hsg7@.dcx.com Holly

RS prints only the first page

Hi,

I have several reports out of which only one report is acting weirdly.
The report displays fine when I open it up but when I try to print it,
it only prints the first page. I tried exporting it to PDF and the same
thing, the PDF has only one page. I tried exporting in all formats and
found that PDF and TIF are not working but the other formats (web
archive, HTML, XML and CSV) are fine. The excel format gives me this
error:

Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index

I need the PDF format to work. Any ideas why this particular report is
bad? Another note of interest. This report uses only a subreport that works
fine in another report. Please help.

Thanks,

Anand

Hey what's up Anand. hsg7@.dcx.com Holly

RS prints first page only

Hi,
I have several reports out of which only one report is acting weirdly.
The report displays fine when I open it up but when I try to print it,
it only prints the first page. I tried exporting it to PDF and the same
thing, the PDF has only one page. I tried exporting in all formats and
found that PDF and TIF is not working but the other formats (web
archive, HTML, XML and CSV) are fine. The excel format gives me this
error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown.
Index was out of range. Must be non-negative and less than the size of
the collection. Parameter name: index
I need the PDF format to work. Any ideas why this particular report is
bad? Another note of interest. This report uses a subreport that works
fine in another report. Please help.
Thanks,
SkudderDid you find a solution?
I'm having the same problem when exporting to Excel. All other export
formats work ok. With the Excel, I get:
"Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index"
I found one link that talked about needing SP1 installed. That did not solve
my problem, however, since I already have SP1 installed.
"anandpoolla@.gmail.com" wrote:
> Hi,
> I have several reports out of which only one report is acting weirdly.
> The report displays fine when I open it up but when I try to print it,
> it only prints the first page. I tried exporting it to PDF and the same
> thing, the PDF has only one page. I tried exporting in all formats and
> found that PDF and TIF is not working but the other formats (web
> archive, HTML, XML and CSV) are fine. The excel format gives me this
> error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown.
> Index was out of range. Must be non-negative and less than the size of
> the collection. Parameter name: index
> I need the PDF format to work. Any ideas why this particular report is
> bad? Another note of interest. This report uses a subreport that works
> fine in another report. Please help.
> Thanks,
> Skudder
>|||Ok, I found a fix:
Does any of your text boxes reference another field?
The following was the syntax I did have, and then what I changed it to that
fixed the problem.
OLD WAY:
=(ReportItems!textbox2.value / ReportItems!textbox3.value)
NEW WAY THAT FIXED THE EXPORT TO EXCEL:
=ReportItems!textbox2.value / ReportItems!textbox3.value
So as you can see, remove the parentheses.
"anandpoolla@.gmail.com" wrote:
> Hi,
> I have several reports out of which only one report is acting weirdly.
> The report displays fine when I open it up but when I try to print it,
> it only prints the first page. I tried exporting it to PDF and the same
> thing, the PDF has only one page. I tried exporting in all formats and
> found that PDF and TIF is not working but the other formats (web
> archive, HTML, XML and CSV) are fine. The excel format gives me this
> error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown.
> Index was out of range. Must be non-negative and less than the size of
> the collection. Parameter name: index
> I need the PDF format to work. Any ideas why this particular report is
> bad? Another note of interest. This report uses a subreport that works
> fine in another report. Please help.
> Thanks,
> Skudder
>

Wednesday, March 7, 2012

RS inserts improper page breaks in report

Hi guys,
I try to find for an answer for this problem, but to no available, it drives
me crazy now.
I am getting a page break on each details row in a table. The table has 3
headers, one is a subreport, and a details row which contains a subreport;
there is no footers. The subreport in the details row contains another
subreport that has a table with 1 header and 1 details row, each has a
subreport. It's like so 3 levels deep.
My problem occurs in the first table, the subreport in the details line is
always generated on a new line. I check all the option with BreakPageAt End
and such, but everything is unchecked.
Any ideas.
Thanks!
RobertDo you have any grouping going on in the table? If so check the
grouping properties and see if you any of the 'page break' before or
after options set...
Cheers,
Ben|||There is the default group that is created but nothing is group on and both
'page break at start' and 'page break at bottom' are unchecked.
I don't know if it is relevant, but the page break only occurs when the
report is in 'print layout' mode.
Thanks!
Robert
sullins602 wrote:
>Do you have any grouping going on in the table? If so check the
>grouping properties and see if you any of the 'page break' before or
>after options set...
>Cheers,
>Ben|||Well, I did some more testing. By observation, it looks to me like RS
calculates all the rows in all my nested subreports, and if the number of
rows is bigger than the space left on the page, it assumes a break is needed.
Ouch.
Anybody else encoutered that?|||Yes we have this behaviour all the time and we raised a support incident with
Microsoft. They didn't want to know - as far as they are concerned it is
working as designed. They told us there is an implicit keeptogether on
anything within list but that using tables should be ok. Are you using lists
anywhere in your sub-reports?
"R Jakubowicz" wrote:
> Well, I did some more testing. By observation, it looks to me like RS
> calculates all the rows in all my nested subreports, and if the number of
> rows is bigger than the space left on the page, it assumes a break is needed.
>
> Ouch.
> Anybody else encoutered that?
>|||Hi Tom,
Yeah tell me about it.
Did you find a hack for it?
And no, i'm not using lists at all, I use tables though.
Tom wrote:
>Yes we have this behaviour all the time and we raised a support incident with
>Microsoft. They didn't want to know - as far as they are concerned it is
>working as designed. They told us there is an implicit keeptogether on
>anything within list but that using tables should be ok. Are you using lists
>anywhere in your sub-reports?
>> Well, I did some more testing. By observation, it looks to me like RS
>> calculates all the rows in all my nested subreports, and if the number of
>[quoted text clipped - 3 lines]
>> Anybody else encoutered that?
--
Message posted via http://www.sqlmonster.com

Saturday, February 25, 2012

RS Custom Toolbar

Hi
We are developing a custom toolbar with the export, zoom,find and
previous/next page browsing functionalities. How can we go about developing
the page browsing functionality?
ThanksCreate
MyQueryDesigner : Microsoft.ReportDesigner.Interfaces.IQueryDesigner
where
public Control ToolBar
from IQueryDesigner
"Priya" <Priya@.discussions.microsoft.com> wrote in message
news:123D3CC1-2ED9-4BF2-A742-E7D1FA3470DB@.microsoft.com...
> Hi
> We are developing a custom toolbar with the export, zoom,find and
> previous/next page browsing functionalities. How can we go about
developing
> the page browsing functionality?
> Thanks