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

  • I need some direction on getting ReportBuilder to work with NexusDB.

    When I build and try to install the package rbNexusDB10105.dpk found in the
    EndUser Databases folder, I get an access violation. When I build and try
    to ins…
  • From my experience with NexusDB and RB, you need to change the SQL type to
    SQL2 to get the Left Outer Join to be inserted into the SQL code. SQL1 does
    only inner joins.

  • Excellent Nard, thank you.

    Jason.

  • Realising that TdaDataViewToolWin is simply a TForm, I changed my code to
    read:

    TmyDataViewToolWin = class(TdaDataViewToolWin);

    and then removed all of the properties, methods & events of the class so at
    least I s…
  • wrong button :-) i use delphi 7 as well. now it comes up with:

    [Error] Unit1.pas(63): PROCEDURE or FUNCTION expected
    [Error] Unit1.pas(66): ',' or ':' expected but 'CLASS' found
    [Error] Unit1.pas(70): ',' or ':' expected but '='…
  • thank you! i look at it. it doesnt compile and says the ressource file was
    corrupted

  • >

    The user specifies them after program start and then selects a report
    template he wants
    to use with this data. The idea is that the user not necessarily has to work
    with sql
    queries and that we ship some standar…
  • Maybe it is not a good idea to edit & parse the whole SQL string but
    use SQLBuilder to add some filters instead. How would this look like
    in my example below ? Currently I cannot apply my programmatical
    changes to the data view.
  • Yes the record is completly committed in the database. I open the report
    through the program by calling "Report.Print".


  • Thank you for your response.
    I tried gMetaDataManager.Clear but it didn't work. Not sure whether I am
    using it right or not. It seems like I can't re run the same query to
    refresh my data.
    The report is created in Delphi IDE. …
  • Hi Nico,
    I certain my initial field not contain then spaces at the end. If I use
    a Variable component with the following Calculation "Value :=
    xxx['fieldname1'] + ', ' + xxx['fieldname2']" do not have this problem.
    If I use a …
  • Nard,

    I keep trying, and I'm almost close to success.

    I see ExtractSQLObject example, I apply again to my project. It works only
    with reports that have just one TdsSQL

    like/.... object daSQL1: TdaSQL
  • It's rare. will try attach here.

    As you told me, here is a small application that recreates the problem I
    have.

    What you have to do is follow whis steps.

    1 Build Application (sure..)
    2 Run it. A form 1 wi…
  • Dear Nard,

    I send you the zip with a very small example. Please let me know if you
    receive it and if you can take a look.
    Maybe with a simple function call it can be solved, but you know RB inside
    much better than me.
  • Dear Nard,

    I begin again from scratch. No lucky. Now I have a small recreation of
    this situation. If you would kindly take a look maybe you can help me.
    Can I send the project to any email ?

    thank you in advance.<…
  • Dear Nard,

    Everything you say is true, I forgot to mention. Each usersession have it's
    own Data module (DM is created at runtime for each session). This
    Datamodule have it's own ADSConnection, Tables and just one Report obje…
  • Hi Nico,

    Did you receive my email yesterday?

    Samuel
  • Hi Nico,

    I tried with EndUser and the problem was another.

    I saved the report in my application (.RTM) and imported in EndUser.
    After this, when I run the report his works fine.

    If I leave the EndUser, load it …
  • Thank you Nard, I will give it a try.

    regards

    Steve

    in Login Prompt Comment by rbuser July 2008
  • Hi Nico,
    I am not sure if this is what you meant, but i have already tried (as a
    test) the code below to hard code the database name into all of the queries.

    aSQL := nil;
    {get the datamodule}
    lDataModule := …
    in Login Prompt Comment by rbuser July 2008
  • Hi Nico,
    The Database is Pervasive SQL, Using ODBC.

    I have a form with a VCL ppReport on/ form also contains a TDatabase
    component with LoginPrompt=FALSE.

    I am NOT using any Pipeline components.

    ------…
    in Login Prompt Comment by rbuser June 2008
  • Forgot to mention, ReportBuilder 9.03/Delphi 7


    in Login Prompt Comment by rbuser June 2008
  • Hello Nard

    I've been using my own custom DataDictionaryBuilder for years to get around
    this problem, but yes, I guess it would make sense for you to add this
    facility to the standard one (its only a few lines of code). But th…
  • Hi,

    Thank you for your fast response.


    I know how to manipulate about anything through my app's code, this is not
    the issue here. I want the users of my app to be able to use a TeeChart
    component through the "…
    in TeeChart Comment by rbuser August 2008
  • > I don't know if I'm postiong in the right newsgroup. If I'm not please

    Propbably the RAP group would be best.


    I would create a pass through function to do that.

    Ed Dressel
    Team DM
    in TeeChart Comment by rbuser August 2008
  • Thank's I saw the example and I found the problem, in my project didn't have
    in any unit in clauses "uses" the unit daAdo, when I add this unit worked


    in AdoSession Comment by rbuser August 2008
  • I'm sorry for name 'j', I didn't see this before and I'm sorry for my
    english too I'm brazilian and I'm learning english now

    My delphi is 2007 and Report Builder is 10.0.9 I'm using the databse MySql.
    When I saw that the tab d…
    in AdoSession Comment by rbuser August 2008
  • >Did you include that feature meanwhile or is it still necessary to

    Well, what I need to accomplish is that I have to skip those entries which
    are zero inside a group.
    I have a group containing 6 entries of which 4 are 0, so …
  • Hi Nico,

    thanks for the quick response.


    The problem with the manual editing is that we're using the "search
    dialogue" option to pass a value to the report which doesn't work any more
    after manually editing the r…