Search results for query: *

Yes, it looks like it should work on my version too, Crystal Decisions knowledgebase even states this if for version 7.0 and higher (and even recommend a different one for version 8). But, it appears my version is getting hung up on the "while" and "do" statements. I'm...

I'm trying to display all the values that were entered into a parameter field that allows multiple values. We are using Crystal Reports version 7.0.100.12 (version 7 MR 1). From The Crystal Decisions Knowledgebase, I got the following example - indicated it is for version 7: numbervar...

I can't seem to enable the DMA on my DVD drive. When I loaded the 4-in-1 VIA drivers, it gave me an option to enable DMA. When it finished, my DVD drive disappeared. I could not find it in "Windows Explorer" or when clicking on "My Computer." I then scrapped everything...

I have this same problem. To date, Yahoo's support can not help me. They say I need to receive mail before I can send mail on their account (for security reasons). Outlook 2000 and Outlook Express seem to send mail before receiving. Have not found a way to reverse that. Not sure what else...

Create parameters on the sub-report then create a link from the main report's parameters to the subreport's parameters. You should only have to fill in the parameter values once. Make sure your parameters are not a range value as range parameters do not pass very well to subreports. If it...

You will want to use variables to total it by group. Have a variable in the group header to reset the value to 0 at the start of each group, such as: WhilePrintingRecords; NumberVar GroupTotal:=0; Have a variable in the details (you can suppress this formula) to accumulate your totals...

Disregard that first formula, it does not work under any circumstances (unless you round, but it will not always work). I was typing it out of memory while sitting here with a head cold (poor excuse). Try this formula: (Day({Table.Date}) + (7 - DayOfWeek({Table.Date}) +...

If Sunday is the first day of the week, here is a formula you can use: (Day({table.datefield}) + (7 - DayOfWeek({table.datefield}) - 1)) / 7 If Sunday is not the first day, you may need to tweek it some. THe DayOfWeek function counts sunday to saturday (1 to 7)

Check to see if the Microphone volume is muted. To do this, double click on the volume control icon on the bottom of your screen (or access it in your start menu). If you don't see a volume control for "Microphone" select options/properties from the menu. scroll down the and click...

I would just pick it apart and put it into a date via a formula such as: If NumericText(Left({table.datestring},2)) and NumericText(Mid({table.datestring},4,2)) and NumericText(Right({table.datestring},2)) Then If ToNumber(Right({Table.datestring},2)) > XX (Where XX = lowest year...

After reading these posts, I thought I'd go check out www.grc.com as I have two computers networked together with file sharing open (all shared drives are password protected, which will slow down hacking, but I'm sure will not prevent it). I was shocked when I found how much info came back when...

If you are using Crystal version 6 or 7 you can get the DateAdd dll from the seagate website. Go to http://support.seagatesoftware.com/updates/default.asp and search for UFLDateAdd.exe. The readme.txt will tell you how to install it. They will need to be installed on all the computers where...

Although I would try to avoid the RT and ResetTotal formula's as they tend to get flakey if you suppress any of the detail or even group sections. I've found the best work around to be the three formula variable approach as outlined in MalcolmW's FAQ. Nilsen

One thing I've found (with version 7 anyway) is that when adding or subtracting from a date or datetime field is that the number being added or subtracted is going to the lowest possible denomination. Thus the following results: {table.datefield} + 1 Will add 1 day to the date field...

Use the formula below to set all records to create a reporting date for each record. Then you can have the report select on records that fall within the reporting date range. Formula: ReportingDate If Hour{RecordDateTime} < 6 Then Date{RecordDateTime} - 1 Else {RecordDateTime}

Be careful that your count is correct in the footer, as when the formula is placed it adds 1 to x.&nbsp;&nbsp;Thus, it will add 1 to x in each detail, then adds another 1 to x in the footer.&nbsp;&nbsp;You could end up with a count of 1 more than your actual count.

The only benefit you would receive from the shared variable is the ability to pass it to and from subreports.&nbsp;&nbsp;Are you saying the above didn't work?&nbsp;&nbsp;If no, make sure you are careful where you place the Formula 1.&nbsp;&nbsp;It is resetting the value of X, thus if it is...

Is that a single formula?&nbsp;&nbsp;or three formulas separated by the semi-colon?&nbsp;&nbsp;<br><br>If it is a single formula, the reason you only get 0 or 1 is that you are resetting the variable x to 0 everytime the formula is run.&nbsp;&nbsp;You need to have a formula that resets the...

Malcolm,<br><br>I've tried both of those on some of my reports, and for some crazy reason they didn't always work.&nbsp;&nbsp;I think for me the problems had to do with suppressing some of the page headers.&nbsp;&nbsp;But for the life of me, I've not been able to get the &quot;Keep...

One thing you can do is add a section to the page header, put the field SERVER in the same spot as it is in its group header.&nbsp;&nbsp;Then conditionally suppress that page header if the previous record is null or belongs to a different server.