Home nicocizik Comments
New Blog Posts: Merging Reports - Part 1 and Part 2

nicocizik

About

Username
nicocizik
Joined
Visits
2,424
Last Active
Roles
Administrator
Company Name
Digital Metaphors Corporation

Comments

  • Hi Chantal,

    You can use the TppReport.OnSaveText event to gain direct access to the
    string being exported. The "Text" parameter is the string to modify.
    Something like the following will add a ";" delimeter and break to the n…
  • Hi Chantal,

    One option would be set the TextFileType option to ftCustom, then use the
    OnSave event to add your own formatting to each value. You would for
    instance simply add a ";" character for each value until you export th…
  • Hi Veri,

    Are the regions set to Stretch? If you take the subreports out of the
    regions are they still not visible? Try simplifying the report so that you
    only have the three subreport objects in the detail band and see if yo…
  • Hi Veri,

    In my testing, placing three section subreports in a main report and setting
    the copies to different values prints the correct amount of copies for each
    subreport if the NewPrintJob is set to True and ParentPrinterSet…
  • Hi Veri,

    I'm a bit unclear about what you are trying to accomplish. The code you
    have below simply sets the child report's printer to the printer of the main
    report. What exactly is happening in this case that is incorrect?<…
  • Hi Paul,

    This is what I had in mind...

    The main report only has a detail band with two section subreports inside.
    The first section subreport is not connected to any data and contains a
    header band (containing all t…
  • Hi Paul,

    One option would be to remove the header from the main report and move its
    contents to the header of the first section subreport (mentioned in the
    previous post). Otherwise, you might try placing the child subreport …
  • Hi Penny,

    Take a look at the demo located in the \RBuilder\Demos\3. EndUser\5. Dynamic
    Subreport Loading\... directory for an example of loading subreports at
    runtime.

    --
    Regards,

    Nico Cizik
    Di…
  • Hi Chantal,

    Excellent! Glad you got it working.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

  • Hi Chantal,

    One thing you might try is manually link your datasets. You just need to
    make sure that the detail querys are sorted by the linking field(s). And
    make sure you link the datapipeline in the Report.OnInitializeParam…
  • Hi Chantal,

    DADE is the Data tab in the report designer or the data workspace where
    queries can be created from within RB. By Master/Detail reports, I'm
    referring to linking separate datasets using DataPipeline linking. (See…
  • Hi Chantal,

    Sorry for the confusion, I don't fully understand which dataset the
    subreport(s) are connected to. Are you linking separate datasets in DADE or
    are you joining the tables into a single dataset? Have you considere…
  • Hi Sheldon,

    Are these subreports connected to the same datasource (datapipeline)? If
    so, you may want to create a separate datasource for each report, each with
    their own query sorting the data as they should.

    -- <…
  • Hi Sheldon,

    Once you have two section subreports in the main report, you will treat each
    subreport as a separate report. If you are creating these reports from
    scratch, simply tab over to each subreport's design and begin cre…
  • Hi Richard,

    Are you using RAP? If so, please post to the RAP newsgroup. This helps us
    determine what you are trying to accomplish and allows us to give a more
    accurate and quick answer.

    If you are using RAP, you c…
  • Yes, it is now necessary to set the DataType of any numerical (calculating)
    variables to something other than String. String variables are timed
    differently to handle String specific cases (truncation, caching, etc.).

    --
  • Hi Rodger,

    There should be nothing wrong with calculating this way however it is a bit
    concerning that the OnCalc for the TppVariables is not functioning
    correctly. When you were using variables, what datatype did you have th…
  • Hi Rodger,

    Which version of ReportBuilder are you using? How does this report differ
    from the reports that function correctly?

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    in Problem getting correct total Comment by nicocizik February 2008
  • Hi Richard,

    ---------------------------------------------------------------
    Tech Tip: Controlling the Print Order of SubReports
    ---------------------------------------------------------------

    When subreports are in th…
  • Hi Veri,

    The fact that you are able to print to other printers successfully and not
    this specific printer leads me to believe that this is a printer or printer
    driver issue. Are you able to print to this printer from a local …
  • Hi Veri,

    This is not a known issue. Is this a network printer? Are you sure you
    have complete access to the printer driver? What has changed since you had
    everything working before?

    --
    Regards,

    N…
  • Hi Richard,

    The problem is the timing in which the DBCalc calculates its value and when
    you assign the variable value. The DBCalc does not always calculate its
    final value in the OnCalc event. In your case, I would recommend…
  • Hi Edmund,

    ReportBuilder retrieves data as-is from the dataset it is connected to. If
    you would like to change the order in which data is displayed in a report,
    you will need to create a SQL query that defines what order you …
  • Hi Stef,

    Which version of ReportBuilder are you using? In my testing with RB 10.07,
    the SpreadSheetStyle example worked as expected. If there is not data for
    the second subreport, it would be possible to simply toggle the vi…
  • Hi Stef,

    The best way to print a report wider than a page is to use subreports
    similar to the SpreadSheet Style example...

    http://www.dig…
  • Hi Richard,

    For future reference, please send all attachments to
    support@digital-metaphors.com.

    ReportBuilder traverses the data as it is given when generating a report. If
    you connect the same dataset to a subrepor…
  • Hi Luke,

    Based on what each subreport node is named, you can use the
    TppOutlineNode.ParentNode property to determine which subreport is printing.
    Something like the following...

    uses
    ppTypes,
    ppOutlineNode…
  • Hi Chantal,

    I'm sorry, I had thought this issue was resolved. In my testing, placing a
    crosstab inside a subreport with a dataset linked on a text field seems to
    work correctly. If possible please send me a small example I c…
  • Hi Chantal,

    Sorry, I'm a bit confused about the issue. Does this relate to the same
    issue you were having with crosstabs?

    There should be no problem with linking datasets on text fields. Be sure
    both datasets are …
  • Hi Chantal,

    Excellent, I'm glad you got it working!

    Yes, not knowing the complexity of your initial report(s), I may have led
    you in the wrong direction telling you to place the crosstabs in their own
    subreports. A…