Search:

Type: Posts; User: Bob Cergol

Page 1 of 59 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    207

    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...
  2. Replies
    9
    Views
    324

    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?
    ...
  3. Replies
    9
    Views
    324

    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...
  4. Replies
    4
    Views
    2,775

    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...
  5. 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...
  6. Replies
    4
    Views
    545

    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...
  7. Replies
    4
    Views
    545

    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 =...
  8. Thread: Maps

    by Bob Cergol
    Replies
    2
    Views
    285

    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...
  9. 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...
  10. Replies
    3
    Views
    320

    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
  11. Replies
    2
    Views
    319

    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...
  12. 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...
  13. Replies
    8
    Views
    1,410

    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...
  14. 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...
  15. Replies
    8
    Views
    1,410

    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,...
  16. 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...
  17. 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....
  18. 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...
  19. Replies
    5
    Views
    980

    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...
  20. Replies
    6
    Views
    900

    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...
  21. Replies
    6
    Views
    900

    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...
  22. Replies
    6
    Views
    900

    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...
  23. Replies
    7
    Views
    534

    Re: Dashboard issue

    Jeff, I confirmed with Cintac that the tile IDs will be consistent on subsequent retrieves of the dashboard. Also confirmed scripting will be the only way you might be able to get view parameters to...
  24. Replies
    7
    Views
    534

    Re: Dashboard issue

    I don't know the answer to that but I'll try to get more information for you Jeff.
    -Bob
  25. Replies
    7
    Views
    534

    Re: Dashboard issue

    Search for 'redirect' in the doc. FWIW, I rarely ever use the on-line doc. Search just works better and at more granular a level using the PDF file you can download from out ftp site. See the sticky...
Results 1 to 25 of 1457
Page 1 of 59 1 2 3 4