Recent content by cnice9

Althought I was hoping for a cleaner option, I understand and appreciate your reply. However I currently have the lable formated as: detalis a: name details b: address details c address 2 (suppresed if blank) details d {@city state Zip} if I insert section below in order to suppress based...

I am using CR 9 and have a simple report that displays an individuals name and address formated for labels. For example: Jim Jones 123 Main Street Your Town, NJ 12345 Betty Crocker 234 Cooking way My Town, NJ 23456 What I need is for a user to be able to select via a parameter the number of...

I have a report that I am running from an asp page. I am using a multi select input box to get text from the user that is passed to the report like so: <!-----Marks----------> <cfquery name="getmarks" datasource="#session.dbname#"> select * from gradecodes where yearid = #session.getyear#...

Thanks for the responses especially lbass as he was right. Stupid me had the parameter set as datetime when all I needed to evaluate was the date. Thank you again for your assistance. C.Nice RealTime Information Technology Inc. http://www.realitinc.com/

I have a few reports that need to run by a user selected date range. To do this I am simply using the following formula in Select Expert: {Discipline_Log.IncidentDate} in {?Startdate} to {?Enddate} This works fine unless the end user enters the same start and end date to show records for only...

I have created a grade distribution report in CR 9 that is intended to show the number of different grades given by a teacher, by their course and section. The report works fine but I need to be able to show percents as well as the totals in the cross tab report that I have inserted. What I have...

Thanks Brian, you suggestion worked perfectly and is very much appreciated. I have to say that I found your approach interesting and not in a direction I was thinking. Thanks again. Chris C.Nice RealTime Information Technology Inc. http://www.realitinc.com/

I have a report card that lists the grades for a student in a string field. This field has both numbers ranging from 0 to 110 and alpha characters in it. My problem is that if the student grade is less then 70 I need to show an F other wise I show the grade be it alpha or numeric. I am using the...

Thanks, but I got it. You can actually create the text objects and format the borders right on top of the image in the page header which is set to underlay. It was a bit tedious but it works. Thank you very much for your help. Oh and sorry about the previous double post. C.Nice RealTime...

Thanks for the reply, I did try that but what I get looks like this: Details ! data ! data ! ! data ! data ! This makes the data look bracketed at best as opposed to continuous lines forming columns. I might be able to getaway with alternating background...

Thanks for the reply, I did try that but what I get looks like this: Details ! data ! data ! ! data ! data ! This makes the data look bracketed at best as opposed to continuous lines forming columns. I might be able to getaway with alternating background...

I added a second page header, inserted a picture &quot;logo.jpg&quot;, checked Underlay Following Sections on the section expert tab and adjusted it to fit the details section. All this works just fine. The problem is that the vertical lines I placed to create columns and seperate detail fields...

I apologize for the lack of details but was thinking it was just me with my page break error and missed the obvious which is that &quot;You can only run one REPORT at a time.&quot; OK, what I have is a rather detailed report card (please check my info to know that I am not a student). This...

I have a report that is custom sized to 8.5 by 5.5 (half letter). What I need is to print 2 reports per page so that it outputs to a custom form with a perforation in the middle. I have tried to reset the page number after 2 which works and then create a page break when page = 2 which isn't...

Thanks Vidru, the subreport did the trick. However now that the labels are returning the proper data and formated I want to move to a larger label. In CR 8.5 I could do this by choosing Report - Report Expert, But now that I moved to CR 9 I can not find the same functionality. Can anyone tell me...