Search results for query: *

Hi all, I am using CR 10 with SQL server 2000. I have a report that contains two subreports in the report header. The main report has three parameters and one group. The parameters are 1. fromDate(date) 2. toDate(date) 3. levelinfoid(number) The problem I am having is that the main report is...

Hi all, I am using CR 10 with SQL server 2000. I have a report that contains two subreports in the report header. The main report has three parameters and one group. The parameters are 1. fromDate(date) 2. toDate(date) 3. levelinfoid(number) The problem I am having is that the main report is...

I am using CR 10 with SQL Server 2000. My groups are based on the formula which is like this. if (not isnull({cr_activeemployee.formal_filed})and (not isnull({cr_activeemployee.issued_accpt_ltr})or not isnull({cr_activeemployee.issued_part_accpt_ltr}))and...

Hi all, I am using CR 10 with SQL server 2000. My question is regarding adding group totals at the end of the report. I have a group in my report based on State. So when I run the report I could have several groups. Currently I am calculating the number of tickets in the group footer. Example...

Hi all, This might be a very simple question but can someone please tell me how can I use the Page N of M on each group? I have a report with two groups. I would like to change the page number whenever group 1 changes. Thanks in advance!

Hi all, I am using CR 10. I have two groups in my report. Group 1: Office (field in the db) Group 2: Status (formula) Group 2 formula: if isnull({field1})and isnull({field2})and not isnull({field3})then "Status 1" if not isnull({field1})and isnull({field2})and not...

Hi all, I have created a report using CR10 which has one group. I want to diplay a message that says "0 Records" when the details section has no records. How can I do this? Is there a function in Crystal that I can use for this?

Hi all, I need some help in writing a query. I have two tables A and B. Both the tables should ideally have rows the ID field. Table B can have more than one rows associated to that ID but there should be atleast one row. Unfortunately, that is not the case. I need to find out all the ID's that...

Hi, We have MS CRM 1.2 installed over here. We were trying to install outlook for CRM with the CD provided from Microsoft. When I try to install the outlook component I get the following message: "Your Microsoft CRM Server application has not yet been upgraded. Upgrade Microsoft CRM Server...

We have MS CRM 1.2 installed over here. When I try to access the CRM from the web it works fine. When I go to the server and try to access the User Manager under the Deployment Manager, I get the following error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.(80040e4d) Can...

Hi, I am using SQL server 2000 and have some DTS jobs. These jobs are scheduled to run every night automatically. The jobs failed this weekend and now when I try to run the job manually I get an error message stating that the Transaction log file is too big. When I go to view the size of the...

I have a problem. I am using Internet Explorer 6.0 When I go to a certain website I get the following error message: "A runtime error has occured. Would you like to Debug it now? Line : 0 Error : Invalid Character Can someone please tell me what this means or how can I fix this? Thanks in...

Hello, I am using CR8.5 Professional Edition. Whenver I click on the help file, I get a message "Help has not been setup. Please run setup again". I have tried to run the setup but I still get the same message. I also tried uninstalling CR totally from my computer and installing it again. Can...

Hi, I currently have CR 8.5 installed on my machine. Is it possible to have CR 8.5 and 9.0 both installed simultaneously on my local machine? I have to design some reports using 9.0 but do not want to upgrade for now. Thanks in Advance.

Hi, I am using CR 8.5 with a SQL server 2000 backend database. I have a string field which has data like {YYYYMMDD}. I am trying to convert it into {MM/DD/YY} Please note that I need to add the "/" and then only show "YY" instead of "YYYY". Thanks in advance for...

Hi, I am having problem with Group and record selection in my report. Here is what I am trying to do. First I need to have a group where the {Employee.Position} has to be manager. In my case it would be {Employee.Position} = "MANAGER" Then I only need to show those reocords in the...

Sorry this might be a very simple question but had to ask. I have data field in the details section. Sometimes if there is no data in that field it shows up blank in the preview mode. I would like to replace the blank value with a zero. How can I do this? CR 8.5 Thanks in advance, MD

Hello, I am new to Crystal Reports. I am using version 8.5 and a SQL server 2000. I have been working on one report which had around 10,000 reocrods. So far the report was running fine. I have added a new summary field and this is just freezing the Crystal Report. I am running the SQL server on...