Recent content by leedy33

Im using crystal 8.5 and in my report i was wondering if there is a way to create a line to be placed after each "due date". For instance my report is ordered by due date, with there sometimes being one sample for a date, while other times there are multiple samples per date. I was wondering if...

Mr. Bill~ How do i go about making it so the total is the only thing that shows, instead of the whole running list. Other than that it works just fine. Thanks

Im using crystal 8.5 and in my report im trying to count up or get a sum number, of my total amount of samples that fall within a certain date. The sample group is what im trying to count, but there are duplicate groups sometimes for the same date, and what is happening is that in my count it is...

In doing a report is there anyway to create a line or seperation in the middle of my information. Lets say i want to have a line go across the page after a certain date. I have a bunch of rows ordered by date, and if there is a certain date that i want to be as a seperation point, is there any...

Thanks alot

Im using crystal 8.5 and in my report i have a field named "Status", which has 5 different possible scenerios that can appear. What im trying to do is when under "Status", the word "resolve" appears. Im trying to change it so that "Login" appears instead. I know you need to do something in the...

In looking at the SQL Query, it looks as if my date that i put in my parameter, that is in my "Selection Formula Record" is not showing up in the "Where" catergory of the query. I believe that is should show --> 'received_date'= "Date" So for some reason my parameter selection is not...

Im using Crystal 8.5 and when i open up my report through my LIMS program's "Report Browser", and i select the criteria for my data that i want to show, nothing is showing. Now when i do the same parameters in just crystal through ODBC, not through the LIMS program, Im able to access...

Im using Crystal 8.5 and in my report i was wondering is there a way to use "Edit Selection Formula" and put in a formula that will disregard all the samples in the {Samples} field that start with a certain letter. Im sure there is a way and it probably fairly simple, but any help would be...

Thanks Alot

Also one other question that i have, is that in this report i want to be able to pull up the data that was Recieved the day before, so the (ReceivedDate) would = currentDate-1 or some sort. The problem that i then come across is what happens on Monday, when i want to pull up fridays information...

In looking at my {ReceievedDate} it appears to be a DateTime. And when I use the >= or <= it works just right. How do i go about using the CR to change my {ReceivedDate} from DateTime to just Date. Thanks

Im using crystal 8.5 and I'm running my database through ODBC. In my report i have about six columns of infromation, with numerous rows associated with each. For each sample, the columns have information related to that sample. What I'm trying to do is create a report where it only shows the...

Thanks alot lbass, it worked perfectly. My problem was i was using the groupname field, but it works great now

Thanks lbass, when i right-click on my group(element)which is in my details setion, i cant get to any count or grand total level. The SUMMARY tab in INSERT is faded out when im on the group. Im not really sure what to do when i right click on the group.