You need to use parameters to filter the query results of the report, parameters can give the user to fill in the filtering conditions, you can refer to the example in the demo, provided that you can SQL statements
The latest version 8.2 of the task mail attachment name can be displayed normally. Thx!
After I tried to update to ART 8.0 today, the Chinese characters in the sender name and recipient name appear normally, as shown in Figure 1 But there is still a problem with Chinese characters in the name of the attachment; The original file name and type of the attachment are shown in Figure 2
I tried to use gmail to receive and send task emails, and the recipient nickname and attachment name of the email were normal in the gmail web page; However, the name of the sender and recipient, as well as the name of the attachment, will be abnormal when receiving with outlook What is the reason for this? I looked for the reason through AI and got this explanation: This is usually caused by the way the mail client handles the file name of the attachment. In order to ensure that the file name can...
This is good.
It is hoped that in the next release, Jxls type reports will also support the filename option so that file names can be defined using parameters
In Jobs menu interface, the file name is normal; So could it be an outlook or mail-server coding problem?
Hi The problem with garbled codes I created a job with Chinese in the fixed file name, and the sender and recipient nicknames. After the task is successfully executed, the names of senders and recipients in the emails received by outlook 2016 are abnormal, and the names of attachments are also abnormal. It is normal if you only use English; Is there any way to solve it? Please look at the picture, thank you!
Thank you for your help, I hope to add such parameter function in the later version, I can only try to see if there is any other way.
My hope is to be able to input parameter values from csv or txt files, because the raw data is stored in the user's file; If you can use art's report page to achieve this parameter input is also good. Because my report needs to calculate the estimated amount, the product model is in my system, but the quantity needs to be filled in by the user; Therefore, the user needs to fill in the product model and the corresponding quantity at the same time to achieve the purpose of calculation. Thank you for...
I need to use a multi-column parameter, can art 7.6 be implemented? For example, if I want to estimate the number of shipments of a product and then calculate the estimated revenue: product quantity A1 100 A2 300 A3 400 There are two columns of parameters I need to use, one is the product model and the other is the estimated sales quantity I have tried the file parameters, it seems that I can't do it, is there any better solution? Thank you!
I would like to ask how to use XML tags to achieve this effect in the report type, because XML tags do not seem to support the combination of multiple conditions, because I do not want all these parameters to be null; Or are there other good ways and suggestions? thanks gerd <if> <exp1>#Parameter1#</exp1> <op>is null</op> AND <exp2>#Parameter2#</exp2> <op>is null</op> AND <exp3>#Parameter3#</exp3> <op>is null</op> AND <exp4>#Parameter4#</exp4> <op>is null</op> AND <exp5>#Parameter5#</exp5> <op>is...
Now ART replaces non-English strings with underscores in the exported file name. May I ask which file I need to modify to avoid non-English characters being replaced by underscores? Is there any way to change this? Thank you, looking forward to reply!
There are instructions in the manual, you can refer to: Dates You can substitute the current date by using the expression f[date]f. This will output the current date in yyyy-MM-dd format e.g. 2017-11-10. You can use the expression f[datetime]f to substitute the current date and time in yyyy-MM-dd HH:mm:ss.SSS format e.g. 2017-11-10 11:25:21.045. Both date and datetime field expressions can also specify a different date other that "now" and additionaly specify the output format, output format locale,...
I hope that after the Jxls report is run, the output file can use a custom localized file name. Can this be achieved? THX!
Can you use aliases for mail addresses in scheduled tasks? eg: Jack Bill_Gates@microsoft.com;Mike mike@yahoo.com THX!!!
No, there will be multiple accounts
I added a Double parameter to represent the exchange rate, and I set the default exchange rate value, the user needs to enter the exchange rate value when executing the query; Now there is a question, because the exchange rate will change every month or every week, can we use the exchange rate entered by the user last time by default? Now I modify the default value of the exchange rate parameter every time. I would like to ask whether the exchange rate can use the value entered by the user last time...
Ver6.17 , An error occurs if the LOV dynamic data source is used in the report An error occurred java.lang.RuntimeException: Datasource not found at art.runreport.ReportRunner.execute(ReportRunner.java:1463) at art.runreport.ReportRunner.getLovValuesAsObjects(ReportRunner.java:1790) at art.runreport.ReportRunner.getLovValuesAsObjects(ReportRunner.java:1760) at art.runreport.ParameterProcessor.setLovValues(ParameterProcessor.java:943) at art.runreport.ParameterProcessor.process(ParameterProcessor.java:394)...
Hi: Where can I change the default number of rows displayed in Tabular report?
That's this excel
Can I use excel option in the top left corner of the HtmlDataTable report results page?
The column filter on the report run page does not work?
It would be nice to have a fixed first row!
Yes, because in the database, it's the same column in the same table, but with different values, different categories; For example, for "work order ", there are many different categories, such as" packaging order ", "assembly order "; So I want the parameter label to be displayed as "Packing order" in the "Packing Order" and "Assembly Order" in the "Assembly Order ". Only in this way can the user understand what type of query criteria should be entered in the report query. I don't know if you can...
There are already 11 reports in use, and there may be more in the future
Hi, Many reports share the same parameter, but the parameter labels do not want to be the same, Is the label of the same parameter displayed in different text in different reports? Thanks
Many reports share the same parameter, but the parameter labels do not want to be the same, Is the label of the same parameter displayed in different text in different reports?