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...

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...

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 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...

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 am using Crystal 8.5 Our data base has table names such as INC_USA_Employees INC_USA_Offices and another set of tables like INC_CAN_Employees INC_CAN_Offices My report is based on the USA tables and lots of formulas and definitions How can I copy that report and replace all USA tables...

I want to include an Excel spreadsheet as part of my Crystal report. I cannot figure out how to do so. Do I have to create it as a table in my of my data bases? Any help appreciated

Our customer data base has six fields for "account manager" if none assigned the value is either -1 or 0, else it has a UserID value that I can translate to a name. Here is the record selection method i need. It works fine if I use the first three selections, when I submit as below, it times...

I have several reports looking at an SQL data base. I now want to include an Excel spreadsheet to add additional functionality. I have looked at the forum, but could not find the answer to the following: - Can I just access my spreadsheet as is, it has a header. - When I go to Data base /...

I am trying to extract the third table entries such as salesDes = "Sold to 1234567, products ordered XX4567 " or salesDes = "Sold to 456" or salesDes = "Sold to 54321,none delivered" etc I need the number 1234567, 456, 54321. It is followed by a space or a comma Found a reference to this...

The data base name that contains the views is being changed. How do update all the reports (more than 100 of them!)?

Using Crystal 8.5 The data base name that contains th views used to create the report is being changed. Is there a way to update the reports?

Using Crystal V10. My group header has many entries and I use the "group sort expert" to sort by size. Output example Name1 200 Name2 150 Name3 115 Name4 66 etc I define "how many to use", say 2, I then suppress printing of name3 and higher. In the chart I want...

I am using Crystal 8.5 and need a formula to create a date that always displays the first of that month date, such as: field name is {forecast.CloseDate} 9/25/2004 -> 9/1/2004 12/16/2005 -> 12/1/2005 etc Thanks in advance

I have to create a consistent set of names for display using V8.5 Here are a sample of what the data base has and what I need to display Data base content -> Display on report Smith, Joe -> Smith, Joe Smith-ROME, Joe -> Smith, Joe Smith-Eastern, Joe -> Smith, Joe What is...

How do I create a select statement that lets me select companies names starting with a,b,c,etc through whatever. I typically would need do select: a-h, then i-n, then o-z I am running V8.5

I return a sorted shared array from a subreport which contains names by number of transactions. In the parent report I want to create a group based on the entries in that array in the same order. I created a formula to do so and it shows the correct names when I insert it in the report...

I have posted one similar to this and a usefull link http://support.businessobjects.com/communityCS/Tec... was suggested by someone. The document got me about 95% to what I needed. However, I can only get one bar (of a bar chart) to display. Even though the arrays look correct. Anyone has...

Report: Show the top ten users and the top fiftenn websites they visited AND add the total browse time for those sites I calculate the time difference between two succesive browse records and store that for future use. Here I am in trouble already: Not knowing which sites I need to save, I...