Recent

Author Topic: Determining when a break occurs  (Read 3507 times)

jack

  • Full Member
  • ***
  • Posts: 107
Determining when a break occurs
« on: March 03, 2012, 11:20:56 pm »
I have setup a simple master detail report.
Attached are screen shots of the the query used with resultant dataset, the report setup in the designer and the output.
I do not know how to tell the designer to repeat detail lines until the employee name changes .  the employee name is the only field in the master data band. The Detail Data Band is inside the master data band.
Do I put something in the Group Condition Property?
Do I put something in the Script?
If so what would it look like?

Please help, I have been messing about with this for two days and I am struggling!
« Last Edit: March 03, 2012, 11:59:11 pm by jack »

jack

  • Full Member
  • ***
  • Posts: 107
Re: Determining when a break occurs
« Reply #1 on: March 16, 2012, 06:17:24 am »
As rapidly as this community responds to most questions i am not sure why no one has responded here.

I don't know if the question is too hard or too silly to answer?

I have gone ahead and hard coded the reports that I need, I would have preferred to figure out this tool.

If you have any thoughts please post them please.  There will be a next project.

jesusr

  • Sr. Member
  • ****
  • Posts: 470
Re: Determining when a break occurs
« Reply #2 on: March 20, 2012, 10:45:17 pm »
for Master/Detail report you need to setup the datasets in master detail  configuration, a dataset bound to master table, detail dataset bound to detail dataset. Then link Master Data band to Master Dataset and Detail band to Detail dataset. Then everything should be automatic.

In LazReport/Samples/Editor there is an example of master/detail report, see Master-Detail test button.

But... as it seems you don't have two tables, the ideal report for your data is a "grouped report", drop a group header band and set the group criteria to EMP_NAME field, then drop a master band and put the other fields here, that should do it.

Also in Samples/Editor there is a grouped report sample, to run it, first select Index "BYCOUNTRY" from the index combo box, then open report "albumsbycountry.lrf" located in samples/editor directory, then press preview button. You can edit report to see the design, etc.

jack

  • Full Member
  • ***
  • Posts: 107
Re: Determining when a break occurs
« Reply #3 on: April 20, 2012, 05:33:22 am »
Thanks for this guidance, I will report when I get this done.