Search results for query: *

I have a report that creates detail lines (items). That report must display all lines at the beginning of a report (any section). That part is working. I have to execute that and after it runs provide detail for each item in a second step. But no matter what I try I keep getting item then...

In my table below, I have multiple records that share an incident number (201311476). I need to check the JUVENILE flag and if it is 1 (like the first record) I need to bypass this incident record entirely. That may seem simple but when the bigwigs want it NOW it gets harder - way harder...

Hello, Our desktop staff inserted Windows 7 machines into a formerly XP-only dept. Now the users remaining on XP machines cannot open Access 2003. An error is returned 'can't find project or library'. The Windows 7 users are fine - just the XP uses in the dept. I see 'MISSING MS Excel 12.0...

Sorry - this is not a dbl post - I was not a member of this forum when I posted it and I want to make sure it gets to the right place. I really hope this is it! I have a group of users that are using MS Access 2003 on XP machines and their login credentials suddenly do not work and the form...

I have a group of users that are using MS Access 2003 on XP machines and their login credentials suddenly do not work and the form does not respond at all. The only thing that has happened since the problem since the last time the did work was a Windows 7/Access 2007 machine was introduced to...

Ok - when you bring a field of data from a table into CR it sits in it's 'box' differently from one field to another causing the rightmost chars to not line up. The 'boxes' are aligned on the rights but the data sits differently horizontally in the 'box'. I have to grab the right side of the...

I have a formula in a subreport that assigns a running total to a variable which is passed to the main report: // FICA whileprintingrecords; shared currencyvar FICA; FICA:={#FICA} I have another formula (not a running total) in the main report to calculates another value: whileprintingrecords...

I cannot believe this is proving to be difficult. I have a formula that returns a value. I need to multiply that value by 4.2 percent. CR 11 ha sa % function but I cannot get it to work - her eis my formula: whileprintingrecords; {@CALC3} % 4.2) I hate to have to ask for something that...

Hello - I suspect this is easier that it appears but as a CR newb it is not for me! I have two subroutines that each yield a total field. I need to sum these two in the main report. I'm not sure how to do that - I've been trying to use a shared variable but my results in the subroutines are...

I want to pass an amount field from a subreport to a container report but the amount field was created with a Selection formula as well as a Running total. I need to reference the amount field for calculation in the container report. How can I refer to the calculated amount field in the...

Well I have to ask this but I need to convert a number field to a date for comparison. Here is an example of a number field which contains the date: 61512. I need to convert this thing to a date but after 2 days I cannot get it done. Your assistance is appreciated.

Crystal stores my dates in the following formats - 6012008.00 (I need 06/01/2008) 11012009.00 (I need 11/01/2009) I need to convert these Numbers to Date format for comparison to another date field in my report. I cannot seem to do it and would appreciate any help. Thanks in advance -...