Search results for query: *

Perfect, thanks

I am trying to have one command object parameter for my predefined date range (string) that is entered to select which date range to use. What am I doing wrong? My where statement looks like this in my Crystal 2013 Command Object (Note: this is hitting a Oracle PL/SQL database) WHERE...

you might be able to write a SQL Command where you do the join and return the data you need for your report." Can you go further in detail on how I can do that? Google can only teach you so much... I am in the command part of the "database expert". I have a basic knowledge of SQL. Thanks, Will

Hi and thanks for your help, I am trying to connect two tables by connecting very similar text fields. For example: First Field is: #234 -34543 -34534 Second Field is: 234-34543-34534 Is there any way to connect these two tables through this field? Thanks again for your help, Will

LBass, I must write a computer poem for you since you saved my bacon once again: *ahem* LBass you helped save, my Crystal Reporting junk, Out of the window, my computer I was going to chunk. Like the 2001 obelisk, you enlightened my ape-like mind, I before looked like zombie, groaning wildly...

Whoops, I meant to say that I want only "ACTUAL" records. I have been staring at this report too long. My only problem is that items other than "ACTUAL" are still showing on my report. Will

Hi and thanks for your help, I am trying to use a record selection query to filter out any record lines where {ITEMMAST.USER_FIELD1} = "ACTUAL" -- This is not working. I know it's not working because I have a formula field that is picking up values that are "" <-- these are not null Here is...

Perfect! I really owe you one LBass. If you are in Fort Worth hit me up for a whiskey+coke sometime.

Currently I am getting this: Recrd Purchorder.PO_Revision PORevision.PORevision IssMtd 1234 1 0 D 1234 1 1 F 4321 1 0 F 4321 1...

Hi and thanks for your help, I am not sure how to write this report I was given. I was thinking it could be done with a group selection formula, but I don't understand that part of Crystal well. I would only like the report to show the records with the maximum "PORevision.PO_Revision" number...

Thanks for the help again

Yes the field I mentioned is a number field (Ex 121.00) and the other field is a text field (121). Other than that they are the same. I am using Crystal Reports 2008 I'm not one hundred percent sure, but I believe our database is an Oracle Database of some type. Thanks, Will

Hmm, OK, for the sake of argument let's assume that I'm trying to link a table containing the numeric field ICMXVAL.IC_OBJ_ID into my report for the text POLINE.ITEM field. Can you guide me on how to get that done? I have used SQL queries a few years ago, so let just use the command method (if...

How do I use a formula to convert one of the data items to the correct type, have the tables link to each other, and then to use that in the selection formula? Thanks again, Will

Is there a way to link a table that gives me the "Data types are not compatible" message? I need to use a field in this table in selection formula. Thanks for your help, Will

perfect

Sure thing, here is a look: The crosstab is organized like this: (Name) (Total) (Col 1) (Item Num)(Total Dstct Cnt of PONum)(Qtrly Dstct Cnt PO Num) I am trying to suppress every row where the Total is less than 3. Thanks again, Will

Hi and thanks for your help, Is there a way to suppress crosstab rows where the total is less than 3? Thanks again, Will

Hi, Which table in a pair of tables is the left table? Is there a way to force another table to be the left table? Does it have to do with which table is selected first? Thanks, Will

Hi and thanks for your help, I need to suppress crosstab rows on my report where the row total < 2. I there a way to do this? Thanks again for your help, Will