Page 1 of 2
How can I get some data with expressions
Posted: Mon Aug 01, 2022 10:22 am
by ArnauINFR
Hi I have a chart with some projects with the time spent in each project. And I would like to recover only the 3 projects with more time spent i know there's an expression site to write it but i don't really know how to build that expression.
Also can I put a filter for, for example instead of only see 3 projects be able to see more like the 5 projects or something like that?
The DataSource is a simple .xls
Sheet1.Time and Sheet1.Project are the columns.
Thanks for help.
Re: How can I get some data with expressions
Posted: Mon Aug 01, 2022 12:15 pm
by Lech Kulikowski
Hello,
Please send us a sample report with test data for analysis.
Thank you.
Re: How can I get some data with expressions
Posted: Tue Aug 02, 2022 6:30 am
by ArnauINFR
Here you have a sample. Its just a Chart with some data.
The case is that I just wanna only see the top 3 Projects or if I can be able to choose how many projects see in order of how many hours have each project.
Re: How can I get some data with expressions
Posted: Tue Aug 02, 2022 8:41 am
by Lech Kulikowski
Hello,
You can use the Skip and Limit Rows option in the DataTransfromation for the Chart. It will work strat from 2022.3.4 build version.
Thank you.
Re: How can I get some data with expressions
Posted: Tue Aug 02, 2022 9:17 am
by ArnauINFR
Hi, thanks for reply. Right now I'm using 2022.3.3
Where can I find 2022.3.4 build files to be able to test it by myself.
The online demo uses 2022.3.2 and I guess won't work too.
I saw the error in my version that doesn't save well the results when I apply the skip and limit rows.
Re: How can I get some data with expressions
Posted: Tue Aug 02, 2022 9:20 am
by Lech Kulikowski
Hello,
The new build 2022.3.4 will be available within one or two days.
Thank you.
Re: How can I get some data with expressions
Posted: Tue Aug 02, 2022 9:29 am
by ArnauINFR
Ok, thank you for the information. Have a nice day!
Re: How can I get some data with expressions
Posted: Tue Aug 02, 2022 9:38 am
by Lech Kulikowski
Hello,
You are welcome.
Re: How can I get some data with expressions
Posted: Thu Aug 04, 2022 11:58 am
by ArnauINFR
Hi, I saw you just uploaded the 2022.3.4 build I just only changed the files that were modified on the git (all css, all scripts, helper, all adapters, english language).
But in my Designer seems like I'm using 2022.3.3 build. I uploaded all files to the server and I checked manually all files start with
Code: Select all
/*
Stimulsoft.Reports.JS
Version: 2022.3.4
Build date: 2022.08.02
License: https://www.stimulsoft.com/en/licensing/reports
*/
Shall I change something more to be able to work with the new build?
Re: How can I get some data with expressions
Posted: Fri Aug 05, 2022 9:55 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue.
Please send us a sample project that reproduces the issue for analysis.
Thank you.