Adobe Community : All Content - All Communities

Stop printing of Blank Pages

forums_noreply@adobe.com — Fri, 11 Jul 2014 16:02:09 GMT

Each section on a Bill is checked for a specific condition in the 'Print When Condition'. This can cause blank pages to be created and printed, it there a way to not print blank pages?

I use CF10

Print When with two conditions

forums_noreply@adobe.com — Wed, 09 Jul 2014 19:15:47 GMT

I only want to print a page if two conditions are met. On each section I am using the following Print When Condition:

DateFormat(query.asofdate, "mm/dd/yyyy") NEQ DateFormat(calc.AmtDate, "mm/dd/yyyy") AND LSNumberFormat((query.bal + calc.anticipated), "_.__") LTE LSNumberFormat(25.00, "_.__").

The date check works great by itself and the amount check works great by itself but I can't get them to work together. Any ideas?

I am using CF10.

Save Data in Report to Use later

forums_noreply@adobe.com — Wed, 11 Jun 2014 15:06:41 GMT

I have several names to report I need to combine data from several records of the same type with different codes. Not all names have the same codes. I want to report the data on one line. Is there a way to save date to be used later in the report?

For Example:

Name Code Start Date Code Transfer Date Code Promote Date

Sue	SD	01/15/2000	TD	01/15/2005
Mitch	SD	01/15/2004
Sam	SD	01/15/2003			PD	01/15/2006

Stretch with overflow

forums_noreply@adobe.com — Thu, 17 Apr 2014 14:25:58 GMT

I have a CF 10 report with an Excel Output format. One of my columns needs to stretch. When I set the Fromatting "Stretch with Over to True" and the Print Control "Position Type" to Floating and the "Stretch Type to Relative to Band Height" for all the fields on my detail I get an exxtra line in my excel output when there is an overflow condition. I am including an image of the output.

What am I missing?

Thanks

cfreturn variable return separate fields

forums_noreply@adobe.com — Mon, 14 Apr 2014 20:10:38 GMT

I am creating a report in CF 10 report builder. I have a function that returns two separate fields in one variable I need to have the two fields returned separately, my output is an excel worksheet. Any advise will be greatly appreciated.

Report Builder Query Concating two fields

forums_noreply@adobe.com — Thu, 13 Feb 2014 19:42:32 GMT

I have two fields that I need to concatenate after I have performed a calcutation. I am taking a school year and subtracting 5 years.

School Year = 201314. I want the result to be 200809 so that I can select any courses that have a School Year greater than 200809.

I have tried many variations of:

LEFT(sysvar.cur_schyr,4) - 5 + RIGHT(sysvar.cur_schyr,2) - 5 as "B4SchYr" this adds 2009 + 08 and gives me 2017 when I want 200809 returned. How do I treat the numeric strings as characters?

Thanks.

Reporting: If statement and Sum statement

forums_noreply@adobe.com — Mon, 23 Sep 2013 14:48:27 GMT

I have an instructors schedule that shows each time a course is taught for example:

Course Credits Day

AAA123 3 Mon.

Wed.

The Credit only shows the first time (Print When Condition: calc.counter IS 1). I need to total the credits for each course when I use the Sum(credits) function it totals for each line (the above ezample would show a total of 6), I only want to sum if calc.counter EQ 1

Expression Builder

forums_noreply@adobe.com — Thu, 07 Mar 2013 16:19:47 GMT

I created a report function to find and return a graduation date. I only need to execute the function once per person.

The query returns all colleges a person attended, I only want to report the colleges they attended before their graduation date (or current date if they have not graduated).

I tried to create an expression in the "Print When Condition" CF did not like what I tried. I don't believe I'm referencing the return varible correctly.

We are on CF 9 and I have already spent too much time on this project.

Any and all help will be appreciated.

DateTime Parameter being passed maybe blank

forums_noreply@adobe.com — Wed, 13 Feb 2013 18:28:59 GMT

I have a Transcript report and I only want to print any other institude name and credit earned (transfer information) that occurred before the student graduated. I am selecting only the institudes that have a 'receive date' prior to the 'grad date'. This works great on the students that have graduated. If they haven't graduated the 'grad date' is empty and I error out when comparing it to the receive date. Here is the query that calls the transfer information:

select

nmedu.soc_sec, nmedu.credits, nmedu.date_rec, institut.inst_txt, institut.homeinst, nmedu.graduated

from nmedu, institut

where institut.inst_cod = nmedu.inst_cod

and institut.homeinst = 0

and nmedu.credits <> 0

and nmedu.soc_sec = '#param.socsec#'

and nmedu.date_rec = '#param.graddate1#'

