New Topic

Community Topic Question Report Builder

Group permittion

Eliran Jerby shared this question ago

Answered

How can I permit column group in my report?

I can't see any option for that at the column's settings.

Attached print screen

Regards,

Eliran

Files:

The same question

Replies (5)

Guest ●

Hi Eliran,

Thanks for sending in the question. Can you clarify what type of field the 'DriverRef' field is in your report? The reason I ask is because you cannot group a field if it is a calculated field.

Can you verify whether or not this field is a calculated field or not? I look forward to hearing back.

Kind Regards,

Dustin

Reply URL

Eliran Jerby ●

Hi Dustin

Thanks for the quick answer.

None of the fields are calculated,

Attached print screen of the query and table's fields

Regards,

Eliran

Files:

Reply URL

Guest ●

Hi Eliran,

Thanks for clarifying! Unfortunately you cannot group

free hand SQL derived fields. You can only group your fields if you

build your report via the drag and drop report builder.

This is outlined in the below forum post:

https://www.yellowfinbi.com/YFForum-How-Do-I-add-Groups-in-a-Report-that-uses-freehand-SQL-?thread=179178

Can you take a look at the above article and let me know if this clears things up? I look forward to hearing back.

Kind Regards,

Dustin

Reply URL

Eliran Jerby ●

Thanks Dustin

The attached link is unavailable

Files:

Reply URL

Guest ●

Hi Eliran,

Can you try again? We had a website outage last week. Let me know if you are still running into troubles.

Kind Regards,

Dustin

Reply URL