Home » Developer & Programmer » Reports & Discoverer » Formula Col
Formula Col [message #262195] Sat, 25 August 2007 00:02 Go to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi,
I have a requirement where in my Policy Modifiers are
Basic
Reissue
Refinance
Mortgage Modification
Construction Loan Rates
Endorsements

This is a matrix report I need To select the first five as a Matrix col this i am doing by selecting values from Industry_attribute

and the Endorsements I am doing it from Attribute1

I need to display Endorsements total at the end of report
But when i try putting a formula col in the report level and try to display it in the frame level of report it gives Frequency error

Any solutions with a little detail explanation

praveen


Re: Formula Col [message #262261 is a reply to message #262195] Sat, 25 August 2007 13:27 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Where did you create this formula column? In query's group? How about moving it out?

Or, if using wizard, it offers which columns you'd like to sum; did you try to select this particular column and see what happens?
Re: Formula Col [message #262401 is a reply to message #262261] Sun, 26 August 2007 23:43 Go to previous messageGo to next message
pravin9
Messages: 42
Registered: May 2007
Member
Hi,
But i dont want endorsement policy modifier in my query i need to display data without endorsement col in the horizontal way,
so i cant include this col data.I tried using it out of the group but it gives frequency error which is expected.
Re: Formula Col [message #262441 is a reply to message #262401] Mon, 27 August 2007 01:02 Go to previous message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try Report Builder's Wizard?

(Example image)

/forum/fa/2954/0/
Previous Topic: Tab Order in Parameter Form
Next Topic: To change display order of coloumn in report
Goto Forum:
  


Current Time: Thu Jul 04 12:20:22 CDT 2024