Search results for query: *

Dear Frontsj, Try: Numbervar T := ToNumber({CONTHIST.ONTIME}); Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports. You will get answers more quickly if you read this before posting: faq149-3762

Dear lbass, There is nothing wrong with your concept at all. However, Table is a keyword in sql server and in Oracle and cannot be declared that way. Select 'A' as Table should be Select 'A' as 'Table'. I don't know what backend you use - so it may be valid in that. But the main point I...

Dear ReportDr00, Lbass solution is truly better. But, when writing Union All statements it is important to know that the number of fields (and field type at each position) must match as only one column is returned for each of the two columns from the table. I would also suggest adding a text...

Dear ReportDr00, I would think that you would need a full outer join and that you only need to join on SSN as it would be unique. A full outer join pulls all combinatio of the data and you shouldn't need to create table c. Regards, ro Rosemary Lieberman rosemary-at-microflo.com...

Dear Lbass, You are right. Great solution! As, in a traditional Venn Diagram the overlapped records are not presented twice. It would be nice if Crystal could show this relationship ... I did a search at the CR KB and not one item came up. Best, ro Rosemary Lieberman...

Dear ReportDr00, You could easily represent this data in one pie chart. You would create 3 separate formulas to test the data (the formulas below are for example sake only as I don't know how the data is stored, that indicates Both Counties. Create 3 formulas: If {Table.Count} = 'County A'...

Dear Saran26, One way you could solve this is with a manual crosstab, where you create the columns yourself. You would create a formula for each possible state. With your example data, you would create 4 formulas. //Example formula If {Table.State} = 'Open' then 1 else 0 //end example Place...

Dear Cutpen, Here is a new and much simpler formula. The problem I was having (besides driving down the rosy path) was that when the number was transformed to text it wasn't keeping the padded 0s. Now it does. Now this formula works as follows: If any number is entered that is less than a 4...

Dear Cutpen, Ok. That can happen if the field is blank or null. Give me a few minutes to further tinker with the formula. Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports. You will get answers more...

Dear Vega83; This will work: whileprintingrecords; numberVar dur := datediff("s",minimum({@Print WMS},{@Date}),minimum({Command.EDI_CRT_TS},{@Date}));dur := if dur < 0 then 0 else dur; numberVar hrs; numberVar min; numberVar sec; stringVar hhmmss; hrs := Truncate(Truncate(dur/60)/60); min :=...

Dear Vega83, Can you please show your current formula? Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports. You will get answers more quickly if you read this before posting: faq149-3762

Dear Cutpen, Just so that you have the entire formula correct, copy this: NumberVar T := {HMN_UNSHDDAY.S_START}; numbervar l := len(totext(tonumber(t))); numbervar c := select(l) case 0 : 0 case 1 : 0 case 2 : 0 case 3 : 1...

Dear Lbass, Oh you are right! I am testing in 10 and it had slipped my mind about the issue in 8.5. You have a good memory as it was me that told you. Put the extra semicolon in cutepen and it will be fixed. Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo...

Dear Cutpen, Yes this is all crystal syntax. Did you copy my formula? Or did you type it? Can you paste in exactly what you have in the formula? Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and Crystal Reports...

Dear Cutpen, Thankyou! My mistake was only testing 4 digit numbers. I believe that the following corrected formula will work for you. NumberVar T := {HMN_UNSHDDAY.S_START}; numbervar l := len(totext(tonumber(t))); numbervar c := select(l) case 0 : 0 case...

Dear Cutpen, I have tested both my formulas with strings and with various numbers and 1500 will return 3:00 which is correct. Perhaps you weren't responding to me? Regards, ro Rosemary Lieberman rosemary-at-microflo.com, www.microflo.com Microflo provides expert consulting on MagicTSD and...

Dear Klaidlaw, What I was trying to first determine is whether your report was on just one view or table. You have answered that, as you state you are joining many. The reason that I asked about a primary key in the table was that would show whether they were unique records that had the same...

Dear Cutpen, If the field is a number field the following will work: umberVar T := 1845; //change to your field NumberVar H := tonumber(left(totext(t),2)); NumberVar M := tonumber(totext(t) [3 to 4]); time(h,m,0) //field will be returned as time. After placing on report //right click...

Dear Klaidlaw, Are you reporting off just one table or view? If not, how have you joined. Also, does the table or view you are reporting on have a primary key that uniquely identifies each record? If so, place that field on the report, do you get duplicates of that number? regards, ro...

Dear Franklin1232, Can you provide more information? Crystal reports is a page on demand system, it retrieves the page as demanded. If you go into help and do a search for multi-pass you should find a topic with a chart of what is processed when. I have never found that the displaying of a...