Search results for query: *

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...

I am trying to print a student's current year transcript on a label (Avery 5162). The data to be shown is : StudentID StudentName CourseID CourseTitle When I do this in letter format the data returned is: 10 Jane Doe 0041 English IV 0225 Spanish V 0432 Sociology and so on...

I was afraid of that but appreciate the confirmation. C.Nice RealTime Information Technology Inc. http://www.realitinc.com/

I have users that need to send letters to their customers, however each user has different letters and they frequently change the content of each individual letter. Rather then create many reports and have the ongoing maintainance nightmare, I would like to create a table in the database that...

In case my original post wasn't clear, what I am asking is it possible to pass a variable within a variable. The first variable will be the text of the letter with the vaiable within being the field names and formulas. Thanks in advance for any suggestions. cnice9 Realtime Information...

I have users that need to send letters to their customers, however each user has different letters and they frequently change the content of each individual letter. Rather then create many reports and have the ongoing maintainance nightmare, I would like to create a table in the database that...