Search results for query: *

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

Thanks for the reply, I got the grouping for each person The content changes for each salesperson, that is of the 30 some categories each person may have from 2 to 10 and they are usually not the same. Is there a way to display the totals for each category in the footer section

I need to create subtotals for sales persons based on business categories. For each person I need to print the results. Here is what I have sofar 1) --------- Formula to initialize arrays whileprintingrecords ; shared stringvar array catDes := MakeArray("Hardware","Software",""); shared...

I have been succesful with several reports using the "Set Location" feature, thanks for the help In another report the rude response upon execution is simply "ODBC error". I have reviewed all I can think off, but am at a loss as how to proceed. Can any of you wizards point me in the right...

Did not realize that the same table names, variables, etc are used but that they point to a different table then it appears. I have verified that the "Set location" definition is correct, now I just need to get the data... Thanks for your help!!

I tried Database - Set Location (do not see Set Data Location) I select the table, browse for the replacement - select it and select SET It responds with "Propagate server and database changes accross tables with the same original information?" and clicked YES Could not detect any difference...