Dinamic Report: Differents Details bands

I want to create a report that change it's detail band at runtime because there is a field value that indicates it (in the detail table).

I now that i can create the Treport with n detail bands and to turn visible property of bands on or off depending on which one you want.

But this is not a efficient method because, I must to create about 20 details bands in a report.

I think the best solutions it's the next idea:

- To Create a "Master Report" (Report title, masterheader, masterdata, detailheader, detailband) Detailband Empty.

- To Create n (20) "Details Reports" that containt a only detailband with all the objects/fields need it.

Then when I execute the "Master Report", at runtime, I must "load" the "detail report" that a need and that indicates the database field value to me.

But I don't know how can i do it????

Any approach, any clue, Help me, Please!!!!






Comments

  • edited 11:03AM
    Sorry for my English, I d'ont know if I'm explain myself well.

    In summary:

    - Can I create a detail band (at runtime) reading other detail band in other .frf file?
    - And How?
    - or another style to do it?

    Please, I need help for some expert in Fast-Report.

    TIA.

    S.Barco
  • gordkgordk St.Catherines On. Canada.
    edited 11:03AM
    Hi
    I am not sure of an efficient method to do this and i need some extra info
    What is causing the need for so many different detail bands?
    Are the different detail bands using different frdbdatasets or just different fields from the same dataset?
    once the detail is changed does it last for the life of the report?
    regards ;)
  • edited 11:03AM
    Thanks for your response Mr. Gordk

    <span style='color:blue'>>What is causing the need for so many different detail bands?</span>

    it is the necessity, (on the part of the client) of being able to see the details of different styles.

    <span style='color:blue'>>Are the different detail bands using different frdbdatasets or just different fields from the same dataset?</span>

    The detail bands are using the same frdbdataset and some times the same fields and some times diferents fields.

    Really a need to report a classic Master/Details tables, but the exceptional thing, is that the details can be printed in different format.

    <span style='color:blue'>>once the detail is changed does it last for the life of the report?</span>

    No. I need to control that for every detail record it's possible to change detail band.
    For example in a report:
    It start with 3 records with the detail band format 1,
    continue with 2 records with the detail band format 2,
    continue with 3 records with the detail band format 1,
    continue with 1 records with the detail band format 15, ...

    For a report is impossible that it has the same format of details that another one.

    Thanks Mr. Gordk

  • gordkgordk St.Catherines On. Canada.
    edited 11:03AM
    It may be possible but it will be very trickey
    assume a detailband set to virtual 1 record containing a number of subreports which have visible property turned off and contol on by value of a variable.
    but the value for the variable would have to be stored with the master data record
    the problem lies in knowing how many detail records to include with each format for a given master record.
    if you can send me some sample data and a sample report in a zip file and i'll take a look.
    regards ;)
  • edited 11:03AM
    Hello, Mr. Gordk and thanks for your help again.

    Sorry, but I d'ont have any prototipe/example report because really I want to know if it's possible "to load" a "report piece" at runtime in a "main" report.

    I will explain in summary my idea and the data base estructure:

    Details Reports Table
    -Id Report
    -Description
    -Report (blob) -> here I want to save a "FR detail report"

    Questions Table
    - Id Question
    - Description
    - others fields .....
    - Id Report --> here I say the format to print

    Here, there are the 2 tables master/detail of which I want to create the report:

    Master Table (Hospital Analitical)
    - Id Master (Analitical Number)
    - Patient Name
    - Age
    - others fields .....

    Detail Table- Id Detail
    - Id Master
    - Id Question
    - Answer
    - Others fields ....

    If you observe the detail table, you will see the "Id question" field that as well point to the "Id Report" --> here it's my problem ??How can I "load" this detail report in the main report master/detail at runtime?

    Thanks again Mr Gordk

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.