Search results for query: *

AC_CurBalance is a database field of money data type.

Sorry I was tryint to make it easier to read, here is the exact code I have placed in report: //curBalTot1 WhilePrintingRecords; NumberVar totalCustCurBal; totalCustCurBal := 0 //curBalTot2 WhilePrintingRecords; NumberVar totalCustCurBal; totalCustCurBal := totalCustCurBal +...

I have 3 formulas created to have an end result of all customer balances added up. I need a parameter to pull >= the total customer balances. However, I cannot select my formula in the Select Expert to equal my parameter? FORMULA 1 : tot1 //Placed in Report Header WhilePrintingRecords...

That looks correct, check and make sure it is not throwing the error because of NULLs in either of the fields. To give an even number w/o decimal, try this: totext(dateValue({CallLog.ClosedDate}) - dateValue({CallLog.RecvdDate}),0) Hope that works for you :)

Thank you very much... I was just trying: {Account.AC_Number} = next({Account.AC_Number}) and {Customer.CU_ID} = next({Customer.CU_ID}) ...to see if it would work but you suggestion is perfect! Thanks lbass!!

What would the formula be in GF (x-y) button beside "New Page After" if I don't want the very last record to create a new page after? Thanks in advance, Carrie

The following query tells me incorrect syntax near FROM?? UPDATE c SET c.ac_id = b.ac_id FROM ((Account a INNER JOIN Account b ON a.ac_number = b.ac_number) INNER JOIN scanned_document c ON a.ac_id = c.ac_id) WHERE a.ACT_ID IN (59,60,61,62,63,64,65) AND b.ACT_ID IN (71,72,73,74,75,76,77))...

To show the date range selected, create the following two formulas: "Agent - " Totext(Minimum ({?Date Range}),"MM-dd-yyyy") + " to " + Totext(Maximum ({?Date Range}),"MM-dd-yyyy") //AND "Self Service - " Totext(Minimum ({?Date Range}),"MM-dd-yyyy") + " to " + Totext(Maximum ({?Date...

I had the same issue with my company's proprietary software. The issue was in the viewer where it was setting the Crystal viewer and then setting the printer settings.. ie- landscape or portrait, pulling the PC default setting instead of the reports. The fix required a code change in that...

Group the report by VISIT.PATIENT_ACCOUNT_NUMBER and then copy all of the information to display in the group footer section also. Suppress the details section all together. Highlight the REG_DATED_ROOM.CODE, right click and select Insert --> Running Total. Use Maximum type of summary...

Which is why I couldn't find Command... thanks Bigfoot. Do you know of a way to write SQL syntax instead of Crystal or Basic syntax in CR 8.5 without using stored procedures?

Very cool... it's working. Thanks Everybody!

Ok, I have a sort set for date in descending order. I have the "Create Running Total Field" screen open --> clicked Summary = count. Then in Evaluate --> I didn't know what @TotalCount was... a parameter? If so, I need to create that first, right?

I want to show the first three records and supress after that...so I only want to see a patient's newest 3 orders. What is the syntax to write in the Formula Editor? Thanks, Carrie

I did not know about the Command data source. I was hoping that I could use more T-SQL instead of the Crystal Syntax. I looked in the CR 8.5 users manual under Data Sources, but did not find Command... nor under Command alone. As for the conditionally suppression... what would be the Crystal...

I want to be able to pull the top 3 records from a result set that is sorted by date descending. I am better in T-SQL and would say: select top 3 * from tablename where... Is there a way to do this in CR 8.5 without grouping first? Thanks!