Not all of our users are using the Web UI and we have a report that users export to a CSV file that we want to convert to an SSRS report and still be able to export as a csv but in doing that Excel launches automatically upon print preview when in the Kinetic Classic version and excel changes the date format automatically.
In the WEB UI the csv file will export without automatically opening excel. However, the current users of this report are not migrated to WEB UI.
The issue is with a date field that we need to show in a csv file as mm/dd/yyyy. In the ssrs report design I have set the formatting in the expression instead of by the text box properties.
The BAQ report design and menu for this report were created in the WEB UI version and is set up as a Kinetic APP with report as the type.
I’ve tested turning off the automatic excel date conversion option but it doesn’t fix the issue for exporting to a csv and holding the date format from the classic UI.
Does anyone know a workaround for this?