Search:

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

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...

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...

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...

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,...

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...

Right, and you noticed that the "color" specified was "hide" which will hide that total from the chart.
Bob

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...

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...

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...

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...

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...

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...

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#@...

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

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...

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...

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.)...

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:...

A picture would have helped me find this quickly, so here's one for those like me....
13036

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...

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...

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...

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?
...

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...