Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Subreports and the request could not be submitted Post Reply Post New Topic
Author Message
Alabaster Brow
Newbie
Newbie


Joined: 06 Sep 2013
Online Status: Offline
Posts: 2
Quote Alabaster Brow Replybullet Topic: Subreports and the request could not be submitted
    Posted: 06 Sep 2013 at 7:57am

Hi,

I have a crystal report (CR 10) being launched from a .Net web application written using VS 2005.

The report contains two charts (bar and line) and two subreports each containing a line graph.

I am getting the dreaded 'The report could not be submitted for background processing' error when I select only certain parameters for the report. The critieria that fails is an 'All' option on a type table. So it is returning much more data than if I select a specific type from the dropdown list on my parameters page.

Also, if I run the report twice in a row, the error does not occur and I get the data I am expecting displayed very nicely.

I only get this error when the application and reports are deployed to the server. No errors are happening locally on my development machine.

If I hide the subreports, the error does not occur. If I move the line charts out of the subreport and place them on the main report, the data takes forever to return - hence my use of the subreports.

I am linking the tables used on the main report and the subreport based on month and year from a date field.

I am at a loss to solve this problem. Any direction provided is appreciated.

IP IP Logged
iSing
Newbie
Newbie


Joined: 12 Mar 2013
Online Status: Offline
Posts: 22
Quote iSing Replybullet Posted: 10 Sep 2013 at 3:20pm
Hi Alabaster Brow
 
I haven't used the setup you have, so I'm guessing a bit here.
 
I think you might have a couple of problems, so I suggest you break it down a bit first.
 
First - check how the dates are handled on your server as opposed to your local machine.  Make sure you're comparing apples with apples.
 
Secondly - since the problem seems to be around your use of "All" as a parameter try this (as it's worked for me):
In your main report
For each subreport
Remove the link to your subreport
Save Report
Open your subreport & check in your select expert that it has actually removed the reference.
Save Report
Relink subreport
Save Report
Go back into your subreport & check that Crystal hasn't become creative with it's linking.
 
If that doesn't solve it:
Check how the use of "All" is being handled by your subreports - especially if they're expecting a date.  If necessary, save them separately & run them separately.
Load the individual subreports to your server & see if they work with your parameters.  That will tell you if it's your subreports or your main/sub report links.
Load your subreports back in 1 at a time to your main report & see if they run on your server.  That should find out which one isn't playing ball.
 
And now for the wild stab in the dark - check if the use of "All" somehow conflicts with your .net application or VS2005.
 
 
 
 
IP IP Logged
Alabaster Brow
Newbie
Newbie


Joined: 06 Sep 2013
Online Status: Offline
Posts: 2
Quote Alabaster Brow Replybullet Posted: 17 Sep 2013 at 8:50am
Hi,
 
Thank you for responding. I do not think it is the All, as I am using that in multiple reports. I think it is table linking, or something similar in the Crystal Report itself.
 
So, I followed your suggestion to take the graphs out of the subreport and put them in a test report. They worked ok, but I needed to link the tables on Month and Year.
 
Then, going back to my original report, I took the graphs out of the subreport and placed them in the main report. I rearranged my sql a bit and things are running much faster now.
 
But, I am getting duplicate records on the graphs that were in the subreport if I put them in the report footer where I want them. If I take them out and put them in the group footer, there are no duplicates, but I only want them to show up once.
 
When I run my queries in SQL server, none of this extra data is returning.
 
The listbox with the 'All' is a company listbox . My other parameter is a date range. If I select 3 companys, my report footer graph is repeated 3 times. I think I am getting close, but I don't have the expertise to solve this.


Edited by Alabaster Brow - 17 Sep 2013 at 8:51am
IP IP Logged
iSing
Newbie
Newbie


Joined: 12 Mar 2013
Online Status: Offline
Posts: 22
Quote iSing Replybullet Posted: 19 Sep 2013 at 12:45am
Hi Alabaster Brow
 
OK - to clarify - you're now getting duplicate data (you do mean that you were expecting a count of 10 & you got 20 - or do you mean you're getting 2 identical graphs or something else?).
 
If so, this is new behaviour on top of your previous problem - correct?
 
I'll give you an example of how charts are supposed to work & see if that helps.  If this the following isn't clear - it might pay to recreate this as this is kinda hard to explain via text without pictures.
 
Say you want to report on sales to each office for each company.
Group 1 - companyid
Group 2 - office
 
Create a chart - put it in Group 1 footer (company)
On change of select CompanyID.  Show Value(s) - select salesid
This will give you one chart per company with one riser showing the overall sales for that company.  So if you have parameter has returned three companies, you will get three charts - showing different totals.
 
If the same report is put into Group 2 footer (office) - this will give you one chart with one riser which shows the sales for each office.  Thus if Company A has two offices, you will have two charts - one for each office - in addition to the existing one you have for overall sales for that company. 
If Company B has one office - you'll get one chart for it's single office. 
If Company C has 5 offices - you'll get 5 charts.
 
If the same report is put into Report footer - this will give you one chart with three risers (a count of the sales for each company). 
 
To get one chart that gives you the sales by office by company
Go to the chart in the Group 1 footer (company).
Right click - chart expert - data  & add the field of office to the on change of criteria (in addition to the existing 'company id'), then you will get a count of sales for each office in the same chart.
(Thus Company A will have one graph with two risers.  Company B will have one chart with one riser, Company C will have one chart with 5 risers).
 
If you put this new chart in the report footer - you will get one chart with 8 risers (for the eight offices) but they will be grouped by company (eg all the risers for Company A will be the same colour etc). 
 
If you don't already - can you add a formula to do a test count (same as what you're counting in the chart) - to see if the problem is with the chart & it's setup, or the raw data coming into the main report.
 
If the formula figures & chart figures match, then try stripping out your grouping & add it back in one at a time & see how that affects your chart.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.