Recent content by SeeBee

I have voucher numbers and dollar amounts that are duplicating - in some instances, not all. How do I write a formula that would say: look at the voucher number and the dollar amount, if they are repeated, then delete/omit from grand totals for each field (Voucher, Dollar Amount). Thanks in...

Crystal 7.0 Professional "Show SQL Server" is grayed out. seebee

Sorry, but I entered as you suggested and returned no results. I know there are records, as I've seen a few. Selection Expert reads like this: {Job History.Ship Via} = "W" and {Job History.UserDef01} like "WALKUP/*/LORAINE *" If I enter only [COLOR=red]{Job History.Ship Via} = "W" and {Job...

I have a Definition field that I only want certain records for: WALKUP/12345/LORIANE X1234 The 12345 number will vary, but rest of information will be the same. Would I use a 'like'? Not sure how I would write it - {Job History.Ship Via} = "W" and {Job History.UserDef01} like...

I have a Description file that I only want certain records for: WALKUP/12345/LORIANE X1234 The 12345 number will vary, but rest of information will be the same. Would I use a 'like'? Not sure how I would write it - {Job History.Ship Via} = "W" and {Job History.UserDef01} like...

When I run my report in Crystal everything is fine. I end up with 83,188 records and 1,342 pages of data. I name the file and save it in Crystal. I click on the Export button. Select Excel 5.0 and Application. Report runs, but when I go into the Excel Temp file to look at the data, all the...

Below is the formula I am using. When I 'test', I (being both UserName and one of the 'cc') the message gets sent to both 'cc' people, but not the UserName. Can anyone tell me what the problem may be? Thanks in advance. @MailSend(SendTo;@UserName:"John Doe": "Jane Doe&quot...

I may have confused you. I created a form that looks like an excel spreadsheet but within a table in Notes. Also, I do not know Lotus Script, so I do need to use formula's. This will not be used on the Web.

This is going to be a bit lengthy, but here goes. I have a an excel spreadsht that I am re-creating in Domino. It has a single field above the 'table' that asks the customer how many items they will be requesting, and the customer then specifies a number (1 thru 10). The table has 6 columns and...

I have created a form that looks just like an Excel spreadsheet. The form has 5 rows and 6 columns. Our customer will complete 1 to 5 rows & and the first & sixth cell of each row, depending on their request. If the first cell (in each row) is complete, then the sixth cell (of that same row)...

is it possible for me to link my db form fields (only a few) with someone else's db - same form fields. And when they create a form, my db form is automatically created and populated with their information, and then I get a notification telling me this form has been created? Thanks in advance...

Yahoo! - it worked. Thank you for all your help.

This is what I have for a formula for @CritMet, which returns either true or false: Sum ({Job Detail (History).Cost Center}, {Job Detail (History).JobNo})/Sum ({@task test}, {Job Detail (History).JobNo})=13 How do I specify that I only want to see the true? Thanks.

The file is too large to send - I am working with 89,000 records out of 1,200,000, and I'm sure you don't want it either. Here is an example of what I have showing in the group footer (details are hidden): JobNum CostCenter(summed) task test(13=1,else 0, summed) 107414 247...

Okay, I'm back to working on this again - and I think I have it narrowed down. As you suggested I subtotaled all the CostCenters and counted all the results of the 'test' (CostCenter 13 = 1 all others = zero). Then the subtotal of the CostCenters divided by the subtotal of the 'test' total =...