Search:

Type: Posts; User: Bob Cergol

Page 1 of 60 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    8
    Views
    953

    Re: Office365 and SMTP in DynamicAI

    AFAIK, TLS is supported, in fact I think that is what GMail is using. However there are newer versions of TLS that Office365 might require, that DAI V6 does not support. You should have received an...
  2. Replies
    8
    Views
    953

    Re: Office365 and SMTP in DynamicAI

    P.S. On the odd chance you're using an old build of DAI, know that the SMTPUSESSL parameter was implemented some time in late 6.4.x builds. You shouldn't be using anything older than 6.5.12. (The...
  3. Replies
    8
    Views
    953

    Re: Office365 and SMTP in DynamicAI

    Hi Ben,

    We use Office 365 at DAW, including for email. The SMTP server setting in our various DAI instances simply references one of two internal servers, e.g. blabla@dataaccess.com. I want to...
  4. Re: DAI 0004020 Error returning a lot of rows

    Hi Mike,

    Instead of "open in Excel" try using the 'CSV' option and when prompted choose "Save" instead of open in Excel. When I do that using a data source with 300,000 rows, I get all of the...
  5. 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
  6. 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...
  7. Replies
    4
    Views
    3,165

    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...
  8. Replies
    4
    Views
    3,165

    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...
  9. Replies
    3
    Views
    4,025

    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
  10. Replies
    3
    Views
    4,025

    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...
  11. Replies
    2
    Views
    9,332

    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...
  12. Replies
    2
    Views
    3,467

    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...
  13. 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,...
  14. Thread: Tile size

    by Bob Cergol
    Replies
    7
    Views
    13,568

    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...
  15. Replies
    4
    Views
    1,895

    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
  16. 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...
  17. Replies
    4
    Views
    1,895

    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...
  18. Replies
    3
    Views
    2,172

    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...
  19. Replies
    3
    Views
    2,172

    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...
  20. Replies
    2
    Views
    2,015

    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...
  21. Replies
    5
    Views
    4,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...
  22. Replies
    5
    Views
    4,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#@...
  23. 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
  24. 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...
  25. 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...
Results 1 to 25 of 1490
Page 1 of 60 1 2 3 4