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

rbuser

About

Username
rbuser
Joined
Visits
1
Last Active
Roles
Member

Comments

  • Thanks Jim,

    Create dataview, exit, use dataview in report, view report - fine. Go
    back to dataview and preview - get error. Paste magic (or regular)
    SQL into a TOEQuery and all is fine.

    Yes I thought it should behav…
  • Dear Jim,
    thank-you, thank-you, thank-you.

    I strongly recommend you update your help files/user documents for the Pro
    version to detail how to do this. It is extremely powerful yet I could find
    no reference to it.…
  • Dear Jim,
    my mail clearly says I have bought the Pro version. I bought it to
    allow users to do end reporting. In the list of features for the pro version
    it talks about user-settable runtime parameters, this is what I need to …
  • Thank you very much, Jim. That works great.

  • Everything happens at runtime. I change(at runtime) JITPipeline fields. (in
    Template.OnLoadEnd or OnNew event. First - JITPipeline.FreeFields; then
    several times: DefineField(...)) After that report is loaded and for the
    fields to be …
  • Jim Bennett (Digital Metaphors) wrote:

    Jim:

    Thanks for the information. (Sorry if I used the wrong word,"strange."
    :)…            </div>
            <div class= in Strange "WHERE 'c' <> 'c'" Comment by rbuser June 2003
  • Thanks,
    I'd tried that a few times on the caption of the dataview, but hadn't tried
    doing it on a field name.
    Cheers,
    Andrew

  • Hi Andrew,

    you can use the right-mouse-click menu, which offers 'Delete'.

    HTH,
    Chris Ueberall;
  • Hi Jim,


    the server wasn't available for hours, now all looks fine.

    Cheers,
    Chris Ueberall;
  • Link is not working...

    B.

  • What I liked to have with AutoSearchFields:

    - Set the description in the designer at report-designtime
    - have the ability to set a tag ( I would like to use the tag to create
    special autosearchfields; Tag = 100 --> use a pick…
  • Jim,

    I know that creating a custom autosearch dialog it is possible to solve part
    of the wishes I have.
    I wanted to look at the possibility to have that features included in the
    standard end-user environment.
    Any possi…
  • Thanks for Report.Modified.
    But do you have any examples or tutorials concerning saving within
    OnCustomSaveDoc matter? I don't quite understand what do you mean by
    controlling saving process. Will I just have to override several metho…
  • Oh, Thank you very much. It really was because of my newsreader settings. I
    just reset those newsroups and everything is back.

  • Hi Bhoj,


    better use always method 'Free'.

    regards,
    Chris Ueberall;
  • Never mind I got it

    for i := 0 to fReport.GroupCount-1 do begin

    FReport.Groups[i].Destroy;

    end;

    its going to take care of it.

    Thanks

    -Bhoj



  • Thanks Jim,

    Yes , I am loading the report from the Database.But those values were not
    part of Template anyway.I saved those values in the my table when they do
    the SavetoDatabase and load them from there and at the time of load …
  • Opps!!! yes, I mean except Orientation how do I set other properties.
    fOrientation: TPrinterOrientation; // get it from PrinterObject
    fLayout: TppReportLayoutType;
    f Style: TppReportStyleType;
    fReportStyle: TppRe…
  • Thanks Jim I did think that I couldn't do it as an end user out of the
    box. I will look at your coding solution.

    Thanks for the help.

    Cheers,

  • Hi, Jim!

    I have RBuilder Pro 7.02 and Delphi 7 Pro.

    I know I can see the SQL Object and the MagicSQL text, and it works with one
    of the references tables, but not with other.

    I have sent you an e-Mail with an ex…
  • Hi, Jim!

    I think I have found the problem!

    If the template slq references to 2 tables (for example, "customers" and
    "orders"), I only can create search criterias for the first one!

    For example, if I call:
    <…
  • It is not working. Seems like Report.Modified property is always = false in
    my case.
    But, thanks to the example, I can see a workaround now. It is to use
    OnCloseQuery event and global variables.
    Thanks for the help.

  • Dear Jim,
    thanks, FirstName + ' ' + LastName worked once I had re-set the
    fieldname.

    Now I have a similar problem. I want the difference between two dates in
    number of days.

    The expression I have got is
  • Jim,

    Indeed, I created my own AutoSearchDialog with all the stuff I need. It is
    not generate panels for each autosearch parameter, but I have different
    forms for different reports. We only needed to create some forms to run al…
  • After some testing I concluded that Custom Information can be saved to files
    ONLY. For database I need to use database fields.
    But. WHY CAN'T I USE THIS METHOD WITH DATABASES AS WELL???
    It is the only solution that can be applied for …
  • Oh, I found the cause, but the reason still eludes me.
    The cause is the following: At the Template field in the database only my
    custom information is saved.
    So when it tries to load the report this exception is raised.
    The quest…

  • Ok, thanks.

    I'm just trying to make my life simpler as my todo list is growing
    faster than the work being done.

    Michel


  • Hi Jim,

    I understand this is a workaround, but all I want is to have the
    OnCancel event work. I don't need to create a custom preview.

    All I added in TppReport.Cancel is,

    if Assigned(TNotifyEvent(OnCan…

  • Hi,

    Maybe this will help find the problem.

    When the Cancel button is pressed on the Preview here is the sequence of
    calls:

    TppPreview.ToolButtonClickEvent
    TppCustomPreview.PerformPreviewAction
    T…

  • Hi Jim,

    I have advanced quite a bit now...

    I am running my query in another thread to that it maybe cancelled.
    Although I am fighting with some ODBC drivers which don't want to cancel
    a query, this is working …