Search results for query: *

Hi, I need to suppress drill down on the last group in my report and I don't know how? Can someone help? The reason I am grouping the last group is because I want to show a count for this group within the previous group. GH 1 Service GH 2 Category GH 3 Item if I show Item in details, it...

Hi, I did search tek-tips for answers but was not able to find anything BUT if the answer already exists, could someone guide me to the thread please? I have Work Start (Datetime) Work Stop (Datetime) When a resolver group starts working on a ticket, the datetime gets stored in the Work...

Hi Anyone: I'm trying to make a manual cross tab to show for each business line GH1 TP CS LAB And then for each month (always 3 previous months), I want to show total # of tickets for each GH1 December January February # Percent # Percent # Percent TP 29 15%...

Hi: I am scheduling about 50 reports to be run in CE and I would like to see a list of all the reports which are currently scheduled along with the frequency, example: monthly, weekly, every nth day, etc... I've been using the CSP query builder and I can't figure out which field would show...

Hi: I need to export a report every week with random information for all 40 agents. Instead of running the report 40 times, I would like to create one report and export 1 word file for each agent. Is this possible? I have to run the report at Midnight Sunday and email it to each different...

Hi: I need to group records by the time they were created. We have the option in Crystal to group for each hour, minute, second... How do I group for each 15 minutes? Thanks Jocelyne

I've uninstalled Crystal Reports from my server and I am trying to remove CR drivers which now say (Not marked) in the version and company columns of the ODBC Data Source Administrator. When I try to remove the CR driver from the System DSN, I get the following error: The setup routines for the...

Help Please!! I have 2 page header sections with a jpg file and 4 detailed sections. I want to display Page header A on top of the pages when detailed sections a,b and c are on the page. But when detailed sections d and e are displayed on the page I want to show Page header B...

Hi: I have a group which is a formula that concatenates 2 fields: {SRMIS_REQUEST.CC_SYSTEM_APPLICATION} & " / " & {SRMIS_REQUEST.CC_SYSTEM_APPLICATION_F} I am sorting by this group and the result is: NAT. HRDC JOB BANK ENVIRONMENT (JOB BANK) JOB BANK (KIOSK) / GUICHET-EMPLOIS...

I know that this is probably a very simple thing to do but I've been trying to do the following but I keep getting a cannot create total/summary errors: I am using Crystal Reports 8.5. My report has 2 groups: the Resolver Group Name and the Date ticket resolved along with a a count of tickets...

Hi: I am currently using a VB app which exports a crystal report file into a Word Document using the following at the end of the program: report.ExportOptions.FormatType = crEFTWordForWindows report.ExportOptions.DestinationType = crEDTDiskFile report.ExportOptions.DiskFileName...

Hi: I have 2 tables. Resolver Group table Client table 1st contact name Address 2nd contact name Phone number 3rd contact name Pager number Resolver group name Name The end result of the...

I've exported a crystal report to an HTML file and I would like to get rid of the gap that appears when you view the file with a browser. The gap is created because there is a page break at the name "Briére Rolland" . How can we get rid of this gap? The first line is the group and...

I am able to create a formula for a group header which allows me to include "Continued FROM previous page" in front of the value of the field in the group header by using the following formula: If InrepeatedGroupHeader then "continued.." & {RESOLVER_GROUPS.RG_NAME} else...

A report using the remedy odbc driver takes a long time to run. I was able to get 5,000 records in 20 minutes. If I use the oracle ODBC driver, it takes approximately 3-4 minutes. BUT I can't use the oracle ODBC driver because the datetimestamp in the diary fields are displayed in julien...

I know that validation should be done at the time the record is being submitted. BUT, we have a field that is not being validated at certain times and until we get it fixed, I need to be able to extract all records which do not have a valid value in this "System/application" field...