Order Form Style Report...Almost

tampasoundstampasounds US
edited 9:01AM in FastReport 4.0
Hi I am new guy to forum

I made a order form and it works great with only 1 row of data
Nice Looking Report with only 1 row of data in MasterData

But...
When have 2 row of data in MasterData the form breaks and I know i did something wrong with bands or technique
Nice report get broken with 2 row of data in Masterdata

Here is a look at my designer
My designer layout


Can somebody tell me what i did wrong and how to fix?

Many Thanks in advance for any advice on how to do properly with FastReport 4 Ent





Comments

  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    IMHO
    basic design, this type of form layout does not work with grouping from a single query.


  • tampasoundstampasounds US
    edited October 2009
    gordk wrote: »
    IMHO
    basic design, this type of form layout does not work with grouping from a single query.

    Ok, thanks .....

    Can anyone please explain the right way?
  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    you should probably be master/detail.
    what is the group header grouping condition?
    do you want the comments alwas at bottom of page?
    too many things cant be seen in jpgs
    post a copy of your .fr3 file in the binaries newsgroup and ill take a look.
  • tampasoundstampasounds US
    edited October 2009
    My FR3 is posted to the binaries

    I am trying to get same effect and result as posted here
    http://www.fast-report.com/en/forum/index....&hl=invoice

    He has nicely gotten empty space to fill with vertical line (stretch)(empty row) not sure of technique
    and has right idea about totals )
  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    the first things to make decisions on which bands to use
    1 are we trying to create a copy of a paper form that was used?
    2 what elements will appear on every page produced?
    ie page header, page footer
    do the page footer firs it is a fixed place in a report when used it can't stretch only hidden.
    i expect you want to place your sysmemo1 and memo58 in a page footer and some of the items in the group header should go to a page header if you want them on every page.
    ie logo, purchaser, info.
    answer these and ill try to help you some more.
    Master/detail in refrence to bands is just a place holder on a page trans late that to data of level 1 data of level2 etc. the number of times a band repeats depends upon the dataset or row count(fixed) master detail data relationships are handled at the data level and if you have indexed your tables/queries you can connect in many different ways.
  • tampasoundstampasounds US
    edited 9:01AM
    gordk wrote: »
    the first things to make decisions on which bands to use
    1 are we trying to create a copy of a paper form that was used?
    2 what elements will appear on every page produced?
    ie page header, page footer
    do the page footer firs it is a fixed place in a report when used it can't stretch only hidden.
    i expect you want to place your sysmemo1 and memo58 in a page footer and some of the items in the group header should go to a page header if you want them on every page.
    ie logo, purchaser, info.
    answer these and ill try to help you some more.
    Master/detail in refrence to bands is just a place holder on a page trans late that to data of level 1 data of level2 etc. the number of times a band repeats depends upon the dataset or row count(fixed) master detail data relationships are handled at the data level and if you have indexed your tables/queries you can connect in many different ways.

    1. Yes
    2. Everything except comments and totals need to be on every page.
    3. Comments and Totals on Last Page only (report summary I assume)
    4 Page footer has Page 1 of Total# Pages on every page

    I went and tried to move some things around as you suggested but still struggle
    with the concept of masterdata and filling the available empty space. i tried to set amount of rows
    but that seems to have no effect

    Many thanks again as I await your response

  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    the row count is static only and only applies when a data band is not connected to a datasource(which controls the number of times the band is reapeated).
    typically filling space between databand and its footer is accomplished using an unattached childband which has duplicate empty memos and writing code in obp of next band to call the engine.showband(bandname)method;
    can you post some sample data in the binaries?


  • tampasoundstampasounds US
    edited 9:01AM
    Sample data uploaded (replied to original fr3 upload)

    Many thanks

  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    Larry you will have to zip the data file OE blocks mdb s.
  • tampasoundstampasounds US
    edited 9:01AM
    gordk wrote: »
    Larry you will have to zip the data file OE blocks mdb s.

    ok, zip uploaded
  • tampasoundstampasounds US
    edited October 2009
    gordk wrote: »
    the row count is static only and only applies when a data band is not connected to a datasource(which controls the number of times the band is reapeated).
    typically filling space between databand and its footer is accomplished using an unattached childband which has duplicate empty memos and writing code in obp of next band to call the engine.showband(bandname)method;


    This statement helps alot.
    I reconfigured the report to as follows and have made some progress

    PageHeader (for logo and top level order info needed on each page) (also holding column headers there)
    MatsteData (for the orders items)
    Child (for empty memos to fill my space)
    Added code in obp footer as descibed above
    Footer (set to 0 height)
    PageFooter (for comments and terms) totals are there too which is really only thing i need to hide until last page.



    So only few questions left...
    The results are better but is this proper way ? I still have to find a away to make totals only on last page


    I am adding new fr3 to binaries

    A million thanks again for taking the time to help

  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    will take a look later today and get back to you
    BTW you can email me directly gord@fast-report.com
  • tampasoundstampasounds US
    edited 9:01AM
    gordk wrote: »
    will take a look later today and get back to you
    BTW you can email me directly gord@fast-report.com


    Thanks
  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    I added a little demo report to the binaries
    gord
  • tampasoundstampasounds US
    edited November 2009
    I am unable to open the demo fr3 you made. (it gives errors)

    After looking at my latest fr3, can you tell me how to make the totals
    appear on last page only after using child band as filler ?

    My problem is same is this guys
    http://www.fast-report.com/en/forum/index....&hl=invoice


    Thanks again


    PS
    Is it possible to add a simple invoice sample with these requirements to the Main Demo?
    After spend several weeks searching for answers on this forum, I see same problem over and over
    again but no clear answer. Why is this left a mystery ? Maybe it will help cut down on your support to offer it .... >
  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    what errors
  • tampasoundstampasounds US
    edited 9:01AM
    gordk wrote: »
    what errors

    Its giving Jet error. I can only see the report in the designer
  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    of course the ado connection must be reset to your database they were pointing to an ado connection on my form which connected to the db you sent me.
    page 1 is using tables in a md relation, page 2 is using 2 queries in a md relationship
    the one you keep refering to is wrong, grouping does not work well with these types of layouts.
    as the grouping controls the positioning and you can get unpredictable results due to data supplied(bad queries)
    no matter how many demos are given, you have to grasp the concepts in the one's that are presented, they cover about 99% of situations, after that it is up do the user/designer to decide what to use and how to use those concepts.
  • gordkgordk St.Catherines On. Canada.
    edited 9:01AM
    move those memos into the footer.
    tip for designing go to mnu/file/pageoptions other options and set large height indesign mode.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024