Report question - SOLVED

[modelaford]

I've downloaded and installed the report extension, and by and large it works like I expect, but I have one nagging problem. In Access, it is possible to create a field like this:

=([City] & ", " & [State] & " " & [Zip Code])

That allows for nice formatting and combination of table fields. Is this possible in the Sun Report tool? If so, where do I go for some examples/or syntax information/directions?

Thanks in advnace,
Paul

[Sliderule]

Paul:

You have asked about using the Base extension Sun Report Builder . . . and . . . the ability to 'create a field'.

There are a few ways to do this . . . including:

1. Use a Query to create the field you desired
   
2. Create a View that includes the field as you desire
   
3. Use the Report Function to create the computed field

I will show you an example of the third choice. Please note . . . the web site below:

• Wiki on Report Writer - Conditional Print Expression - http://wiki.services.openoffice.org/wiki/SUN_Report_Builder
  
• Wiki on Report Writer Functions - http://wiki.services.openoffice.org/wiki/Base/Reports/Functions

Now, in your example . . . from the Navigator ( press F5 or from the Menu: View -> Report Navigator ) I created from my database ( names slightly different than your example ) two functions ( note: no equal sign in the equation ) . . .

• [FIRST_NAME] & " " & [LAST_NAME]
  
• [CITY] & ", " & [ST] & " " & [ZIP]

These 'computed fields' were defined in the report as BOTH Formula and Initial value shown below:



I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title (edit button) if your issue has been fixed / resolved.

[modelaford]

Perfect - thanks... that is exactly what I was looking for. This is great stuff!!!!