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...

here is the formula from the select expert: {Details_2006.jrnl_id} in [“K01266SRG2”,“K01266SRG3”,“K01266SRG4”,...,“K10276SRGZ”]

here is an example: Notice that the quotes look like they are in italics....when I manually replace them the code works. “K01266SRG2”,“K01266SRG3”,“K01266SRG4”,...,“K10276SRGZ”

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...

Thanks...that did the trick

The three fields are in string format

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 am getting a too many arguments when I try to use that date function.

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

That did it. Thanks for your help.

OK I was being a little thick headed. I have: Set up the query using the wizard as you had suggested, and used without matching. I have now gained connection to the .mdb file via crystal. So my question now is: I have the main DB, and the Excel db listed in tables. What do I need to bring...

Wanted to add I am trying to connect to Access 2000, and using the DAO create new connection

I have the db set up and am now having a hard time connecting the querey to Crystal. My make new connection screen shows: Access Objects ACE's Objects Queries Relationships I don't have a views to list what is in the database. Also when I try to move over queries there is a no read error...

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...

Thanks for your help. It worked.

I am using your formula. Would I need to change the holiday table to before printing records as well?

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 am not sure what you mean by sub query? I tried what you recommended but had to modify it to this to get it to work. (SELECT MAX(A.ENDDATTIM#) FROM vwGW20 A, vwGW03 b WHERE b.INXFLD02 = b."INXFLD02") When I ran this it returned no records. The INXFLD02 field is not on the vwgw20 table...

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...

i figured it out.