Search:

Type: Posts; User: Bob Cergol

Page 1 of 59 1 2 3 4

Search: Search took 0.03 seconds.

  1. Sticky: Re: Recent Microsoft Changes to Windows 10 May Impact Functionality and/or Data Integrity

    A picture would have helped me find this quickly, so here's one for those like me....
    13036
  2. Sticky: Re: Recent Microsoft Changes to Windows 10 May Impact Functionality and/or Data Integrity

    My Win10 PC was updated to 1803 and I too can't find that setting as instructed either by Stephen or Frank. My PC started life as a Win7 Pro machine and got updated to Win10 so maybe that results in...
  3. Replies
    3
    Views
    4,280

    Re: Schedule email doesnt send.

    The SMTP email settings you defined in your Dynamic AI instance are used by both manual and scheduled sending, so if one works, the other should work. Make sure:


    The 'AGENT' user exists in your...
  4. Replies
    3
    Views
    2,669

    Re: Dynamic vs. Office 365

    Microsoft Excel and Word both have supported for many years an HTML document, including hyperlinks, that organizes the data in a table. Dynamic outputs such a file when you use that output option and...
  5. Replies
    9
    Views
    1,728

    Re: Default values messed up

    Albin,

    Are you saying the very same data gave you a different result before you switched from date-time to date type, than you are getting after you switched back from date to date-time type?
    ...
  6. Replies
    9
    Views
    1,728

    Re: Default values messed up

    Hi Albin,

    You are correct that Dynamic AI is not seeing the 'DATE' type column as date data. It is a long-standing flaw that I have complained about to Cintac. Grouping and sorting would work just...
  7. Replies
    4
    Views
    3,985

    Sticky: Re: Welcome to the Dynamic AI forum

    But you posted a message to the AI forum...:confused:

    I guess you meant the public Dynamic AI site that contains reports about the forums.

    I saw the guest user account was locked from too many...
  8. Replies
    1
    Views
    1,316

    Re: Getting error on SQLite ODBC connection

    Hi Richard,

    The error is pretty explicit. The DSN is not visible to the Dynamic AI instance for whatever reason....


    You did install the SQL Lite ODBC driver and DSN on the server that is...
  9. Replies
    4
    Views
    1,562

    Re: Formula using an unknown?

    Hi Kyle,

    I think it will be best to review the specific details with you in a screen-share session so I can understand the full context of what you are trying to do. Perhaps you need to be using...
  10. Replies
    4
    Views
    1,562

    Re: Formula using an unknown?

    The SQL translation of that Cyrstal Syntax would be to use an SQL Case statement like this:


    Case
    when TABLENAME.FIELDNAME1 = @PAR1@ Then TABLENAME.FIELDNAME1
    when TABLENAME.FIELDNAME2 =...
  11. Thread: Maps

    by Bob Cergol
    Replies
    2
    Views
    1,250

    Re: Maps

    Hi Kyle,

    Maps in Dynamic AI are a special type of chart and are limited to the first grouping in a report which must also be the only grouping in the top level. You cannot have a map appear as the...
  12. Replies
    1
    Views
    2,350

    Re: inital login to new install of dynamic AI

    Hello Kevin,

    When Data Access Worldwide provides evaluation and/or permanent licenses we provide all of the information needed to get up and running, including this basic information. Did you...
  13. Replies
    3
    Views
    1,396

    Re: Orders containing products

    Do a grouping on job number. If you experiment with Dynamic AI design tool then you can see the SQL that it generates to achieve the result. You'll want to make the details in their own level.
    -Bob
  14. Replies
    2
    Views
    522

    Re: Other Report Writers

    Many regulars on this forum know my bias for Dynamic AI. Unless you need a business form, or a report with heavily formatted subheader/subtotal sections, I've found Dynamic AI unbeatable in terms of...
  15. Re: Displaying a "waiting symbol" (Hourglass) during longer excecution

    Hi Gerhard,

    In version 7 Dynamic AI will display an animated icon that indicates activity. In V6 (and from the very first versions of the product) the only indication that the system is waiting is...
  16. Replies
    8
    Views
    2,595

    Re: Choose the day the weeks start

    I beg your pardon. My memory failed me regarding the definitions of "week" versus "work week". "Week" = 7 days starting with Monday. "Work Week = 5 days starting with Monday. I retested and i get...
  17. Re: Linking to a different report with filter values

    Yes it makes a difference. Report filters are not view parameters.

    The URL arguments for parameters are: &FParm#_ where # = the number of the parameter 1..10.
    You still can't pass two date...
  18. Replies
    8
    Views
    2,595

    Re: Choose the day the weeks start

    Eddy's 1 line of .js to put in rules tab solved the question posted by Sera about date-picker on date filters, so yes, I'd say this thread was 'solved'.

    You are asking about something different,...
  19. Re: Linking to a different report with filter values

    What names did Dynamic AI show you for the date filters in its Report Documentation?

    StartDate and StopDate are caption names for the same single data column, right? I don't think that's what...
  20. Re: Linking to a different report with filter values

    Hi Ben,

    Between date filter in URL is not supported. Instead define two filters in the report on the data column using >= on the first one and <= on the 2nd one. Save the change. Run the report....
  21. Re: Install dynamic automatically / silent way

    Hi Gerhard,

    There is no "silent" option available in the installer -- and given that each install has to activate the license, and given that the license is specific to the machine on which...
  22. Replies
    12
    Views
    7,401

    Re: Concurrent Transactions

    Thanks for posting that feedback & tip Ben.

    In case of a long-running query that is expected, and not a SQL programming bug, remember you can set whatever query time-out you want in report design...
  23. Replies
    6
    Views
    2,037

    Re: Wrong character

    Geza,

    I checked with Cintac and they suggest this might have to do with something server-side other than Dynamic AI, and doubt that somehow forcing charset=iso-8859-2 won't accomplish what you...
  24. Replies
    6
    Views
    2,037

    Re: Wrong character

    I'll have to research this, but won't have time today. You've been using Dynamic AI in Hungary for many years so why do you think this is all of a sudden a problem? The product has not changed in...
  25. Replies
    6
    Views
    2,037

    Re: Wrong character

    Hi Geza,

    Dynamic AI supports 9 languages, 2 of which can be specified on the System, Setup tab page. Then the language for each user can be specified on the account tab in user profile. The...
Results 1 to 25 of 1463
Page 1 of 59 1 2 3 4