Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: maddyyikes
  • Order by date
  1. maddyyikes

    Rolling quarterly report

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

    Formatting cells having same pattern

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

    Formatting cells having same pattern

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

    Formatting cells having same pattern

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

    Loading Dynamic Text on a scrollbar

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

    Displaying details on mouse rollover

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

    Dynamic emailing help

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

    Need help with calculating business hours

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

    Need help with calculating business hours

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

    Formatting datetime stamp

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

    Combining running total formulae from two reports

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

    Combining running total formulae from two reports

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

    Reflecting accurate elapsed times

    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 :=...
  14. maddyyikes

    Adding custom bullets in MS Publisher

    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!!
  15. maddyyikes

    Conditional Highlighting

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

    Including null values in parameter fields

    Hi , Thanx a lot! ...but could u plz explain to me more specifically as to how I can exclude a few subcategories and select the others? Thanx in advance!
  17. maddyyikes

    Representing conditional texts in reports

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

    Including null values in parameter fields

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

    Displaying details in report

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

    Displaying count of records for a given month

    This worked out gr8 for me.....however I still have another problem remaining ! I have generated running totals as suggested by you in my previous threads but am unable to sort the top 10 records in descending order according to the no. of problems encountered for a given month. I do know...

Part and Inventory Search

Back
Top