Search found 46 matches

by amamyoj
11 Dec 2023, 18:17
Forum: Discussion
Topic: Report Designer Chart
Replies: 15
Views: 370

Report Designer Chart

Hi,

Is there a way I can fix the name in the Report Designer Chart? The Location names are too long and when I create a report, the names of the location overlaps.

PLease see screenshot below for reference. THanks!
by amamyoj
11 Dec 2023, 17:49
Forum: Discussion
Topic: SOLVED - Report Designer Filter
Replies: 9
Views: 3392

Re: Report Designer Filter

This worked! However, I accidentally deleted the Global List for the Hazard Status and when I try to configure it again using the screenshot you provided it doesn't work now :( Is there an explanation as to why it wont work? Attached are screenshots below of the Field Choices for the Hazard Status, ...
by amamyoj
07 Dec 2023, 11:17
Forum: Discussion
Topic: SOLVED - Report Designer Filter
Replies: 9
Views: 3392

Re: Report Designer Filter

How can i use the entity for the global list?
by amamyoj
05 Dec 2023, 10:12
Forum: Discussion
Topic: SOLVED - Report Designer Filter
Replies: 9
Views: 3392

Re: Report Designer Filter

Hi, I tried creating a global filter for the hazard status. but it is getting the ID from the global list. is it possible that i can configure the ID of the status to be the same as in the entity? IN the screenshot below, you will see that in the reports, the ID 7 of the CLosed Hazard Status is bein...
by amamyoj
04 Dec 2023, 19:04
Forum: Suggestions
Topic: New Filter Options in Report Designer
Replies: 14
Views: 4173

Re: New Filter Options in Report Designer

I tried toggling on the Filter by Entity 2 and selected the Leading INdicator Entity, and in the dropdown list it is showing the "HEading COlumn" for the Leading Indicator Entity which is the Location. Is it possible to choose a column in the selected entity other than the heading column? ...
by amamyoj
04 Dec 2023, 18:31
Forum: Discussion
Topic: SOLVED - Report Designer Filter
Replies: 9
Views: 3392

SOLVED - Report Designer Filter

HI Sergey, Is it possible to use the Filters Panel "Filter by Entity 3" but the column that will be used is not the Heading column of the Entity selected? For example, I have here the Entity Hazard Reports, its Heading Column is "Hazard Title". I will be using the "Hazard Re...
by amamyoj
04 Dec 2023, 18:01
Forum: Discussion
Topic: Group Records/Data using mySQL query
Replies: 4
Views: 1398

Re: Group Records/Data using mySQL query

Thank you Serygey!
by amamyoj
01 Dec 2023, 20:41
Forum: Suggestions
Topic: New Filter Options in Report Designer
Replies: 14
Views: 4173

Re: New Filter Options in Report Designer

Hi Sergey, Is it possible to add another report filter but in the same entity of the Filter by Entity 1? Like in the picture below, I toggled on the Filter by Entity 1 using the "Leading Indicator" Entity and "Location" column/field as filter. I would want to add another filter, ...
by amamyoj
28 Nov 2023, 07:45
Forum: Discussion
Topic: Date Filter in Reports not working
Replies: 3
Views: 1016

Re: Date Filter in Reports not working

The Date Filter in the Entity listing is not working because the date field when saved into the database is in bigint data type. I s there a way we can convert the date filter to bigint to match the date that is in the database?
by amamyoj
26 Nov 2023, 17:29
Forum: Discussion
Topic: Date Filter in Reports not working
Replies: 3
Views: 1016

Re: Date Filter in Reports not working

The Date Filter in the report is not working because the data type of the date in the database is bigint. Is there a way where I can manipulate the date filter or a query window where I can match the date filter vs the date stored in the db?