Are you using the subreport to display any other information?

What do you need suppressed based on the subreport?

You can't suppress any sections that are before the subreport or the section the subreport is in based on the subreport return.  The subreport is the last object evaluated/rendered in the section.

DO you need the group headers suppressed?

WHy are you using a subreport?

mlmcc

Hi MLMCC,

In response:
Are you using the subreport to display any other information?  The subreport confirms the SKU then gives the Qty and Bulk location code where the stock is located in Bulk

What do you need suppressed based on the subreport? I need the detail line in the main report to be surpressed if there is no info detected in subreport as I'm building a Stock Replenishment Report to get emailed to Goods In.

You can't suppress any sections that are before the subreport or the section the subreport is in based on the subreport return.  The subreport is the last object evaluated/rendered in the section. I could insert another detail line and enter the subreport into this section.

DO you need the group headers suppressed?  Its the detail line mainly so that all that is reported on is the stock where it is low/zero in Main warehouse but held in bulk warehouse

WHy are you using a subreport?  We have a rather complex database and each location has a pick face definition where we state the Min/Max of a product/Sku.  Stock info is held in a seperate tables that dont like to be linked so inserting a subreport gets the info we need, I just need to get rid of the detail lines where no stock is in Bulk as currently I have 40 odd pages and would like to reduce this so when Goods in have the finished article all they see is what they need to action.

Thank you for your response, I feel I'm not that far away but cant put my finger  on it, i have included a screen shot.

Hi mlmcc,

Thank you for your solution, I appreciate your help as I've reached a point where I understand what I'm doing as you have suggested but the report still isn't suppressing as indicated therefore I must have missed something.  

Just to recap:
a) I have entered a second detail section, moved the main report details into details b and moved the subreport into details a.
b) I have created a formula in Main report titled SubReportCount, do i insert this into the main report header or on detail line?
c) I have then created a formula within the sub report titled SubReportCount, where if anywhere is this entered in the subreport?
d) When I check the formula's in both reports they are null so I think its here that it falls down.  Should either of the formula's contain values?
e) Also just to add, when I attempt to suppress the blank section, do I right click on the subreport from the main report and 'format subreport' using the forth tab, there isnt anywhere to enter the suppress formula?

I'm certain this will work, I just need to understand where I'm going wrong :0-)

This is what the report looks like with 2 detail lines, the formulas have been created in both main and sub reports and the next step is to insert the suppress formula:

Many, many thanks in advance,

AJ

>>b) I have created a formula in Main report titled SubReportCount, do i insert this into the main report header or on detail line?
Put in the main report Report Header

>>c) I have then created a formula within the sub report titled SubReportCount, where if anywhere is this entered in the subreport?
The formula in the subreport goes where you are setting the count.

>>d) When I check the formula's in both reports they are null so I think its here that it falls down.  Should either of the formula's contain values?
The formula in the main report won't show a value because the formula returns a blank

>>e) Also just to add, when I attempt to suppress the blank section, do I right click on the subreport from the main report and 'format subreport' using the forth tab, there isnt anywhere to enter the suppress formula?
The blank section is suppressed in the Section Expert

mlmcc

It looks like you're getting close to a solution, but there may be one issue with the count.  In my experience, if a subreport doesn't read any records (the record selection formula excludes everything), then the formulas in the subreport aren't evaluated, even if they're in the subreport report header.  So, if there is no stock in the bulk warehouse, your count variable may not get set in the subreport (leaving it with the count for the last SKU ID in the main report that had something in the bulk warehouse).

 If that's an issue, you can handle it by adding a new main report detail section above the section that contains the subreport, and setting the variable to 0 there.  That would just reset the count to 0 for each new item, and then if the subreport finds some records, it will update the count.

 Just create a formula like the following in the main report, and put it in the new detail section (above the subreport section):

WhilePrintingRecords;
Shared NumberVar subRecordCount;
subRecordCount := 0;
''

 mlmcc sort of covered this, but, in case it still isn't clear, the quotes at the end are just so the formula doesn't produce any visible output on the report.  You can suppress the new detail section, or set it to "suppress when blank".

 James

Thanks James for your input, I have followed both mlmcc and your advice (Shared Variables are something new for me after all these years) to the letter and in some respects the report is functioning however i think there is a slight  error somewhere as some records are showing even though the subreport is blank.

Below is a shot of the first record the report has detected where stock is in the bulk warehouse, there are lots of records before and after that in theory i shouldn't be seeing.  This then continues right to the end and the report is 30 pages long.


