Search:

Sorry Jeff, DAI doesn't offer an option to sort column groupers descending. You'll have to get clever and create a formula column that prefixes the data with values that will reverse the sort for ...

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

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

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

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

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

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

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

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

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