Search results for query: *

Good morning everyone! I am running Crystal XI I am creating a mail merge, and have a need to suppress different sections of the report. However, i have a requirement that would require suppressing a section based on two conditions. Basically the two conditions are: {master_.Screen 204 Get...

Good afternoon everyone! Running Crystal XI I am running a merge document between Excel, and Word to generate a list of id's. Once the list is generated, I copy from word and drop into the record selection expert. The merge fills in like so: "id","id",etc... When I paste it into the correct...

Running Crystal XI I need to convert three fields into a single date field that can have a parameter run off of it. Here is what i have: I have three fields: Table.BegMonth Table.BegDay Table.BegYear I need to merge these three fields together for a field that can have a date parameter run...

I have three fields: Table.Mo Table.Da Table.Yr Basically it is the date broken into 3 seperate fields. I need to combine those fields into a workable date field for counting days. I am running crystal XI. Thanks

Hello all! I am running Crystal XI. Trying to bring in a list of ID's from a main DB, and compare it to a list in Excel. The goal of this is to eliminate ID's from the main DB that is listed in the list in Excel. I have tried a few things such as changing the record selection to be...

Good morning everyone! I am needing some help. I created a report that returns several date entries for a given policy number. I am needing to install the business days/holiday table that I have seen posted on here. The problem that I am having is that I need to start counting business days...

i need help with a maximum sql expression that I saw posted on this board. Basically I am intendeding to display only the maximum date for each record. i saw that a sql expression is probably the best way to go. My problem is that I am setting maximum on a date field on table A, in a group of...

good afternoon everyone. Running Crystal XI I am using the weighted average feature in crystal when looking at seconds to process work. My problem is that I am getting a different value for weighted average when compared to the sumproduct feature in EXCEL (manager is trying to validate crystal...

I am trying to find a place on how to learn stored procedures. I am not even sure where to start or what program can be used to create them. I have: Crystal XI standard MS Access 2000 MS VB 6.0 Can anyone point me in the right direction?

I am trying to find a place on how to learn stored procedures. I am not even sure where to start or what program can be used to create them. I have: Crystal XI standard MS Access 2000 MS VB 6.0 Can anyone point me in the right direction?

hello everyone Running on Crystal XI I am pulling in a field that returns data like: "0000012355" "0001234567" I have used the CDbl({field}) to cut the zero's out, but now I need to change this to a currency. I need the above field to read: "123.55" "12345.67" Please help!

I have version 7 of Crystal and I am trying to combine two fields. For example: Right now the report displays as two seperate fields UNIT WRKTYPE AFS SURR I am trying to get WORK AFS SURR Can this be done?

We currently run Crystal Version 7 with SQL designer. We have created numerous reports in the SQL designer. We have made the business decision to upgrade to Crystal 11. How can I move those reports built in Version 7 SQL designer to run on Crystal 11?

I use AWD which pulls time in to Crystal as HH:MM:SS. So data displayed on crystal is listed as 5,107.00 which should be 00:51:07. Here is my problem: I need that number to be read as time. What is happening is that I am trying to average a number as time and of course it is not reading...