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


  • Hi Nelson

    You've blown the Windows98 resource name table limit for a single Windows
    "module". I think there's a thread on it somewhere else in these
    newsgroups. Basically you will need to break you application up somehow…
  • The second one looks to be the ticket for me. The part I hadn't
    twigged to was the "ContainsSubSelect" property that allows the
    "inlist" criteria to pass through the subselect clause.

    I will try it out. Many thanks.

  • Has there been any movement on this issue?

    I have a very similar situation where I need to add a where clause at
    report preview/print time. The clause is provided to me in text form
    and may contain sub selects with an "in" clau…
  • Why ReportBuilder does not offer this function ?
    Many reports designers offer the possibility to change the SQL command
    without problem.
    Is it so hard ?




  • Sorry, my question was not clear.


    I have 30 dynamic views of datas in my application.
    Each view is dynamicly created at runtime.

    I use strings to store each line of my QueryView.SQL property.

    Txt_SQL := 's…
  • Hi Jim,

    If it's of any help to you or Jason Sweby, we had overridden
    GetSearchCriteriaDateFormat in version 6, to make the dates work (UK) by
    setting the result to 'dd/mm/yyyy', but in version 7 you've hard coded the
    conver…
  • Jim,

    I tried the following query to an SQL Server 2000 database in a test program
    through the ODBC:

    SELECT Surname, Date_of_birth FROM Employee WHERE Date_of_birth =
    '4/15/1975'

    This was the error I receive…
  • It's probably because I'm going through the ODBC to SQL Server; ADO and ODBC
    obviously use different date formats in the SQL. I've overridden the date
    format in my DADE plug-in (for ODBCExpress), but the quotes around the query
    in daS…
  • Ok, Jim

    thank's yous warning...

    Cheers,

    Silv?rio Rodrigues Hoppe
  • Jim,

    I dont using Filed's auto inc, after varius test, discovery is erro ocurred
    where have of next configuration:

    Mestre -> detalhe -> detalhe

    any report simples not ocurred problems but where work report…
  • Jim,

    I am use Delphi 6.2 + DBEXpress + MySql 3.23.51, where use report-enduser
    via ppExplorer, is RB generation o SQL is my server MySql is bolt. Please
    know is problem? Is now test RB + DBExpress + MySQL? Or I am
    make wron…
  • Jim Bennett (Digital Metaphors) wrote:

    Jim, you ask tough questions. I'm developing a wizard which allows
    the end user to drag 'n drop tables onto a pane, specify joins, etc. The
    problem *was* that when I added the 'CUSTOMER'…
  • Paul,

    to use the storage of a report template you can use the property 'TppCustomTemplate.Offset' to define extra space.
    See tech tip 'Tech Tip: Storing Custom Information with Templates'

    regards,
    Chris Ueberall;
  • Chris,

    My apologies, I couldn't have explained myself very well. I want to be able
    to store a report title and an report summary with the report. Then when I
    use and explorer type interface, I want to be able to load the report…
  • Hi Paul,

    If I understood you right, your problem isn't accessing ReportBuilder's global constants rather than supporting all reports with data from your application (-> ' I want to be able to add a report title and summary to all my re…
  • Chris,

    Either I have not understood your answer, or you have misunderstood my
    question. The global constant is declared inside the report. I want to be
    able to extract this.

    Regards,

    Paul


  • Hi Paul,

    use a JITPipeline for general informations.

    HTH,
    Chris Ueberall;
  • ReportBuilder will automatically separate Bill and Jones, because the
    'inlist' type is looking for a list separated by commas. So lsCustomerList
    would end up looking like ''Bill', 'Jones''.

    Leah

  • Hi ... I found a solution. I substituted a different character for the
    comma in the customer name (Jones. Bill) when adding the criteria value, and
    then replaced it with the comma in the MagicSQLText. It's not pretty, but
    hey, it w…
  • I'm not sure I understand. Once I add the criteria to the table,
    ReportBuilder adds quotes to the sCustomerList so when the SQL is executed
    it looks like:
    'Brian', 'Jones', 'Bill', 'Carolyn', 'Robert'.

    Adding quotes to…
  • Jim,

    Thanks for the reply, I was able to add the OR clause using the method you
    suggested.

    Ray Allen


  • About 1 AM this morning, I was looking through the Digital-Metaphors
    newsgroup archives for the third time and found a thread I had
    previously missed. A user in Australia described the disconnection
    problem I've been experiencing wh…
  • > What happens when you comment it out? Does it not work?

    I get no error but I also (this may or may not be related) get no data
    returned on the preview. If I can't get AstaDADE to work, can you
    suggest a Plan B? The clock …
  • Thanks for your suggestions. I'm making progress. The apparent cause of
    the "invalid variant conversion error" was the fact that I had installed
    the AstaDADE package but had not properly compiled daAsta.pas and placed
    it in the RB …
  • Jim,

    Thanks, I figured it out

    regards
    Paul

    In article <3df0c9ad$1@dm500.>, "Jim Bennett \(Digital Metaphors\)"
    at "Jim Bennett \(Digital Metaphors\)"
  • Hi Jim

    Just didn't get an answer to my other question.

    Note, I am only considering upgrading, because I still have problems with
    ie;
    there

    Note, if I have to upgrade to 7 to have the fix, then so be it. Wa…
  • Hmm, when i exited my app and re-entered I could then search on calc field??
    Some sort of refresh problem. Oh well!

    Alex

  • Jim,

    Switching to another database is not an option at this moment. We're talking
    about an old 16 bit Delphi 1 app (with RB 3), that we're porting to D6 and
    the customer is waiting. We simply don't have the time to switch to ano…
  • Thanks Jim,

    I have already started a new DADE plugin for it, just a few issues to
    resolve. When its finished your welcome to make it publically available, in
    case anyone else might be interested.

    Best Regards
  • Hi Adam.

    Can you send to me?



    Thanks.

    Fabiano.