need suggestions on formula

[Former Member]

Hello All,

Can someone pls tell me if we can use group by in creating a formula.

Let me explain more clearly.

I have a column A and each field in this column s a sum of 10 things for eg a,b,c,d,e,f,g,h,i,j and group by date

A= abcdefghi+j group by date

like A i have many columns in my report, so if someone can suggest me on A , i can do rest of th columns.

Appreciate your suggestions

[Former Member · Accepted solution]

Can someone pls tell me if we can use group by in creating a formula.

Let me explain more clearly.

I have a column A and each field in this column s a sum of 10 things for eg a,b,c,d,e,f,g,h,i,j and group by date

A= abcdefghi+j group by date

like A i have many columns in my report, so if someone can suggest me on A , i can do rest of th columns.

Appreciate your suggestions

If I understand you correctly you want each Column A with 10 fields a,b,c,d group by a date

create a formula < If db.Field = a,b,c,d then db.field else ' ' > (Create a formula for each column)

Create another formula called GroupByDate < if db.Date in [1/01/2008 to 12/31/2008] then 'Calender 2008' else 'Other'

With this formula go to Report Group Expert choose Date group, press options,choose specified order create a group name " Group Dates" and then choose is = GroupByDate Formula

Hope this helps

Shirley

[Former Member]

Hai Amreek,

Use Subreport for each Columns. And do grouping inside that.

With Regards,

Salah

[Former Member]

Thanks Salah, this is what I was thinking but I was looking for some other alternative as If I create subreports I will end up creating 25-30 subreports .

Can anyone suggest me of some other alternative?

Thanks