Search:

Type: Posts; User: Bob Cergol

Page 1 of 60 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Dynamic AI highchart column-stacked-and-grouped

    You mentioned multiple X axis, but just in case I didn't understand what you are truly after. Maybe this is what you want:
    14796
  2. Re: Dynamic AI highchart column-stacked-and-grouped

    Hello Linda,

    The short answer is you can't. You can only choose from the available charts in the drop down. However it has 4 choices that offer mutiple Y axis: column, line, line + column, and...
  3. Replies
    4
    Views
    1,326

    Re: Report filter options

    If you're asking can Dynamic AI use random multiple values from a list of values in a multi-select drop-down list attached to a column filter, and then generate a where clause with: LIKE value 1 OR...
  4. Replies
    4
    Views
    1,326

    Re: Report filter options

    Hi Ben,

    I find your question ambiguous, so Iíll answer all the possibilities I can think of.

    You define filters on table.columns, not rows. When you choose a multi-select filter and the user...
  5. Replies
    3
    Views
    1,352

    Re: Fully Homomorphic Encryption (FHE)

    AH! Now I understand. Thanks for that instructive reply.
    Dynamic AI can only work with the actual unencrypted data stream from the SQL engine.
    Bob
  6. Replies
    3
    Views
    1,352

    Re: Fully Homomorphic Encryption (FHE)

    Hello Eric,
    I'm responding primarily to your use of the term Dataflex AI. You won't find any such term anywhere in DataFlex's documentation. I think you might have in mind Dynamic AI which is an...
  7. Replies
    2
    Views
    2,775

    Re: Error using Dynamic AI

    Hi Jeff,

    Yes. You can rename the file if you want to keep it. There should be a file named emptyDNMCLOG.dai in the DAT folder wherever you installed Dynamic AI. You can make a copy and rename it...
  8. Replies
    2
    Views
    1,284

    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...
  9. 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,...
  10. Thread: Tile size

    by Bob Cergol
    Replies
    7
    Views
    5,751

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

    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
  12. 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...
  13. Replies
    4
    Views
    936

    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...
  14. Replies
    3
    Views
    1,180

    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...
  15. Replies
    3
    Views
    1,180

    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...
  16. Replies
    2
    Views
    946

    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...
  17. Replies
    5
    Views
    1,630

    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...
  18. Replies
    5
    Views
    1,630

    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#@...
  19. 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
  20. 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...
  21. 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...
  22. 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.)...
  23. 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:...
  24. 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
  25. 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...
Results 1 to 25 of 1486
Page 1 of 60 1 2 3 4