Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
EddieLotter
Advocate
EddieLotter
Advocate
Activity
‎Sep 16, 2014
11:08 AM
I believe the following link will help you: http://helpx.adobe.com/coldfusion/kb/coldfusion-report-builder-charts-dynamic.html
... View more
‎Sep 08, 2014
01:39 PM
As I said in my first reply, you want to use your SQL query to prevent data from reaching your report that you don't want to print. That way you won't have to decide whether or not to print something in the definition of the report itself. In other words, the report can assume that any data it receives are data that must be printed. Remove the grouping from your query and add a condition that will only return records where the transaction amount is at least $20. Something like this:
SELECT tmptract.soc_sec, tmptract.p_bal, tmptract.bal, tmptract.semester, tmptract.sch_yr, tmptract.due_date, tmptract.asofdate, name.last_name, name.first_name, name.mi, address.st_addr, address.add_addr, address.add_add2, address.city, address.state, address.zip, address.add_rid, address.salutation, sysvar.title, sysvar.schaddr1, sysvar.schaddr2, sysvar.schaddr3,'' as invoice_no, transact_prebill.ref_id, transact_prebill.amt_1, transact_prebill.offered, transact_prebill.loan_fees, transact_prebill.date, '' as check_no, transact_prebill.transact_rid, tcodes.act_code, 2 as bill_type
FROM tmptract, name, address, transact_prebill, tcodes, sysvar
WHERE tmptract.soc_sec = name.soc_sec
AND address.soc_sec = name.soc_sec
AND transact_prebill.soc_sec = tmptract.soc_sec
AND tcodes.tcodes = transact_prebill.tcodes
AND sysvar.school_id <> tmptract.soc_sec
AND address.labels2 = 1
AND tmptract.token = '#session.token#'
AND tcodes.inc_bill = 1
AND transact_prebill.posted = 0
AND transact_prebill.exclude_from_bill = 0
AND transact_prebill.accept not in('n','v')
AND transact_prebill.date <= tmptract.asofdate
AND transact_prebill.semester = tmptract.semester
AND transact_prebill.sch_yr = tmptract.sch_yr
WHERE NOT tmptract.soc_sec IN ( SELECT transact_prebill.soc_sec FROM transact_prebill
GROUP BY transact_prebill.soc_sec HAVING (SUM(transact_prebill.amt_1) < 20) )
ORDER BY name.last_name, name.first_name, name.mi, tmptract.soc_sec,address.add_rid, bill_type desc, act_code, transact_prebill.date
Your SQL engine syntax may differ, but you can adjust it as necessary. You will also need to add your other criteria to the sub-query, for "posted" and "exclude_from_bill" etc.
... View more
‎Sep 08, 2014
12:50 PM
Okay, so your report shows quite a lot of detail. Why are you summing amt_1 in your SQL query? Surely you want to show the actual amount of each transaction next to the transaction and have a total at the bottom of the transactions.
... View more
‎Sep 08, 2014
10:11 AM
Have you tried, for example:
if ( desiredCompletionDate != "" )
{
qryForExcel["Desired Completion Date"][qryForExcel.recordCount] = desiredCompletionDate;
}
... View more
‎Sep 08, 2014
10:00 AM
It depends on what fields you need to show in the report. Do all the fields in your select clause get printed in the report?
... View more
‎Sep 03, 2014
09:34 AM
You're welcome. Happy coding.
... View more
‎Sep 03, 2014
09:29 AM
1 Upvote
Yes. Get the Developer edition here.
... View more
‎Sep 02, 2014
09:23 AM
Change format="PDF" to format="#VariableName#" where VariableName contains the text "PDF" or "Excel".
... View more
‎Aug 21, 2014
03:29 PM
If you evaluate your variables, what do they contain?
... View more
‎Aug 12, 2014
09:29 AM
You need to put some alert statements into your script to ensure that (a) execution is reaching that part of the script and (b) the script is dealing with expected values. For example: alert(document.getElementById('listofids')); var allArray = document.getElementById('listofids').value.split(","); alert(allArray[0]); and: ProdRev = document.getElementById('Mfg_Spec_Prod_Approval_Rev'+allArray); alert(ProdRev);
... View more
‎Aug 12, 2014
08:19 AM
In your original script, remove the two lines:
ProdRevValue = ProdRev[ProdRev.selectedIndex].value;
ProdInitValue = ProdInit[ProdInit.selectedIndex].value;
and change your two conditions to:
if(ProdInit.selectedIndex != 0 && ProdRev.selectedIndex == 0) {
...
}
else if(ProdRev.selectedIndex != 0 && ProdInit.selectedIndex == 0) {
...
}
I'm assuming your "listofids" is providing the expected values.
... View more
‎Aug 11, 2014
09:20 AM
This isn't a ColdFusion issue, however the solution is to validate with "ProdRev.selectedIndex == 0". In other words, check the value of selectedIndex.
... View more
‎Jul 31, 2014
07:46 AM
1 Upvote
If you want to write the document to a file, your cfdocument tag must include the filename attribute. Did you perhaps just leave that out of the example you posted?
... View more
‎Jul 28, 2014
10:14 AM
I don't use CF11, but some troubleshooting tips: Try hard coding the URL of the cflocation tag and test it. If it works then assign the URL you are constructing to a string and dump that string so that you can verify that it is the URL you expect it to be.
... View more
‎Jul 24, 2014
10:49 AM
Some Web sites will not serve images and/or pages without an expected "referrer" HTTP header. Are you trying to write a script to automatically download all images in a Web page?
... View more
‎Jul 14, 2014
06:11 AM
As I mentioned in your other thread about this scenario, if you prevent your report query from returning records that meet those conditions then you don't have to worry about handling them in the report itself.
... View more
‎Jul 14, 2014
06:08 AM
Cozmo2 wrote:
That fixed the problem Thanks!
Is there anyway I can apply this to the whole page and not have to add it to every sections 'Print When Condition'?
One way would be to exclude records that meet those conditions. That way you would not need to take them into account in your report.
... View more
‎Jul 10, 2014
01:45 PM
If the field types are explicit, then you don't need to format them as strings before comparing them. What happens if you try the following expression?: ( (query.asofdate NEQ calc.AmtDate) AND (query.bal + calc.anticipated LTE 25.00) )
... View more
‎Jun 25, 2014
10:06 AM
1 Upvote
I think I now have a better idea of what you are trying to accomplish. You don't need a sub-report to get each person's dates on the same line. It is best to do that in your query, for example: select table_name.UserName, dtFafsa.FafsaDate, dtLetterSent.LetterSentDate, dtLetterReceived.LetterReceivedDate from table_name left outer join (select userID, FafsaDate from table_name as table_name_fafsa where appchk_cod = 'FF') as dtFafsa on table_name.userID = dtFafsa.userID left outer join (select userID, LetterSentDate from table_name as table_name_LetterSent where appchk_cod = 'AS') as dtLetterSent on table_name.userID = dtLetterSent.userID left outer join (select userID, LetterReceivedDate from table_name as table_name_LetterReceived where appchk_cod = 'AR') as dtLetterReceived on table_name.userID = dtLetterReceived.userID This is obviously not syntax checked, but it illustrates the concept. Each derived table returns the date of each code. You will need a derived table for every code you want to report on.
... View more
‎Jun 12, 2014
07:22 AM
You're welcome.
... View more
‎Jun 11, 2014
12:55 PM
1 Upvote
Cozmo2 wrote:
Using the three records above I want the report to print (I'm using the Name Group Footer):
From this reply it seems that by "one line" you mean "one report band". The best way to show multiple records in a non-detail report band (like your Name Group Footer) is to use a sub-report.
... View more
‎Jun 11, 2014
11:29 AM
Okay, that limits your options somewhat. Now, your example isn't clear what you want to do. What data in the three different records do you want to display on one line in the report?
... View more
‎Jun 11, 2014
08:32 AM
Firstly, what are you using to create the report? cfreport, cfdocument or what?
... View more
‎Jun 03, 2014
08:56 AM
2 Upvotes
There are no parameters in the cfSpreadsheet tag to choose specific columns, however you can use a query of queries (About Query of Queries - ColdFusion English Documentation - Adobe Learning Resources) to get a query object with a subset of columns to pass to the tag.
... View more
‎May 28, 2014
02:25 PM
The document servers are available now. Have a look at xmlParse: Adobe ColdFusion 9 * XmlParse
... View more
‎May 27, 2014
08:26 AM
Nice. Thanks for posting your solution.
... View more
‎May 27, 2014
07:46 AM
cam-chris wrote:
In ColdFusion Report Builder, is there a way to shrink text to fit a particular area? (as opposed to stretching with overflow)
Unfortunately not. The "Stretch with overflow" property is a grow-only setting. There is no equivalent property to do the opposite. What scenario are you trying to deal with? There may be other solutions.
... View more
‎May 27, 2014
07:41 AM
iccsi wrote:
I have a comments field from query result for report data source.
Because it is a navrchar(max) field, the result can be shorter or longer based on the data users entered.
I would like to have the text field and details band growth base on the data.
Are there any property to change it at run time or I need write UDF to do the task?
Make the comment field's height equal to one line's height, then set its "Stretch with Overflow" property to "True". It is very important to set the "Position Type" property to "Floating" for every object below the comments field so that if the comments field grows then the floating objects will be moved down accordingly. I recommend that you create a small test report to play around with the settings until you get a feel for how it all works.
... View more
‎May 21, 2014
08:48 AM
Gimmejazz56 wrote:
I found MS html help version 1.4. When attempting to install it, the installer indicated that I already had the newest version installed. Yet, CFRB continues to indicate that "MS Html Help is not installed on this PC". I am running on Win 7 64 bit platform. Any support would be greatly appreciated.
Hmm, that is strange. If there is no shortcut to the help file in the Windows menu, use the Windows Explorer to navigate to the folder where CFRB is installed, (default is "C:\Program Files (x86)\Adobe\ColdFusion Report Builder") and double click on the "CFReportBuilder.chm" file. If it loads successfully, then create a shortcut to it in a location that is convenient for you.
... View more
‎Apr 29, 2014
09:14 AM
If I understand you correctly, this should work: <cfloop index="i" from="1" to="5"> <cfset question = GetEmployeeCSEDepts["csedept_question" & i][GetEmployeeCSEDepts.CurrentRow]> <cfif question neq ""> <tr> <td valign="top"> <select name="sltRating#i#" size="1"> <option value="">-- Select Rating --</option> <option value="5">Exceptional</option> <option value="4">Exceeds Standards</option> <option value="3">Successful</option> <option value="2">Needs Improvement</option> <option value="1">Unsatisfactory</option> <option value="0">N/A</option> </select> </td> <td valign="top">#question#</td> </tr> </cfif> </cfloop>
... View more
Copyright © 2024 Adobe. All rights reserved.
AdChoices