i have an dateformat issue.
When i generate a report on my server with node.js i get an dateformat on report like mm/dd/yyyy {us/en} but i define the fomat on the designer like dd.mm.yyyy {german format}
When i generate the report on client side (on my firefox Browser) i get correct date formate. i use the same template file for generate the report the data where datetime date cames from is a JSON response from url.
here a copy of them. i am using {Auftrag.was_insert} date data. here the code by using the viewer (designer code are similar):
Code: Select all
{...}
Stimulsoft.Base.Localization.StiLocalization.setLocalizationFile("localization/de.xml", true);
var options = new Stimulsoft.Viewer.StiViewerOptions();
options.appearance.fullScreenMode = true;
options.toolbar.showSendEmailButton = true;
options.toolbar.showPrintButton = false;
var viewer = new Stimulsoft.Viewer.StiViewer(options, "StiViewer", false);
// Process SQL data source
viewer.onBeginProcessData = function (event, callback) {
<?php StiHelper::createHandler(); ?>
}
// Manage export settings on the server side
viewer.onBeginExportReport = function (args) {
<?php StiHelper::createHandler(); ?>
args.fileName = "<?php echo $_GET['id'] ?>_Auftrag";
}
// Process exported report file on the server side
viewer.onEndExportReport = function (event) {
event.preventDefault = true; // Prevent client default event handler (save the exported report as a file)
<?php StiHelper::createHandler(); ?>
}
// Send exported report to Email
viewer.onEmailReport = function (event) {
<?php StiHelper::createHandler(); ?>
}
viewer.onPrintReport = function (event) {
<?php StiHelper::createHandler(); ?>
}
// Load Data
var report = new Stimulsoft.Report.StiReport();
var dataSet = new Stimulsoft.System.Data.DataSet('Auftrag');
var recievedData = '';
$.ajax({
async: false,
type: 'GET',
url: "../../../get_Auftrag.php",
data: { id: '<?php echo $_GET['id']; ?>'},
success: function(data){
recievedData = data;
}
});
// Load and show report
//dataSet.readJson(recievedData);
var jsonData = Stimulsoft.Base.StiJsonToDataSetConverter.getDataSet(recievedData);
report.regData(Auftrag', 'Auftrag', jsonData);
// Load report
//alert(recievedData.vorgang.art);
report.loadFile("reports/"+recievedData.Head.Report);
report.dictionary.synchronize();
viewer.report = report;
viewer.renderHtml("viewerContent");
{...}
Code: Select all
console.log('start report rendering @ '+ new Date().toLocaleString() );
{...}
var dataPromise = getData('../../../get_Auftrag.php?id='+query.id);
dataPromise.then(JSON.parse, errHandler)
.then(function(result){
Stimulsoft.Base.StiFontCollection.addOpentypeFontFile("./Roboto-Black.ttf");
var report = new Stimulsoft.Report.StiReport();
Stimulsoft.Base.Localization.StiLocalization.setLocalizationFile("../../../localization/de.xml");
// Loading report template
report.loadFile("../../../reports/VorgangRechnung.mrt");
console.log("Report template loaded");
// Create new DataSet object
var dataSet = new Stimulsoft.System.Data.DataSet("Auftrag");
console.log("create dataset");
// Load JSON data file from specified URL to the DataSet object
dataSet.readJson(result);
console.log("read JSON to dataset");
// Remove all connections from the report template
//report.dictionary.databases.clear();
//console.log("clear dictionary");
// Register DataSet object
report.regData("Auftrag", "Auftrag", dataSet);
console.log("register dataset into dictionary");
// Sync Dictionary
report.dictionary.synchronize();
console.log("synchronize dictionary");
// Renreding report
report.render();
console.log("Report rendered. Pages count: ", report.renderedPages.count);
// Export to PDF
var pdfData = report.exportDocument(Stimulsoft.Report.StiExportFormat.Pdf);
console.log('export rendered report');
// Converting Array into buffer
var buffer = new Buffer(pdfData, "utf-8")
console.log("write rendered report to buffer");
// Saving string with rendered report in PDF into a file
fs.writeFileSync('./'+result.Auftrag.RechnungenID+'_Rechnung.pdf', buffer);
console.log("Rendered report saved into PDF-file.");
console.log(result.Auftrag.RechnungenID+'_Rechnung.pdf');
}, errHandler);
{...}