Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

Quickreport and grouping

I'm working with database table where is for example workers number, name, main contractors number and contact person, subcontractors number and contact person, our contact person etc.

I need report where data is grouped in 4 levels by:
     Our contact person
          Main contractor and contact person
               Subcontractor and contact person
                    Workers data

Can I do this so that data is in one database component or shall I need many components?

I get this almost work with 4 query components but if our contact person have many main contractors, only first one is printed on report and also if main contractor have many subcontractors, only one is printed.

0
jatalven
Asked:
jatalven
  • 4
  • 3
1 Solution
 
kretzschmarCommented:
set the groupbands in your desired order with the expressions you need,
use one query, which collects the data you need, ensure there,
that the query order by clause matches your grouping-scheme

meikl ;-)
0
 
jatalvenAuthor Commented:
Hmms, now I have one query where is all the data.

Put I 4 group bands or how?

Expressions is also what I don't understand.
0
 
kretzschmarCommented:
>Put I 4 group bands or how?

yes, four groupbands, or three, if there are no additional details
(Workers data could be a detail)

     Our contact person
          Main contractor and contact person
               Subcontractor and contact person
                    Workers data  <-- Detail?

or

     Our contact person
          Main contractor and contact person
               Subcontractor and contact person
                    Workers data
                         DetailData

>Expressions is also what I don't understand.

Expressions -> means groupExpression -> usually the field on which should be grouped
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
jatalvenAuthor Commented:
Alright!

>>Put I 4 group bands or how?
>
>yes, four groupbands, or three, if there are no additional details
>(Workers data could be a detail)
>
>     Our contact person
>          Main contractor and contact person
>               Subcontractor and contact person
>                    Workers data  <-- Detail?

Now everything else is printed rigth but all columns are printed under our first contact person.
0
 
kretzschmarCommented:
hmm,

a layout

+-------- Groupband1 - GroupExpression = Dataset.ContactPerson -
| [Field] [Field] ....
+-------- Groupband2 - GroupExpression = Dataset.MainContractor -
| [Field] [Field] ....
+-------- Groupband3 - GroupExpression = Dataset.SubContractor -
| [Field] [Field] ....
+-------- DetailBand - ---------------------------------------------------
| [Field] [Field] ....

>but all columns are printed under our first contact person.
did you sort your query properly?

meikl ;-)


0
 
jatalvenAuthor Commented:
Phiuh!

Oops, to contact person has forgotten wrong dataset. My fault =)

Now it's working just right, just before I begin to modify it but now report is printed in ten seconds, before it takes abaut 15 minutes.

Thanks a lot!!!
0
 
kretzschmarCommented:
glad you got it sorted :-))

good luck again

meikl ;-)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now