Recent content by UHsoccer

I would like to present the user with a pop up calendar that has two sgments. In all my application, there is a start date and end date and sometimes a start time and end time. So: Segment one for start date and start time Segment two for end data and end time Normally a calendar only gives...

Thanks, would you know what version of mySQL is the latest. I will contact the hosting service and request information

Hope someone is still tracking this thread My code works fine in SQL localhost, but when loading to mySQL web it fails with "Program type out of range" the query is lsSQlSelect = "Select sum(HoursWorked) as lsH from TimeEntry " Set rsobjTimeSum = lsObjDBConn.Execute(lsSQlSelect) lsHours...

I use the parameter "Lanuage" to define the name of the months and placed the formula in the header as whileprintingrecords ; stringvar array monthNameDef[12] ; if {?Language} = "German" then (monthNameDef[1] := "Januar"; monthNameDef[2] := "Februar"; etc, through...

The definition for "monthStart" is in a different group segment of the report and it looks like whileprintingrecords ; numbervar monthStart ; monthStart := month(date({Projects.StartDate})) ; It is really the use of an array that is my problem. I have seen the "Ubound", but not sure how to...

Using CR 8.5, I have twelve (12) formulas that look like // In row 2 whileprintingrecords ; numbervar monthStart ; if monthStart = 12 then "Januar" else if monthStart = 1 then "Februar" else if monthStart = 2 then "Marz" etc for each month and //in row 3 whileprintingrecords ; numbervar...

A thank you is in order to "lbass" Aprriciate your persistance, I now realize that I was making it more complicated than it needed to be. Coming from a different progamming background, I am used to "setting up variables", then using them later. InCrystal that eliminated the "Insert SubTotal"...

Here is a copy of the code whileprintingrecords ; numbervar mStart ;numbervar mEnd ; numbervar yStart ;numbervar yEnd ; mStart := m(date({Projects.ProjStartDate})) ; mEnd := m(date({Projects.ProjEndDate})) ; yStart := y(date({Projects.ProjStartDate})) ...

If the "whileprintingrecords" line is removed, then the mStart and yStart are not available anymore. They are defined in a different segment Is there possibly a way to define variables w/o the whilprinting stuff?

The selection to insert subtotals/totals is available when I use logic like if month(date({Care.Date})) = 4 and year(date({Care.Date})) = 2006 then {Time.Hours} It is NOT selectable when I use whileprintingrecords ; numbervar mStart ; numbervar yStart; if month(date({Care.Date})) =...

I am using Crystal 8.5 I need to report on contract time usage for a 12 month period, beginning at whatever month the contract start in Say the contract start in May-2005 and runs through April-2009 I would need to report from May-2005 through Apr 2006, then from May 2006 through April 2007...

I cannot eliminate a company untill the subreport looks at the contracts for that company and the decision is based on (among others) how many hours are left on the support contract. If the answer lies within the user psecifedi criteria (like "list if fewer than 10 hours are left"), then I want...

I have a subreport in Ggroup Header 2, all sections in the subreport are suppressed and I even formatted using "Suppress Blank section" (on suggestions from other threads) I also reduced the size of the subreport in GH2 as small as possible When I run the report I scan through about thirteen...

Ido, Thank you for the reference to Cross-Tables (CT). Never used them, now I have. However, I have two questions: 1) How can I use a single CT where the rows are my categories and the Column fields are to be Cost, Price and margin? So what would be in the summarized field? I kind off faked...

Here is a simplified ouput Person-1 XXX cat-1 $1000 cat-3 $2000 Person-2 YYY cat-2 $2500 cat-3 $5000 Footer summary Category Totals cat-1 $1000 cat-2 $4500 cat-3 $7000 It is the footer summary that I need to display