Recent content by maddyyikes

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

The cells contain the quotation and comma characters via formatting. Thanks for all your help once again! :-)

Hi, Thanks for the immediate reply ...but I tried that as well, however it does not do it still.. please help..thanks in advance!

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

Could anyone please elaborate on the modifications that may be needed to be done so as to make this code incorporate business hour durations for tickets opened after hours as I am still not able to make any progress regarding the same.

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

Thanks much!!! I tried the same thing before but it did not work...guess I placed the parantheses incorrectly! Thanks a million once again! :)

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