Item code sub report not generating

[Former Member]

Hi,

I would like to seek help for the reason why the subreport did not generate.

Thank you for your usual support.

Thanks.

Flor Tan

[abhilash_kumar · Accepted solution]

Hi Florencio,

What section is the subreport on?

Could you attach a screenshot of the design page as well?

-Abhilash

[Former Member · Accepted solution]

Dear Sir Abhilash,

Here is the screen shot of the design page

thanks.

[abhilash_kumar · Accepted solution]

OK. So, you're saying each Detail Row should have a Subreport that prints more details about the ItemCode?

If yes, then here's what you need to do:

1) Insert a Details b section

2) Move the Subreport from the Group Footer to Details b

-Abhilash

[Former Member · Accepted solution]

Sir Abhilash,

Thank you for very much, I am lucky that both you and sir Niraj is online.

Anyway, your suggestion hits the target.

Thank you, thank you, thank you.

Flor Tan

[Former Member · Accepted solution]

Glad we could help you. Please close the thread if you have satisfactory answer.

Regards

Niraj

[Former Member]

Hi,

Few questions:

Do we have linked the sub report correctly?

Is there any conditional suppression on SubReport?

Is there any conditional suppression on Detail section where you are displaying sub report?

Also inside the sub report do we have conditional suppression where you are printing details?

Regards

Niraj

[Former Member]

Dear Sir Niraj,

I did not use any Suppression on main and sub report.

Thanks.

Flor Tan

[Former Member]

Hi,

Thanks for the screen shot by looking at that Could you please make sure that the Joins that are getting created on the Record Selection of the Sub Report does qualify for the data to come in Sub report.

Like {?Pm-INV1.DocEntry}={IBT1_LINK.BaseEntry} and other joins that are coming to the picture in the record selection of the Sub Report.

Regards

Niraj

[Former Member]

Sir Niraj,

Thank you very much for your immediate response.  I have made sure that the Joins were in the right place and correct.

Once again thank you very much.

[Former Member]

Hi,

Great then!! probably per your Data model looks like what Abhilash suggested in moving your Sub report to Detail section instead of Group Footer should work. Because if you insert that in Group Footer the last Item that it has scanned from database its going to pass that to Sub Report and probably that might not have relevant data.

Hope I was able to explain.

Regards

Niraj

[Former Member]

Sir Niraj,

So that is why, hehehe

Thank you for the explanation.  I should start editing my other report right now.

So glad to have guys.

Once again... Thanks to both of you.

Flor Tan