Activity for Acy Forsythe
-
Acy Forsythe posted a comment on discussion ART Help
No mapping found for HTTP request with URI [/art/export/reports/] in DispatcherServlet with name 'dispatcher'
-
Doesn't seem to have any impact. Anyone else know how to change this background color? Art 3.8
-
Doesn't seem to have any impact. Anyone else know how to change this background color?
-
Thanks Tim! I have not had an opportunity to upgrade since 3.8 so I just have it running in a test environment, but I'm excited to go straight to 3.10 instead and add these options!
-
Thanks Timothy, I'll take a look at that library then.
-
What does the application base the column width on, it almost seems to be random...
-
I have 3 large text columns in a report and one of the columns sizes to about 40 characters wide, but the other two size to like 10 characters wide. Is there anyway that I can manually set the column widths in the result set?
-
in Art.JS, you are looking for these lines: var oTable = tbl.dataTable({ orderClasses: false, pagingType: "full_numbers", lengthMenu: [[5, 10, 25, -1], [5, 10, 25, showAllRowsText]], pageLength: pageLength, columnDefs: [{ targets: 0, orderable: false, className: 'select-checkbox' }, There are a number of jsp pages that have this coded at the page level, and you can simply search for "showAllRowsText" text to find them. I'm on a windows server, so I use Visual Studio Code for my live page editor and...
-
in Art.JS, you are looking for these lines: var oTable = tbl.dataTable({ orderClasses: false, pagingType: "full_numbers", lengthMenu: [[5, 10, 25, -1], [5, 10, 25, showAllRowsText]], pageLength: pageLength, columnDefs: [{ targets: 0, orderable: false, className: 'select-checkbox' }, There are a number of jsp pages that have this coded at the page level, and you can simply search for "showAllRowsText" text to find them. I'm on a windows server, so I use Visual Studio Code for my live page editor and...
-
in Art.JS, you are looking for these lines: var oTable = tbl.dataTable({ orderClasses: false, pagingType: "full_numbers", lengthMenu: [[5, 10, 25, -1], [5, 10, 25, showAllRowsText]], pageLength: pageLength, columnDefs: [{ targets: 0, orderable: false, className: 'select-checkbox' }, There are a number of jsp pages that have this coded at the page level, and you can simply search for "showAllRowsText" text to find them. I'm on a windows server, so I use Visual Studio Code for my live page editor and...
-
in Art.JS, you are looking for these lines: var oTable = tbl.dataTable({ orderClasses: false, pagingType: "full_numbers", lengthMenu: [[5, 10, 25, -1], [5, 10, 25, showAllRowsText]], pageLength: pageLength, columnDefs: [{ targets: 0, orderable: false, className: 'select-checkbox' }, There are a number of jsp pages that have this coded at the page level, and you can simply search for "showAllRowsText" text to find them. I'm on a windows server, so I use Visual Studio Code for my live page editor and...
-
in Art.JS, you are looking for these lines: var oTable = tbl.dataTable({ orderClasses: false, pagingType: "full_numbers", lengthMenu: [[5, 10, 25, -1], [5, 10, 25, showAllRowsText]], pageLength: pageLength, columnDefs: [{ targets: 0, orderable: false, className: 'select-checkbox' }, There are a number of jsp pages that have this coded at the page level, and you can simply search for "showAllRowsText" text to find them. I'm on a windows server, so I use Visual Studio Code for my live page editor and...
-
in Art.JS, you are looking for these lines: var oTable = tbl.dataTable({ orderClasses: false, pagingType: "full_numbers", lengthMenu: [[5, 10, 25, -1], [5, 10, 25, showAllRowsText]], pageLength: pageLength, columnDefs: [{ targets: 0, orderable: false, className: 'select-checkbox' }, There are a number of jsp pages that have this coded at the page level, and you can simply search for "showAllRowsText" text to find them. I'm on a windows server, so I use Visual Studio Code for my live page editor and...
-
Awesome, Downloading it now.
-
I'm actually interested in adding ticketing system functionality to it as well to create a single portal for both applications. It has all of the functionality that is required, but there are two changes I'm having trouble making, adding a new page (made a copy of the reports page to test) and allowing two columns of entry fields for parameters. I've already created reports for data entry to enter in both feedback requests and trouble ticket records, which can then be reported on. I'm using SQL triggers...
-
I'm actually interested in adding ticketing system functionality to it as well to create a single portal for both applications. It has all of the functionality that is required, but there are two changes I'm having trouble making, adding a new page (made a copy of the reports page to test) and allowing two columns of entry fields for parameters. I've already created reports for data entry to enter in both feedback requests and trouble ticket records, which can then be reported on. I'm using SQL triggers...
-
We just started using ART and have 21 users, and 8 datasources with another 6 datasources planned. We are currently migrating several hundred reports over and have 45 moved so far. Previous reporting system was a shared MS Access database with some ad-hoc VB executables assisting. We are using many aspects of the system, Dashboards for showing BI information in useful charts, queries for troubleshooting systems, or data lookups, automated report emails for metrics, and for helping out the IT guys,...
-
Thanks Nitin, I'll play around with that.
-
nitin, I beleive this is already possible at least in 3.8 with tags. You can put a comment in your SQL with :username: and :jobid: Also if you want to log the SQL outside of ART, you can create your own log table, and for every report run an insert statement to insert the username, JobID and expanded SQL code into a table, then run your select statement. You just have to adjust the report source to pull data from the 2nd query in the report config.
-
Thanks Timothy, I'll give that a shot. Not sure if it's really necessary, but we have noticed some quirks with our SQL syntax so I'm thinking the JTDS driver may not support everything. And sorry, I wasn't deliberately hijacking his thread for this, I was trying to be informative since we were both using the same driver and I didn't know if he might run into the same issues I ran into with the Microsoft driver.
-
Thanks Timothy, I'll give that a shot. Not sure if it's really necessary, but we have noticed some quirks with our SQL syntax so I'm thinking the JTDS driver may not support everything.
-
FYI, if you are using Java 9 or 10, the Microsoft driver fails due to deprecated functions. Not sure yet if it's libraries used by ART or the driver itself, but heads-up. I'm using the jTDS driver as well for that reason.
-
Got it! I accidently skipped past saving when I added the parameter to the 2nd report. It's all working now.
-
I celebrated prematurely, my drilldown detail report does not show up in the drop-down list for "Drilldown Report" selection. I tried typing in the name to have it select and it does not find any matches.
-
I feel sheepish. At least it wasn't on the main page with flashing neon text, but still I've been in the "More" configuration menu a few dozen times and still never saw it. Thanks once again Timothy!
-
I think I'm probably missing something very simple regarding the link between the pie chart example and the pie chart drill down example. I have two reports setup and I have the parameter for the second report setup as a drill down column index 1, and I'm not sure what else I need to do to link the two reports outside of that. Any help on exactly what's needed to tie the two reports together other than setting up the parameter?
-
You are awesome!
-
Total_net is an INT column. I was originally trying to sum it, but during troubleshooting, I just created a single row table with a value in that column to make the testing as simple as possible. Both tables have that column as INT though.
-
Right... Sorry. java.lang.ClassCastException: java.base/java.lang.String cannot be cast to java.base/java.lang.Number at art.runreport.RunReportHelper.getDoubleRowValue(RunReportHelper.java:984) at art.chart.SpeedometerChart.prepareRow(SpeedometerChart.java:126) at art.chart.SpeedometerChart.fillDataset(SpeedometerChart.java:95) at art.chart.Chart.prepareDataset(Chart.java:429) at art.runreport.ReportOutputGenerator.prepareChart(ReportOutputGenerator.java:496) at art.runreport.ReportOutputGenerator.generateChartReport(ReportOutputGenerator.java:1315)...
-
Full error: java.sql.SQLException: Invalid column name 'Accounts'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)...
-
On another note, the sample works fine in Hsql, just not sure why it's not working in MSSQL. Unfortunately, I can't change that DB, all I can do is figure out a way to pull the data out of it, put it in another database on demand, and that really negates the ability to use the refresh option with this. I was hoping I could have it as a 5sec refreshed gauge for a dashboard.
-
SQL Server 2008 using the JTDS driver because on Java 10, the Microsoft driver errors out. SQL code works after turning off quoted identifiers (although I also tried with single quotes and get the same error as below) Select Total_net,0,20000, "Accounts" From billing_table Example: SELECT reading, 0, 100, "degrees", "50:#00FF00:Normal", "80%:#FFFF00:Warning", "100:#FF0000:Critical" FROM temperature_reading Here is the error that I get: java.lang.ClassCastException: java.base/java.lang.String cannot...
-
Thanks Timothy, I might eventually build my own style sheets, but I'm a dba by trade rather than a web developer, so this is all new to me. Thanks for all your help with this, not sure how I missed bootstrap.min.css.
-
Ok... so changing the colors under .panel-success doesn't seem to do anything. I also tried replacing them in the .map file. mainPageWithPanel.tag seems to get most of them, but there are a few stragglers I'm guessing are set within the jsp pages. For now, I've changed them all to point to panel-primary, but I would like to be able to specify my own colors at some point. Just not sure how/where to do that. I thought I was in the right place after your previous advice, but I must have missed something....
-
Ok, so I changed this section in bootstrap-theme.css: .panel-success > .panel-heading { background-image: -webkit-linear-gradient(top, #a4a4c1 0%, #a4a4c1 100%); background-image: -o-linear-gradient(top, #a4a4c1 0%, #a4a4c1 100%); background-image: -webkit-gradient(linear, left top, left bottom, from(#a4a4c1), to(#a4a4c1)); background-image: linear-gradient(to bottom, #a4a4c1 0%, #a4a4c1 100%); filter: progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffdff0d8', endColorstr='#ffd0e9c6',...
-
Sorry, I was unclear what I am looking for... I would like to change the title headings color on the pages. The part right under the header menus that has the dark green text on the pale green background. I think I am in the right place now, but the files are lacking white space, so it might take a while to find it. Can you help me with search text like "page-heading" or something?
-
I've been digging through source for quite a bit looking for a way to the green. I don't seem to find it in any of the css files, but they are spread out in numerous places so I'm obviously missing the one that matters or it's being set somewhere else? Possibly in one of the js files for the UI elements?
1