My aim is to schedule these to be delivered to Goods In every 4 hours so that it saves time using the client replenishment report which takes time to populate. My end vision is for the report to only show the record in the main report when it detects stock in bulk sub report, so they will get a email containing a list with mainly red records and be limited to a few pages of action by Goods In.

I really do appreciate all comments as I always enjoy finding and learning something new in Crystal  :-)

I have shown below how the design of the report looks, I believe I have set it up correctly but if you can spot anything from this do let me know :-)

It would probably help if you could post the report (.RPT) file.  There's only so much that we can tell from screenshots.

 James

Hi James,

If you pick up on anything I may have missed, please could you let me know so I can understand where I went wrong.  Thank you for all the input received so far, its greatly appreciated :-)  

I've requested to the powers that be that i would probably benefit from more training.  I went on a beginner course 2004, self taught the rest with some help from forums :-)  If you could advise as to any worthwhile training or literature that would be the icing on the cake :-)

Many thanks,

AJ
Pick-Face-definition-Report-2017edit.rpt

I think you will find that most of us had limited initial training and learned most of it through this site or other avenues on the web.
I had no formal training.

I do recommend a book by George Peck - The Complete Crystal Reports xx Reference

The SAP/Crystal site has an excellent knowledge base though it is a bit difficult to use and search.

mlmcc

Thank you both James and mlmcc for your contribution, James' final response has hit the nail right on the head and has certainly give me a positive start to the morning.  It seems the general theme with crystal in that people just learn as they go.  

I like it when I find something new within Crystal and your help has certainly done that, I think I'll be ordering me a new book real soon!

Thank you once again and if you gain any satisfaction in helping solve crystal problems then I hope your currently feeling that in abundance :-)

[embed=file 1129317]

Thanks, thanks, thanks!!!
Untitled.jpg

mlmcc should have gotten most of the points.  He gave you most of the solution in his second post.  I just added the part about resetting the count to 0 before the subreport, and pointed out one part of mlmcc's solution that you were missing.

 You can ask to have the question reopened, and then split the points between us.

 James

Sorry, the whole points thing is new to me although I agree in that mlmcc's initial response did indeed form most of the solution and can only apologize I didn't do exactly what you suggested.  I'll see if I can get the question re-opened and get the points split :-)  Just out of curiosity, what are the points for?

Many thanks James & mlmcc :-)

Points are relatively meaningless in reality.  They are the way we get "rewarded" for helping you with  a question.  Points get translated into a level number.  You can see the number under our Avatar.  The higher the number the more points we have earned.

To reopen the question click the REQUEST ATTENTIOIN link in the question body.  It is under to 3 dot menu

mlmcc

I guess the points can be used when you ask a question.  You get points for answering questions, which you can then use when asking questions of your own.  I think.  And, as I recall, if you earned more than X number of points per month, you could ask an unlimited number of questions or something like that.  I'm not really sure, since I never ask questions here.  :-)  And, even if I'm right, the site may not work like that anymore.  FWIW, the level number thing is a relatively recent addition.

 For me, it's mostly just about giving credit where it's due.  But another factor is thinking of the site as a resource.  If someone with a similar problem searches the site and finds this question, you'd want to have the correct posts marked as the solution.

 James

James - the Q&A part of experts exchange is now completely free.  There are some parts that require either a paid account or earning 10000 points per month.

mlmcc

Hi,

Does anyone know how to choose 2 posts as best solution?

mlmcc,

 Thanks.  I got the impression that things had changed, but wasn't sure.


 Andrew,

 I'm sure that I've seen it mentioned, but I can't remember the details.  mlmcc will know, and I'm sure that he'll give you an answer when he gets back to this question.  (I know that this isn't all that helpful, but I didn't want you to think that I was ignoring you :-)

 James

Is there anyway of distributing the points evenly if there were 2 solutions that contributed to the end result as that was the case.  I could assign the best points to mlmcc and assisted points to James but I'd rather share the points if thats possible ?

Many thanks,

AJ

When you select the comments the points will be split evenly among all the comments.  You can adjust if you feel one of the comments deserves more credit than another

mlmcc

Thank you everyone for your help, book ordered, experience gained and happy that I now have a Replenishment Report :-)  Thank you, thank you and thank you once again :-)

You're welcome.  Glad I could help.  And thanks for taking the time to reclose the question.  Not everyone does when something like that comes up.

 James