Search results for query: *

I am having trouble getting a calculation to work. I'm trying to get the difference between two columns. The two colums are in a GF3 section. The first column is from a summary (Minimum of apptmt_t.appt_time) to get the starting time of the doctor's day. The second column is from a summary...

I am having issues with a field in a database. The field is a number field, but it contains appointment times. For example, 800, 810, 815... 1515 mean 8am, 8:10 am, 8:15am, 3:15pm. I have to do calculations on these times now, so I'm trying to convert the number to a time and can't get it to...

Thanks so much!

Sorry, forgot to mention I'm using crystal XI version.

Hello. I have a formula and I have the result as a whole number. I always need the result to round down, not up to the next whole number. How do I do that? I can only get it to round up to the next whole number. For example, if my result is 120.67 then I want it to say 120, not 121...

The end users do not have direct access to the database. The only thing they can do is run crystal reports from BOE. We were trying to use crystal reports to accomplish the update via a stored procedure.

Is there a way to use a crystal report to run a stored procedure? The stored procedure is a simple update query to update a field in the database from 'Manual' to 'ORDERED-Manual'. I was able to create the stored procedure just fine on the database side, which is in MySQL, but I can't get the...

Thanks chelseatech for your response. I was trying to use a hyperlink per your suggestion and can't get that to work either. One of the added issues it there is security on this report so people can only see what they have rights. So, I modified my main report to put the two subreports back...

Hello. I'm using Crystal XI and am trying to attach an on-demand subreport to a report. The problem is, the On-demand subreport needs to have 2 subreports in it as well, but when I do the steps to add an on-demand to my report, it drops off the 2 subreports. Is what I'm trying to do even...

I hope someone can help me on this. I've been staring at it until I'm cross-eyed. I am trying to pull information from a database in such a way that either all fields have information in them OR the first three fields are blank, but the rest are filled in. My selection criteria is shown below...

Hello, I have a simple line chart on my report and have the details section hidden. Is it possible to be able to click on a plotted number on the chart to see the details that make up that number? Any help would be greatly appreciated!