ORDER BY inst_txt

When the student has not graduated I get the following error message:

Incompatible java.lang.String value assigned to parameter GradDate1 in the ColdFusionReport dataset.

If they have graduated it works great.

I'm running on CF 9.

Changing value of Param

forums_noreply@adobe.com — Fri, 22 Feb 2013 18:00:42 GMT

I have a report that passes a date (time stamp) to a subreport. Sometimes the date being passed is null (or an empty string) and the report . When this happens get an "Incompatible java.lang.String value assigned to parameter GradDate1 in the ColdFusionReport dataset.". I want to change the value of the Param being passed to current date. Where and How can I change the date in the parama being passed. I've tried many things (functions, in the query, etc) and can't get anything to work. We are on CF 9. Please help!

Calculate age in a function

forums_noreply@adobe.com — Tue, 16 Mar 2010 13:00:55 GMT

I am trying to calculate and return the age of a person. My code is:

I get a "If the expression is a string, ensure that it is within quotes. Error: report.ModStat(query.soc_sec)

is not a valid ColdFusion expression." error message when I try to run the report.

Any help would be appreciated.

Thanks.

Counts needed for data in random sequence

forums_noreply@adobe.com — Mon, 03 Aug 2009 16:31:44 GMT

I have a table that is grouped by entry date, agency, last name. I need to know how many records within entry date & agency have a disposition of "Dep', how many have a disposition of "Can" etc,

Thank you for any help you can give.

inner join & outer join in one query

forums_noreply@adobe.com — Wed, 22 Jul 2009 18:35:35 GMT

I have 11 tables, 10 of the tables need will always have a match on id, the 11th table may or my not have a match. I need to print info from the 10 tables with a matching id and information from the 11th table if a record is found.

Please help.

Function in Report Builder

forums_noreply@adobe.com — Thu, 11 Jun 2009 14:58:30 GMT

I have written a function in one of my reports. I get the error message "Element ST_ADDR is undefined in ADDRESS." when I try to run the report. My funtion looks like:

<cfquery name="qmailbox" dbtype="ODBC" datasource='#session.ds#'>
SELECT address.st_addr, address.type
FROM address
WHERE address.type = 'Campus' and address.soc_sec = '#arguments.ss#'
</cfquery>

It is possible that there might not be a address.type of 'Campus' for every record passed to this function, that hy I check recordcount. I am open to any suggestions you have.

Thanks

Format a numeric field in Report Builder for Excel Output

forums_noreply@adobe.com — Thu, 28 May 2009 14:38:58 GMT

I am trying to format a field as 9.99. Sometimes this is a whole number but I still need the decimals to print. I tried using LSNumberFormat(query.sem_gpa, "_.00"), NumberFormat(query.sem_gpa, "0.00") and DecimalFormat(sem_gpa). It appears to ignore the mask.

Any help would be greatly appreciated.

Report Order

forums_noreply@adobe.com — Fri, 12 Sep 2008 18:29:56 GMT

I have inherited a report that prints applicant information in last name sequence. I added a function to retrieve counselor information from another table not in the original report.

We want the report to print in counselor sequence then applicant last name. Is there a way to do this?
Thanks for any and all help.

Sort using a function

forums_noreply@adobe.com — Tue, 27 May 2008 14:29:01 GMT

I added a function to a stored procedure (the procedure could not be changed) to retrieve agency information. I would like the report to print in agency sequence. How can I get this done?
Thanks

Using function to sort

forums_noreply@adobe.com — Mon, 14 Apr 2008 18:14:12 GMT

I added a function to a report that used a stored procedure. The function queries a table that was not in the stored procedure. Can I sort using this function? If not, how can I get the report in the correct order using a field from the new table?
Thanks

Add table to a report query

forums_noreply@adobe.com — Thu, 20 Dec 2007 16:32:42 GMT

I need to add a table to the existing report query. I am very new to cold fusion report builder and am looking for help with the query and recommendations for a good self study book. Here is the query:
<cfquery name="no_record" datasource="#session.ds#">
SELECT dispos
FROM rpt_disp
WHERE dispos = 'no_record'
and token = '#session.token#'
</cfquery>
<CFIF no_record.RecordCount EQ 0>
<cfquery name="CFReportDataQuery" datasource="#session.ds#">
appListRB '#session.token#','*', '0'
</cfquery>
<cfelse>
<cfquery name="CFReportDataQuery" datasource="#session.ds#">
appListRB '#session.token#','*', '1'
</cfquery>
</cfif>

I need to add an table that would link by soc_sec and return 2 fields from the new table.
Thanks for any help you can offer.