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: olushow
  • Content: Threads
  • Order by date
  1. olushow

    Listbox update

    I have a listbox that would list activities related to a training event. The event is the master record, while the activities will be the child record based on the tables relationship. i have an "Add Activity" button that will create the related activity and populate the listbox instantly. How...
  2. olushow

    Run Time Error '3464'

    I am attempting to filter out a subform when I select a value in a combo box, My problem is that whatever value I select I get the following error message: - RunTime error 3464 - Data type mismatch, and the debugger points to the 4th line in my code. Not sure where the data type mismatch is...
  3. olushow

    Specific Months

    I want to know how to pull data for a all the months so far this year meaning April, March, February, and January. As well as December,November and October of last year. The tricky part is that I have 4 sub-reports that need to pull information based on this criteria. This is a one time report...
  4. olushow

    Creating a report to run Quaterly.

    I need to create a report that would run quarterly. The report would run as follows For cases that were created between October 1 to December 31st first the report will run Jan 1 For cases that were created between Jan 1 and March 31st the report will run April 1st For cases that were created...
  5. olushow

    Percentage of Resolved Cases

    I am having serious difficulties in trying to do a percentage of Resolved Cases. My report pulls all cases within a specified date range. So far I did the following. Created the following formula - //Resolved If {HPD_Help_Desk.Status} in ["Resolved", "Closed"] Then 1 Then I created a...
  6. olushow

    Average Response time

    What is the proper way to average the response time between a submit date and a resolved date.. Assuming the following Submit Date - 01/12/11 08:30AM and Resolved Date - 01/13/11 - 4:15pm Assuming response time = Last Resolved Date - Submit Date How will I average this out in Crystal Reports.?
  7. olushow

    Include Null Values

    I have a report that lists tickets created daily by a certain Help desk group.(The report has date prompts) The report works fine, but the way it works now it will not list days where no tickets were created as part of my report, meaning null value. How can I include dates in which no...
  8. olushow

    How to Create Weekly Groups starting Wednesday

    I'm using CR10 and trying to create a line chart which has a weekly running total of tickets opened based on customer company. For Mondays through Sundays...--- 12/06, 12/13, so I can summarize the total number of tickets opened for all companies, on a weekly basis. How do I create the weekly...
  9. olushow

    Upgrading the processor.

    What is the process of adding a license to a new processor in a box. Meaning we currently have a single Core, and are in the process of adding another one. How do we implement the new license to the additional processor. Can anybody point me to the right direction\site?
  10. olushow

    Text manipulation - Diary field.

    Does anybody have any ideas on how to place Diary fields in a report. I have a field on the report that is basically an audit trail of any action taken on a single record. The field obviously has a lot of data in it. Can anybody provide me with some guidance on how to data from a Diary...
  11. olushow

    Two Subreports

    I have a report with two subreports. The first subreport works, but after adding the 2nd report. I keep getting the 'not supported' error messsage. Is there a general rule when using subreports, in terms of how many subreports you can put in a report? I checked compared the Subreport links to...
  12. olushow

    Grouping

    I am having the following problem. Company - Company A Company - Company B Org - Org A Org -Org B Dept - Dept A Dept - NULL I created the following formula to group certain data with a concatenation of Company + " - " + Organization It works for when there is a...
  13. olushow

    Formula

    I am writing the following formula against a SQL Server database, it works against an Oracle database. It seems to give me values for either one of the other but not both. Do I have to rewrite it? Or is it a SQL Server thing. if {HPD_Help_Desk.Status} in ["Resolved"] Then datediff ("D"...
  14. olushow

    Formula to sort record regardless of a group

    Is there a way to sort a report, even thought there is an existing group. I was able to sort each record within each group, but it seems the client want the records sorted regardless of the existing grouping.. For example. Records are grouped into the following East Coast, West Coast...
  15. olushow

    CMS always stops

    It seems that every morning ( for the past couple of days) CMS is in stopped status, I have had to manually restart CMS twice.. Can't see anything helfpul in event viewer. Can someone point me to a log file I should be looking at, or at least point me in the direction, in terms of pin-pointing...
  16. olushow

    Wildcard in parameter

    I have a report with parameters where I want to select specific Status states. I want to use a wildcard entry '*' in the parameter field, when I want to return all the status e.g. Assigned, Resolved, Pending..etc.. I used the following statement in the Select Expert Window Can anyone please...
  17. olushow

    Configuration for multiple environments.

    What is the best way to setup connections to multiple server environments ( Testing, development, Production)?Assuming I setup an odbc connection for each environment, and run a report. How do I make sure that when I upload the report via CMC into a specific folder that I created,that the folder...
  18. olushow

    Populating Listbox based on Combo box selection.

    I am attempting to populate my Listbox with data, based on a selection in a combo box. What I am finding is that the Listbox is being populated with the actual select statement. Obviously, I'm doing something wrong, just don't know what it is. Should I also be putting some kind of code in...
  19. olushow

    Populating database from a listbox.

    Scenario, Initially I had a form with approximately 40 combo boxes, based on a suggestion from another discussion group(actually Microsofts support group), I decided to use two listboxes, one text box for the batch number and two command buttons (one to close the form, the other to append the...
  20. olushow

    Append values from a Listbox to a Table.

    Scenario, Initially I had a form with approximately 40 combo boxes, based on a suggestion from another discussion group(actually Microsofts support group), I decided to use two listboxes, one text box for the batch number and two command buttons (one to close the form, the other to append the...

Part and Inventory Search

Back
Top