Search results for query: *

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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