Creating a bar/line chart

Applications Grid / Reports
#1

Is there an simple example of how to create a bar/line chart report? I cannot seem to find any info.

Regards,
Scott.

#2

Re: Creating a bar/line chart

To create a chart, first, it is necessary to use a “group by” option in the Grid. Then you can configurate the chart accessing the “summary” options.

V?tor Jamil

#3

Re: Creating a bar/line chart

I have problems creating a chart from dynamically calculated data eg

SELECT
count(MemberID), year(current_date)-year(BirthDate) as Age
FROM
xxxxx where year(BirthDate) >0 group by year(current_date)-year(BirthDate)

if I use Age as the label column the chart doesn’t show, however if I use a physical column the chart shows. Ho can I go around this?

#4

Re: Creating a bar/line chart

Don’t know how to solve this in SC. I myself had some trouble with calculated functions (round) in a grid. There seem to be some limitations.
What about solving it in the database?

CREATE VIEW my_view AS SELECT count(MemberID) as Members, year(current_date)-year(BirthDate) as Age
FROM
xxxxx where year(BirthDate) >0 group by year(current_date)-year(BirthDate)

#5

Re: Creating a bar/line chart

Thanks Freezer, a view solved my problems