Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1084
  • Last Modified:

CR report with multiple subreports, get error when paging.

I recently converted from CR ver 8 to CR ver 11.  I call a report via an ASP page that renders the CR plugin in an IE6 browser.  I'm using IIS.
The simple reports with no subreport, or only one subreport are working.
The more complex reports, ones with multiple subreports are a problem.
The problem is triggerred when I attempt to page forward or jump to last page, I get this error:

"craxdrt error caused on server. -2147191294 : this group section cannot be printed because its condition field is nonexistent or invalid. format the section to choose another condition field."

Within the CR ver11 IDE, the complex report performs as expected, I can preview and see data.  
But when deployed to the server, the paging is a problem.

Has anyone had this problem?  If yes, how did you fix this?
0
jvl72732
Asked:
jvl72732
  • 10
  • 9
  • 2
1 Solution
 
MIKESoftware Solutions ConsultantCommented:
Well...to jump from Version 8 to XI is a Big...big..jump.

Have you physically "opened" the report in XI and then saved it in XI prior to trying to run...or process it on the server??

I guess my real question is....when you say YOU CONVERTED...what exactly did you do to convert ALL OF YOUR REPORTS from version 8 to version XI...????
0
 
jvl72732Author Commented:
By 'converted', I mean I followed the CR instructions.  Opened the rpt in the new CR11 ide, set database, repaired mapped fields where needed, and updated the ASP with a few modifications per the sample ASP provided by CR.  The reports run successfully in preview mode within CR 11 ide.

I'll be back Monday.
0
 
mlmccCommented:
Which release of CR XI? R1 or R2?

mlmcc
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
MIKESoftware Solutions ConsultantCommented:
Ok..so then ..for the report(s) that aren't running correctly,...I would suggest having a Developer go into the reports and checkout the SECTION EXPERT...to see what the issue is....It sounds like there are some "control" formulas that are not working correctly.

Shooting from the hip here.......?????

M
0
 
jvl72732Author Commented:
Regarding which release of CR XI? R1 or R2?   I'm unsure, in the About window, the version info is: 11.0.0.1282    Where would I check for R1 or R2?

Regarding inspecting SECTION EXPERT, to avoid confusion and for simplicity I will discuss only one report, named gfl74.  
In gfl74.rpt, there are several sections, a Page Header B, with a suppress formula when Page>1.  That prevents headers on subsequent pages.

Attached image01.jpg shows a formula field which sets up a Shared numberVal bLegend.

Attached image02.jpg shows GroupHeader 1d, suppress formula, referring to the bLegend variable and setting it to 0.



image01.jpg
image02.jpg
0
 
jvl72732Author Commented:
The Shared number variables purpose is to suppress the section the Legend subreport is in when the group by field is blank or null.  There are four subreports located within a group by section.  Three of those subreports run off a user supplied parameter, and may or may not have data.  The fourth subreport the "Legend" subreport is static.  It always shows the same data, it's just a display of code translations.  The Legend subreport should be displayed when the other subreports return data, it is suppressed when the other subreports do not return data.
0
 
jvl72732Author Commented:
In reply to mlmcc's link: I tried to implement the proposed solution.  However I did not find a checkbox for "Verify on Every Print" under the Database dropdown menu.
0
 
mlmccCommented:
In File --> REPORT OPTIONS there is a VERIFY ON FIRST REFRESH
Uncheck it.

mlmcc
0
 
jvl72732Author Commented:
In File --> REPORT OPTIONS,  VERIFY ON FIRST REFRESH was NOT checked.
0
 
mlmccCommented:
Don't know.

mlmcc
0
 
jvl72732Author Commented:
Additional info:  gfl74.rpt has 6 subreports.  As a test I deleted 5 of the six subreports and retested the new rpt in preview mode and via the asp call.  It worked fine.  I repeated this test with the other five subreports, testing each one individually, they all worked fine.  Some of the subreports were short, not generating a second page of data.  Some of the subreports spanned many pages, navigating to the next or to the last page was not a problem.

The asp I've coded runs sql and captures the recordset in a session object.  That recordset object is then attached to the rpt via:

Set oSubRptTable5 = CRSubrpt5.Database.Tables.Item(1)
oSubRptTable5.SetDataSource session("oRs6"), 3

I'm assuming the data is held server side, only sending the data that is currently displayed or requested.
When the next button is clicked on the plugin viewer, one page of data is sent client side.
When the goto last page button is clicked, all the data  is sent client side.

I bring this up because it seems that paging over multiple subreports is the issue, despite what the the error message says, that message might be misleading.

I've checked all the formula fields, they passed the check test.  
I tried running the report with and without a group section, that did not change the outcome.
........?
0
 
mlmccCommented:
What if you add 2 subreports?

mlmcc
0
 
jvl72732Author Commented:
I took the original report with 6 subreports, deleted 4 subreports.
Leaving only two subreports.  One is very short, displaying only 2 lines, the other is variable, depending on the query it can return zero records or it can return many pages of data.  The particular data I queried returned 2 pages of data.  And paging is working fine.

I tried with 3 subreports, paging throws the error.  I have tried this before.

0
 
mlmccCommented:
Can you go to the last page?
If so does the paging work then?

mlmcc
0
 
jvl72732Author Commented:
I cannot goto the last page.

When I try to use the 'next page' button I always also try the 'last page' button.  They always work or not work in tandem.
0
 
mlmccCommented:
Just making sure.

mlmcc
0
 
mlmccCommented:
Referring to the pictures above.

WHere is the shared variable used to set its value?

Is it used in one of the subreports?

mlmcc
0
 
jvl72732Author Commented:
>>>WHere is the shared variable used to set its value?
>>>Is it used in one of the subreports?

Based on your question regarding if a shared variable is used in a subreport, I pursued tried something different.

One of the subreports uses a GroupBy option.  I removed it and the report produced semi-correct output and paging didn't trigger an error.  So the report sort of works.  Without the GroupBy I am getting data I don't want displayed.   I'd like more info on how the GroupBy can be maniplated to get this report to work the way it used to.
0
 
mlmccCommented:
Is the GroupBy in the SQL?

mlmcc
0
 
jvl72732Author Commented:
I believe I have solved the problem.

The Group By was not in the sql, within the CR v11 IDE, there is a Group Expert option.  
I was using that to group the data within one of the subreports.
I removed the Grouping in the rpt file.  Updated the sql in the ASP to handle it there.
Ran the report via the asp call and it worked.  I get data, I can page, it is grouped/sorted properly.

The only problem is some of the data fields are not being displayed.  
First I tried deleting field and adding it again, no luck.
Second, I created a formula field with that field only, and added it to the report, that worked.

The suggestion to check the Group By led to the solution.
Thank you "mlmcc".


0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 10
  • 9
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now