Search results for query: *

Hi, I am new to BO and am trying to generate a rolling quarterly report. The universe has a fiscal year and fiscal quarter field (values 1,2,3,4). I would like to know as to how I can generate the current and prior quarters within the cross tab report relative to the current day? Also, when...

Hi, I have the following two cells on my spreadsheet with the values: "Jack", (cell 1) Daniels (cell 2) I am trying to get the double quotes and the comma for Daniels as well but am unable to do so for some reason. I have tried doing a paste special and the custom field properties...

Hi, I have the following problem with the code, obtained from Dynamic Drive, as shown below. The code works fine for displaying static text. However I want to know whether the code can be modified to include dynamic text (data contained in an excel spreadsheet and updated periodically in...

Hi, I have an Excel / HTML file which contains the summary pertaining to a ticket , for instance Log No. Location Time 12345 Charlotte 10:30 a.m. 23456 xxx xxx The above information is stored as an Excel spreadsheet and housed as an...

Hi, I have the following piece of code used for sending it to a predefined mailing list such as cthompson@yahoo.com However there is a field labeled "email" in a given form, from which I need to pick up the values and use them as a data feed for this PHP code. Simply put, I need to distribute...

Hi, I obtained the following code snippet from this site used for calculating business hours between the opening and closing of a ticket. The code seems to accurately count business hours for all tickets opened during the business hours. However, the code gives me incorrect values for any...

Hi, I have used the following code from this site to calculate business hours for my report. I am using Crystal Reports 8.5 local numbervar numDayStartHour:=8; //The hour that work starts in 24 hour time. local numbervar numDayStartMinute:=0; //The minutes value of the time when work starts...

Hi, I have two different reports that have the following outputs: (Crystal Reports 8.5 & Proprietary DB)) First Report: (open incidents) AgentName No. of Open Incidents Total of all over SLA Incidents Mike Parker...

Hi, I have two fields in the database named {probsummarym1.opentime} and {probsummarym1.closetime} They are datetime fields. I manually calculate the difference between these two times by using the following formula: numbervar tsecs :=...

I would like to know as to how to add custom bullets created and stored in MS WORD into MS Publisher. Its highly urgent !! PLZ HELP! Thanx in advance!!

Hi! I have generated the following report using CR 8.5 The database used is P4 (proprietary) and ODBC drivers are used for interfacing purposes. The report that I have generated is as follows: Cat_SubCat_ProbType Total S/W_Outlook_How To...

HI! Using: Crystal Reports 8.5 P4 Database(proprietary) ODBC driver I want to describe different texts in the same text box for a given report depending on the condition/s being satisfied. For instance if I am running a report which returns the most catastrophic problems being...

Using: Crystal Reports 8.5 P4 Database (proprietary) ODBC driver I have a field called "SubCategory" in the database. It has the following values: Mainframe Security Network Infrastructure Hardware Desktop Software ....and so on(about 50 values) I have the following...

Hi, Using: Crystal Reports 8.5 P4 Database(proprietary) ODBC driver I need to display around 9-10 fields in my report.Some of the fields contain the description of a given problem which may span several lines. The "Problem Description" and "Problem Resolution" fields for...

I have a graph which gives me the no. of calls logged over a given period of time (No. of problem types encountered v/s each month in 2004 starting from Jan, Feb ......., Dec.) The statistics (report) for the same is being correctly displayed for the current year to date. Even the graphs are...

Using: CR 8.5 P4(proprietary database) ODBC driver I have to display the following report: Department Jan Feb .... Dec YTD(year to date) Security 500 600 2450 Mainframe 250 100 1780 Intranet 750...

HI, I would like a report to be generated in the following format: Problem Problem Problems Problems Change Description in July in June ID/Pwd Logging prob. 56 45 11 Novell Security...

Could you please let me know of a way to display the no. of occurences of a duplicate records without actually counting it every single time.for e.g., Record Count Desktop s/w 1 Desktop s/w 1 Desktop s/w 1 I would like to display...