Reports can be based on sets?

[DaveM]

Re: Reports can be based on sets?

Just may be you have 3 blank records?
Better still, group the names like ahw pharmacy.
In other words, in a group your totals would be below each name brought up by the filter you rely on.
I will try and format it tomorrow for you( I think you included a sample above), but I just took a pain pill for the new hip and going to bed.

Not kidding, reports can be a bit hard for anybody.
I have one report with 4 sub reports, 2 groups in the main and several conditional objects. This report only shows one record (by filter). This is on a very complicated set with the client records as the main table & several 1 to many tables.

[JetLi]

Re: Reports can be based on sets?

Thanks Keith for reminding, i forgot, sorry bout that, Thanks also Dave, while waiting for your help, I'm trying to do it now,I hope I can get it right so that you won't waste your time on this simple matter about reports.

[Al Buchholz]

Re: Spaces on Sub-Report

I can now produce an output of the report, I again attached an output, my problem is that I can't remove the three spaces on the left subreport and the record should go up on the first line, May I kindly asked again some help on this, what should I do?

If you look at Stan's report, the subreport has a filter that uses the scanning() function.

That function filters out the 'blank' records that are showing because of the multiple one to many relationships in the set.

If you look at the browse image that I posted, you'll see the how the data is read by the report.

You don't have the scanning() in your filter.

Look deeper in the examples that are provided for you and post more than a picture (although that's a good start) when you ask a question.

[JetLi]

Re: Reports can be based on sets?

Thanks Al, What is scanning function, I have attached an image, is that the one?

[Al Buchholz]

Re: Reports can be based on sets?

Thanks Al, What is scanning function, I have attached an image, is that the one?

Open the subreport and look at the filter for the subreport.

Better yet, attach a copy of the latest example to a thread.

scanning.PNG

[Stan Mathews]

Re: Reports can be based on sets?

Thanks Al, What is scanning function, I have attached an image, is that the one?

When you add a subreport and specify a child table as the source for the sub report, as you have done, the filter should default to scanning().

[Keith Hubert]

Re: Reports can be based on sets?

Thanks Al and Stan,

Scanning() is a new one to add to my list of new things learned.

I never knew there was a default filter for Sub-Reports.

[Al Buchholz]

Re: Reports can be based on sets?

When you add a subreport and specify a child table as the source for the sub report, as you have done, the filter should default to scanning().

Absolutely true, until it is 'fixed' by the developer..

ergo, the request for an example - to read between the lines....

[JetLi]

Re: Reports can be based on sets?

Thanks to everyone who tried to help, I appreciate it so much, and more thanks that you were able to help me. No more spaces.

[Al Buchholz]

Re: Reports can be based on sets?

Thanks Al, I found out that the scanning function you suggested is automatically coded once you filter on the object properties of the subreport, the image that I posted was the source of the scanning function, I was wondering why there are still blank spaces.

I'm not guessing, but I will look at an example.

[SNusa]

Re: Reports can be based on sets?

When you add a subreport and specify a child table as the source for the sub report, as you have done, the filter should default to scanning().

Forgive me for "jumping in here" but how would/could one code to use the function scanning() within X-basic code, as depicted in the wiki as a "function" and not as a "filter?"

SCANNING() returns .T. (TRUE) if the current composite record buffer includes data from Table_Name ; otherwise, it returns .F. (FALSE).

To determine if a there is a matching customer for a particular invoice record, use the expression:
scanning("CUSTOMER") -> .F. (FALSE) for invoice records I103 and I105

I'm guessing that you could add the code: vl_RecordExists = scanning("ChildTable_Name") on a "filtered set displayed on a layout, or possibly when looping through individual records in a set? (I wish they had provided a more complete & meaningful code example in the wiki.)

....And then one true/false value gets returned which is based on all the filtered parent records as a whole?

[JetLi]

Re: Reports can be based on sets?

I'm not guessing, but I will look at an example.

Al, I edited that post, It is working Fine now.Thanks!

[Al Buchholz]

Re: Reports can be based on sets?

Great

Please explain the solution so the next reader can learn from this...

It's one of the things that makes this board valuable.

[JetLi]

Re: Reports can be based on sets?

The solution is on the sample that Stan shared, It's just that I made the wrong choice of table when i set the filter, I thought I would point to the main table, So, what I did was, on the subreport filter option,I set it to the first child table then the second subreport is pointed or set at the second child table.Thank you so much for all your help.

[Al Buchholz]

Re: Reports can be based on sets?

The solution is on the sample that Stan shared, It's just that I made the wrong choice of table when i set the filter, I thought I would point to the main table, So, what I did was, on the subreport filter option,I set it to the first child table then the second subreport is pointed or set at the second child table.Thank you so much for all your help.

Thanks for the follow up so others can learn from this.