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
‎Apr 15, 2014
02:52 PM
Cozmo2 wrote: 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. A function can only return a singe value. If you need two values you will need two functions or you will need to call the same function twice with a parameter indicating which value you want returned.
... View more
‎Apr 03, 2014
08:51 AM
scottnweber wrote: That sounds excellant Eddie. This is exactly what I was looking for. Thank you!! You're very welcome. Please mark this thread as answered for the benefit of other users.
... View more
‎Apr 03, 2014
08:48 AM
mrmichael1981 wrote: I just downloaded both the CF Report builder versions for 8 and 9 and there is no English language help file included. Does anyone know where or how I can download this? You need to install HTML Help. A simple search of the Microsoft Web site will provide you with a link to the Microsoft download page.
... View more
‎Apr 02, 2014
03:52 PM
scottnweber wrote: I am using Coldfusion Report Builder. If the value of a feild is zero, how can I hide it or show a blank. Keep in mind this field is a DollarFormat() field. When you click on the field in Report Builder, look near the bottom of the Properties window, in the "Print Control" section. You will see an entry labelled "Print When Condition". Put an expression next to it that returns true or false. For example, in your case, you would put something like the following: MyField neq 0 Where "MyField" is the name of your field. This expression will only allow the field to be printed when its value is not zero. Since you're targeting the value of the field you don't have to worry about the formatting that you used next to "Expression" in the "Data" section of the Properties window.
... View more
‎Feb 20, 2014
10:06 AM
You're welcome.
... View more
‎Feb 20, 2014
09:30 AM
Don't use an inner join: <cfquery name="getsignups" datasource="#application.dsn#"> select signups.courseTitle,signups.property,signups.calendardate,signups.com pany,signups.firstname,signups.lastname,signups.email,signups.phone,si gnups.userID,signups.signup_id,signups.rid,course_eval.userID,course_e val.id from signups LEFT OUTER JOIN course_eval ON signups.userID = course_eval.userID where signups.rid = #rid# </cfquery> <cfoutput> <cfloop query="getsignups"> <tr> <td>#rid# - #firstname# #lastname# | <a href="mailto:#email#">#email#</a></td><td>Ph: #phone#</td> <td width="24"><a href="showsignups.cfm?signup_id=#signup_id#&go=go" class="button">Remove</a></td> <cfif isdefined("id")> <td width="24"><a href="../../forms/surveys.cfm?userID=#userID#" class="button">Survey</a></td> </cfif> </tr> </cfloop> </cfoutput> Use: <cfif id neq ""> Message was edited by: Eddie Lotter (Typo)
... View more
‎Feb 19, 2014
02:07 PM
Use the string concatenation character (ampersand) instead of the plus sign.
... View more
‎Nov 21, 2013
03:55 PM
Theroyalfam wrote: I want an upload button for files in my form. Is this possible and if so how do I get it there? From page 976 of the Developer's Guide: <!--- This code creates a form with one field where the user enters the image file to upload. ---> <cfform action="makeThumbnail.cfm" method="post" enctype="multipart/form-data"> Please upload an image: <cfinput type="file" name="image"> <cfinput type="submit" value="Send Image" name="Submit"> </cfform>
... View more
‎Nov 21, 2013
03:47 PM
JayYaj wrote: However when I go to edit an entry, on the edit form, (if more then one checkbox were selected oringally), non of the checkboxes are checked. If only one checkbox was selected orinally, that checkbox is selected. You've given all the checkboxes the same name. Give them each a unique name and you will be able to access them individually. Current standards also require a unique ID, which can (but does not have to) be the same as the name. The "OR" characters in your code are not doing anything. You can safely delete them.
... View more
‎Nov 21, 2013
08:40 AM
I'm not sure why you're posting this in the Coldfusion Reporting forum. Hopefully an admin will move it to the appropriate forum.
... View more
‎Nov 06, 2013
12:48 PM
pjunkie wrote: I need to count the number of values selected in a form. I want to count the values circled in red. So the number I want in this case is 5. 5? I only see 3 circles. Try this: nCount = 0; For(sFormVar in Form) { If (Form[sFormVar] != "" ) nCount++; } WriteDump(var=nCount, label="Number of values provided");
... View more
‎Nov 05, 2013
02:44 PM
cam-chris wrote: Is there a method which would allow me to create a ColdFusion report with a 2 page layout? On the odd pages (the front side), this page would include the data relating to the report and on the even pages (the back side) would include a legend and would be the same on every even page. Yes, using the ColdFusion Report Builder. Add a dummy group (one that does not group on any field) and check its "Start New Page" and "Reprint Header on Each Page" checkboxes. Make the dummy group header the height of your page, minus the height of margins and other headers and footers. In the dummy group header property "Print when condition" put "calc.PAGE_NUMBER mod 2 eq 0" Now the header will print on every second page, leaving no room for the detail band to print on the same page. The detail band will print on alternate pages. Message was edited by: Eddie Lotter: Corrected a typo.
... View more
‎Nov 04, 2013
09:05 AM
iccsi wrote: I am looking for the hyperlink based on the data. For example, if the data is 100 then I want to the hyperlink www.myserver/100.cfm if data is 200 then I want to link to www.myserver.com/200.cfm You can use a report function to return the desired URL based on the data in your query. In other words, in the "Expression" property of your hyperlink report object, pass the query field to a function which then returns the URL as a string.
... View more
‎Nov 04, 2013
07:49 AM
iccsi wrote: I would like to have a control to have hyper link based on data source. I would like to know does Report Builder have any controls that I can set hyper link based on data. Yes, see the "Using Links" section on the following page: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-78f8.html#WSc3ff6d0ea77859461172e0811cbec12bda-7fb5
... View more
‎Oct 28, 2013
08:25 AM
iccsi wrote: I would like to know should I insert a sub report in to detail band to generate master details report. Yes.
... View more
‎Oct 24, 2013
10:34 AM
iccsi wrote: Because my sub report return different records from data source, it fails and get infinite loop error message like above when I have 9 records, it works less than 9 records. What do you mean by "return different records from data source"?
... View more
‎Oct 23, 2013
02:04 PM
iccsi wrote: I have many fields, summary fields on the report, Is it possible to have too many controls on the report that Report Builder can not handle? I'm sure there is an upper limit to how many controls you can put in a report, but I bet it is very high. I have some very complicated reports that don't appear to trigger this error, so I don't know if complexity is necessarily a factor.
... View more
‎Oct 23, 2013
07:41 AM
Kerry O\'Carroll wrote: I am trying to print a line graph using CF Chart... Kerry, please post your question in the Reporting sub-forum. You have posted in an existing thread here, which is not related to your question.
... View more
‎Oct 23, 2013
07:34 AM
iccsi wrote: it seems that once the report saved then I can not insert any new subreport to the report for some reason. This is definitely not normal. Try uninstalling the Report Builder and then re-install it. If the problem persists then report the problem to Adobe.
... View more
‎Oct 23, 2013
07:31 AM
I occassionally get this message too. As you have discovered, the only thing to do is kill the process and restart the Report Builder. I have not figured out why this happens.
... View more
‎Oct 22, 2013
03:45 PM
iccsi wrote: I just wanted to know are there any particular configure for more than one subreport on the report. There is nothing special that you need to do to have multiple subreports in a report. If you move the problem subreport to a different footer (e.g. page footer) does it begin to show up?
... View more
‎Oct 07, 2013
08:51 AM
iccsi wrote: I would like to know is it possible to have column footer just after last detail line print and report footer print after column footer It is not possible to change the order in which the footers print. To achieve what you want, do not use the "column footer" band. Create a dummy report group and use that group's footer, which will always print before the "report footer".
... View more
‎Oct 03, 2013
08:23 AM
RaiderDaveK wrote: When I test my report it while in report builder, it looks great on the screen. When I try to actually print a page so I can see how it looks on paper using the forms, all I get is the background/ CF Developer message. In what format is the report output being produced? (Flash/Pdf/etc.)
... View more
‎Oct 03, 2013
08:19 AM
The Madness wrote: Seems like it should be doable. I usually us a crosstab and it is relatively straightforward. Any suggestions in Reprot Builder? Thanks. A report will accept whatever data-set you provide it. The trick is to do the crosstab using your database engine. The result-set returned by the database engine can easily be used to create a report. It is worth noting that Report Builder is for creating fixed layout reports. It is not possible to have a dynamic number of fields generated at run-time. You have to explicitly place each field in the report. What this means is that your cross-tab query must always return the same number of fields, or at a minimum it needs to return the fields that appear in the report. If you have more questions feel free to ask.
... View more
‎Oct 03, 2013
08:08 AM
iccsi wrote: I got it, I need use TReportSubReport in the name field in the report builder to put it cfreporparam, thanks a million again for helping, Correct. Remember, you can change the name to something more meaningful, especially if you have a complex report with multiple subreports. Just remember to change cfreportparam to match the change.
... View more
‎Oct 03, 2013
07:03 AM
iccsi wrote: the subreport in cfreportparam is SubReportName and in the Report Builder is SubReportName.cfr. This is where I think you are going wrong. You are using the file name of your subreport rather than the element name of your subreport in your main report. Unless you explicitly changed the name of the subreport element in your main report, it will have an automatically generated name something like "TReportSubReport1". Did you change the name of the subreport element in your main report?
... View more
‎Oct 03, 2013
06:07 AM
iccsi wrote: The difference is mysubreport in the cfm file, and mysubreport.cfr in the report. Should I include crf extention for subreport on cfm file? No, you don't call the subreport directly from the cfm file, it is already embedded in your main report. I don't think you understood my last post. Please read it again and check that what I say is true for your situation.
... View more
‎Oct 02, 2013
09:42 AM
hamor185 wrote: Thank you for giving time to answer my posted problem. I really appreciate it! 🙂 You're very welcome. I'm glad you managed to find a solution that works for you.
... View more
‎Oct 02, 2013
09:40 AM
iccsi wrote: cfdump get sort by id, but sub report still sort by code, This suggests that you have a mismatch between what you named the subreport and what you are using in the cfreportparam tag. Open your report and click on the subreport object to select it. In the "Properties" window, in the "Data" section, look at the "Name" property. This is the name you must use in the cfreportparam tag, not the file name of the subreport.
... View more
‎Oct 01, 2013
01:19 PM
What was the result when you did the test I recommended?
... View more
Copyright © 2024 Adobe. All rights reserved.
AdChoices