Search results for query: *

I currently have a report that shows account activity. In this report, the primary fields are being pulled from one table. There is one field called lpchgs, and this is the total charge for an account. Ex. Account Total Charges 444444 $152.00 I created a report to show an accounts...

I am currently using Crystal 10 and added a field that represents time. Only problem is that its formatted as a number field instead of a time field. How can I convert this over. Now Want to have Ex. 608 6:38:00 AM 1334 1:34:00 PM 1218 2:34:00 PM 2241 10:41:00 PM Thank you

I currently have a crystal report that returns account numbers and shipping information I need. I also have a spreadsheet that contains a list of account numbers. I need to take all of the account #s in the spreadsheet and put it into the crystal report, so that I can get all of the necessary...

I currently have a database that calculates the Beg and End Date for the time it took an order to be ordered. I'm using Crystal 8.5. I'm trying to find out how long it took for the order to be taken, but am having a hard time doing it. Can someone please help me. Thank you The formula for the...

I'm currently have a report that lists all patients from 2 different units, units #7 and #11. The patients can have appointments in one of these units or in both. Right now when I generate the report, I get all patients, whether they only have one appointment or 2. I want to be able to only get...

I am currently using crystal 8.5. I have no problem with the data that the field gives me. Ex. QTY 5 5 6 7 7 7 What I'm trying to figure out is how I can eliminate the values that only appear once. I was trying to create an if statment, but don't know how to word it...

I currently have a spreadsheet that is supposed to do some projected time calculations. In cell a1 I have the number of calls, 8. In b1, the average length of a call, 0:3:25. I multiply both of these cells and get the answer in c1,0:27:20. I have formatted all the time fields to be in the...

Crystal 8.5 I have 2 formulas that will tell me the difference of days between them. date({@Discharge Date}-{@ADM}) ADM DD Stay 7/25/06 7/26/06 02 1/13/06 30 I changed the format options to a custom, so that it would only show me the number of days.When I display...

In my 8.5 version of crystal, I'm trying to compare 2 dates. In the database, the fields tran and svc date are stored as date1,date2,date3. Date1 = month, date2 = day, date3 = year. My formula is this: If transdate > svcdate then "after" else "before" My problem is that it requires me to put...

I'm trying to create a calculated field, to get a percent and then query by the result of the percent. In Crystal 8.5, I wrote this for my formula: (lpadj/lpchgs)*100 I put this field in my report and then run it. I then use the select expert to query anything less than 5%, but it always...

I have Crystal Reports 8.5 and I was wondering if there was a way that I can automatically set up Crystal to run a report at 12:00 am, every month. I can use microsoft task manager, but all that does is start the program, not actually run it. Thank you

I am using crysal 8.5. I have my main report that breaks down the productivity of a class by groups, 0-30, 31-60, etc. Ex. Class 0-30 31-60 61-90 A 1.00 25.00 100.00 I have another report that breaks down the class based on budgets. Ex. Class Budget A...

I have 3 reports that I do, and I would like to be able to put all of the reports into one summary. The first report calculates all unbilled charges greater than 0. The second report calculates all of the current balances less than 0 and the last one calcuates all total charges greater than 0...

I have a database and a spreadsheet. The spreadsheet contains a customer list. I need to make a report with other data. This data comes from the database. I have imported the spreadsheet into the database as a table. I link the first and last name to eachother and run the new query. I get...

In MS Access, I know that one would be able to create a query, and if needed to, could run another query based on the first query. I was wondering, I have a report that pulls my data. Is there a way I could either make crystal run another query based on the first report and another table, etc...

In MS Access, I know that one would be able to create a query, and if needed to, could run another query based on the first query. I was wondering, I have a report that pulls my data. Is there a way I could either make crystal run another query based on the first report and another table, etc?

What I want to do is convert a number to a date value. Current examples of the numbers are: 11506,12906,20306,21006,122805. I select this field and put it in the report. I create a formula field using the datevalue function, and then attempt to format it. I'm trying to get this value to be...

I'm trying to write a report in crystal, but I'm having the hardest time trying to figure out how to get the data sorted the way I want it. I have a customer list: Name Type Dollar Bob B 100 Chris C 1000 Gus F 2 Rudy U 5000 What I basically need to do is First...