Search:

Type: Posts; User: Bob Cergol

Page 1 of 60 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: How to change the font size of a HC title

    Sorry Pepe, you can't. Those tiles are built into DAI's "runtime"

    Regarding all these specialized formatting things you ask to do from time to time -- if there's no user-interface object in the...
  2. Re: Conditionally evaluate TotaFormula calculations

    Hi Pepe,

    Don't forget about drill-down reports. So you could do the conditions-based aggregation(s) you need in a view, make a report on it, and then drill down from any row into a related report,...
  3. Thread: Tile size

    by Bob Cergol
    Replies
    7
    Views
    3,522

    Re: Tile size

    Nope. They are hard-coded. You can only control the tile-type, colors, and in the case of the gauges, 1 versus 2 needles.
    You could only control the size of all tiles by changing the magnification...
  4. Replies
    4
    Views
    269

    Re: Bar chart with selected columns

    Right, and you noticed that the "color" specified was "hide" which will hide that total from the chart.
    Bob
  5. Re: Conditionally evaluate TotaFormula calculations

    The short answer is no, you can't use conditional expressions in a total formula.

    The solution would be to make the data source of the report an SQL view that does the aggregation you need. It...
  6. Replies
    4
    Views
    269

    Re: Bar chart with selected columns

    Hi Pepe,

    Did the information found in the other forum thread you referenced here not work for you?

    Here's a snippet from the released docs that repeats that information:

    Build 6.4.46
    You...
  7. Replies
    3
    Views
    504

    Re: Combine 2 forms

    You can easily test this yourself. As I said, you can add multiple form reports to a report package, but you won't be able to navigate in any of the individual reports displayed. Just make a copy of...
  8. Replies
    3
    Views
    504

    Re: Combine 2 forms

    Short answer: No - not in any useful way that I can think of.

    While you could make a report package (dashboard) consisting of multiple form 'reports', and Dynamic AI would display the first record...
  9. Replies
    2
    Views
    310

    Re: CTE in DAI views

    Dynamic builds a select statement on top of whatever is the data source -- treating it just as any other table or view, and appending clauses for where, grouping and ordering as needed according to...
  10. Replies
    5
    Views
    549

    Re: Chhose columan for a graph

    P.S. FWIW, since Dynamic AI is sending an HTML stream to the browser, any valid HTML code that can be injected into the page via 'rules' script tab, or the assigned CSS -- or even in a formula column...
  11. Replies
    5
    Views
    549

    Re: Chhose columan for a graph

    You are limited what you can do controlling graphs in Dynamic without resorting to injecting script into the rendered page using the rules tab in report design. I donít know how you could use @PAR#@...
  12. Re: Problems with "date" types in a MSSQL database

    I don't know what to tell you Pepe.
    I've never seen this not work in countless deployments over the past 12 years.
    13642
  13. Re: Problems with "date" types in a MSSQL database

    As Garrett said, blame Microsoft for supporting different min/max values in its various date data types. (Okay, those weren't his exact words.)

    Whenever I have seen the out-of-range value error as...
  14. Re: Problems with "date" types in a MSSQL database

    What you're saying is that you use Dataflex driver settings with Dataflex programs to migrate DATE type data to DATETIME type data. Dynamic AI only knows what it sees in the table -- and you have...
  15. Re: Problems with "date" types in a MSSQL database

    Unfortunately, the only solution is to cast the date as datetime. (I cannot defend that DAI V6 doesn't recognize MS-SQL DATE type as such -- since Microsoft introduced that type in 2008 as I recall.)...
  16. Re: Problems with "date" types in a MSSQL database

    Hi Pepe,

    While the 'DATE' type was introduced quite a long time ago, DAI won't see it as a date unless you CAST it as DateTime.

    You can choose the zero date for DAI via the system parameter:...
  17. 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
  18. 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...
  19. Replies
    3
    Views
    8,107

    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...
  20. Replies
    3
    Views
    3,637

    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...
  21. Replies
    9
    Views
    2,865

    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?
    ...
  22. Replies
    9
    Views
    2,865

    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...
  23. Replies
    4
    Views
    5,045

    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...
  24. Replies
    1
    Views
    2,260

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

    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...
Results 1 to 25 of 1479
Page 1 of 60 1 2 3 4