Jump to content
  • 0

select count in a report with search filtering




As counting groups does not work I'm thinking to use select count instead.

Any ideea how to ?


Parent table: ID_parent, field1, filed2 ...

Relation one to many  with

Child table: ID_child, field1, field2 ..., ID_parent

Need to use a report for the child where I filter by search the field1 first then I need to count how many groups ID_parent there are for the same field1 in child and group them descending.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

I dont have a direct solution for this but I found a workaround if you are trying to achieve the same output as mine.

This is what I have:

Since I cannot enable data grouping for the ParentID when it is already used for the aggregation and I cannot create a virtual field in tabular reports, I made an addition field in my table and made it a Formula data type. That way I can insert the value of the ParentID to the formula field and use that field in the aggregation instead. Afterwards, I enabled data grouping for the ParentID field and it was automatically ordered by descending the total number of records with the same ParentID field.

This will create an extra field on the table though but if you dont mind it then I think it a good workaround for now.

If anyone has a better solution for this kindly share it with us.  


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...