Report Builder

[rcepek]

:confused; Okay hopefully somebodey can help me. First one would be the
simplest. Does anyone know of where to find some detailed expamples of
Reports for the Report builder? the one that MM ships suck as they don't
go into a lot of detail on the how and why's. 2. ) here is my problem I have
a database that returns numbers. so a field called FRT_CHG_CD would return
either 0,1 or 2 as string values. I then want to do a simple cfif statement
in report builder that would say if 1 than 'paid' if 2 than 'collect'
etc. .... I tried writng a simple Report function to do this but the report
returns somepthing to the effect of cfPackLists2ecfr2015033223$funcP
OINT@17455ed So could someone tell me or post a sample app that I could study
to figure out how to make it work? I have figured that either I'm missing
something so simple or it is difficult.

<CFIF query.FRT_CHG_CD NEQ "0">
<CFSET FREIGHT="PAID">
<CFELSE>
<CFIF query.FRT_CHG_CD EQ "1">
<CFSET FREIGHT="PREPAY AND COLLECT">
<CFELSE>
<CFIF query.FRT_CHG_CD EQ "2">
<CFSET FREIGHT="COLLECT">
</CFIF>
</CFIF>
</CFIF>
<cfreturn freight>

[COLD JOE]

Are you using CF MX 7?

[rcepek]

Yeah Currently running CF MX 7

[jimpurple]

I have been attempting to solve this myself. I have come up with a work around
that I doubt is the proper solution but I know it does work and is what I am
using for now.

I have made three fields. All that sit on top of each other in the report.
Then in the expression builder I have set each one to respond if they are the
proper number. So for example here would be for yours you would have:

IIf(query.FRT_CHG_CD is "1", de("Paid"), de(" "))

Then in a seperate field
IIf(query.FRT_CHG_CD is "2", de("Collect"), de(" "))

That will print Paid if the FRT_CHG_CD is 1 if not it prints a blank space.
In the second field it would print collect if it was 2. Obviously it would be
great to have an else statement but that is the best I can come up with.

[rcepek]

Thanks for that idea, I tried somethng similar to that, I tried to nest
multiple IIF statements together but it didn't work. I was really excited
about finally having a reason to dump Crystal Reports, But I think CF might not
be there yet. This is such a simple problem that I thought MM would be able to
correct. Ihope someone frm the forums *hint* can help with this please!

[Dean Harmon]

Where do you have the report function defined? and how are you accessing it?

First, tag syntax is not supported in the report fields directly. It has to
be function calls or anything that would be able to be Evaluated by
ColdFusion (ie in the #MyStuffHere()# syntax or if you used the Evalutate
function. Everything in an expression essentially has an implicit #..#
wrapper around it. If you used the Report Function definition part of the
ReportBuilder, make sure that you correctly specified the return value at
the bottom. As for usage of said function, you can use it like this in a
field for example: report.MyFunction(ParamA, ParamB)

Does that help or answer the question?

Dean

"rcepek" <rcepek@resorg.com> wrote in message
news:cv10mg$6eb$1@forums.macromedia.com...

> Thanks for that idea, I tried somethng similar to that, I tried to nest
> multiple IIF statements together but it didn't work. I was really excited
> about finally having a reason to dump Crystal Reports, But I think CF

might not

> be there yet. This is such a simple problem that I thought MM would be

able to

> correct. Ihope someone frm the forums *hint* can help with this please!
>

[rcepek]

I have it defined in the report function editor. with a function name of
'point', then in the report I call it with an expression called.
'report.point' below is the exact code that I'm calling from the function
called point.

<CFIF #query.FRT_CHG_CD# EQ "0">
<CFSET FREIGHT="PAID">
<CFELSE>
<CFIF #query.FRT_CHG_CD# EQ "1">
<CFSET FREIGHT="PREPAY AND COLLECT">
<CFELSE>
<CFIF #query.FRT_CHG_CD# EQ "2">
<CFSET FREIGHT="COLLECT">
</CFIF>
</CFIF>
</CFIF>
<cfreturn freight>

[Harmeister]

The news interface doesn't seem to be submitting what I posted, so here goes
again via the web. The basic modification I made was to pass in the
query.FRT_CHG_CD to the function instead of trying to use it directly. My
function is as follows: <cfargument name='FRT_CHG_CD' required='yes'/> <CFIF
#arguments.FRT_CHG_CD# EQ '0'> <CFSET FREIGHT='PAID'> <CFELSE> <CFIF
#arguments.FRT_CHG_CD# EQ '1'> <CFSET FREIGHT='PREPAY AND COLLECT'>
<CFELSE> <CFIF #arguments.FRT_CHG_CD# EQ '2'> <CFSET
FREIGHT='COLLECT'> </CFIF> </CFIF> </CFIF> <cfreturn freight>
and the expression of my field is like this: report.point(query.myFieldNameHere)

[Harmeister]

of course the newsreader one comes through when I post the one via the web. :)

[sterlingdking]

The Report Builder only runs on Windows, so, will it work with full functionality with Cold Fusion 7 for Linux?:)

[BenForta]

The Report Builder itself is a Windows application (initially), but reports created with it can be processed by ColdFusion MX7 on any platform (including Linux).

[sheridanbman]

Does anyone know if it is possible to do an IF statement to change the font color if the value is less than "0" in coldfusion Report Builder?

Thanks,
Brian