Search results for query: *

I tried the running total first but my numbers where still off. Found out that sometimes there are duplicate ProductIDs for the containers that throw the totals off. I'm going back to the Database manager and see if we can add a Y/N switch to the container table that states if it was worked on...

I have a multi table report and all was fine in the details until I added in one last table. The main table is set like so: Container {Container.ContainerNumber} {Container.CustomerName} {Container.ProductID} {Container.QTY} The details are grouped by {Container.CustomerName} then by...

I spoke too soon. I have a few fields that haven't been filled yet. Their value is 0. My work around for now is using these two formulas: {@CheckDate} if isnull({EXMP.DATE}) then 1000101 else if {EXMP.DATE} = 0 then 1000101 else {EXMP.DATE} {@CheckTime} if isnull({EXMP.TIME}) then 101 else...

Mike that worked! Just had to add a couple of parenthesis. The date field is formatted as YYYMMDD. The first number indicates the century. Anything before 2000 was then just YYMMDD. The main tables were created in the early 80s, and this was the programmer's fix for Y2K. I'm not sure why they...

I have number fields on the AS400 that I'm trying to combine into a DateTime value. The first field is the date and was able to create the date value using this formula: stringvar x := totext({EXMP.DATE},0,""); date(1900+val(left(x,3)),val(mid(x,4,2)),val(right(x,2))); The second field is the...

That worked perfectly, thanks!

I tried that and then it was asking for a string then I realized that this is a number field. So in the formula I converted the field to a string then I added your code under it but now I'm getting the error: "A month number must be between 1 and 12" So then I tried: numbervar x :=...

I'm pulling dates from an AS400 database but when I try to use the CDate formula it's not returning the correct results. For example, the field contains the value: 1080914 This formula: CDate({TRH00.TXDATE}) returns the date 6/9/4859 which is wrong. The correct date should be 9/14/2008...

That worked! Thanks!

I'm using Crystal Reports 2008 and I'm having a problem with Null values. I have two tables that are being compared in the report to return an account number. If there is no account number setup yet then I would like for it to return a message stating "Please add Account #". The first table...