Hi Mike,
If you check update notes you'll see:
version 6 5 17
- added QRCode folder, MFA.html and the option to add 2 factor authentication using parameter Application MFA T/F 1
I've never...
Type: Posts; User: Bob Cergol
Hi Mike,
If you check update notes you'll see:
version 6 5 17
- added QRCode folder, MFA.html and the option to add 2 factor authentication using parameter Application MFA T/F 1
I've never...
Yes, but it is such a better solution if you can solve that by eliminating the issue by improving the time it takes for the SQL query to execute: use of parameters and sub-queries to reduce the...
Hi Mike,
When a report is run the first time by clicking on it in the menu the only indication DAI is waiting on a query result and the browser for the HTML page to be streamed is in the lower...
That's the better solution for sure. I first encountered this same issue a couple years ago, and invested a lot of time troubleshooting and finding the solution. When I was finished I learned that...
In DAI build 6.5.20, High Charts was updated to version 6.03, meaning no more support for old Internet Explorer (V8). I don't think its possible for you to override DAI's internal programming to...
Hi Jeff,
My first suspcion is that your C# application is using iFrame from IE -- and the default version Windows defines is old, and does not support the newer versions of High Charts. You can...
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...