Search results for query: *

LB you were absolutely right. Thank you so much for the tip!

Ok, I just noticed that {cr_all_informal.Region} = {?Pm-cr_all_informal.Region} was in there twice. I have removed it and now the report is returning the correct results. The problem I am having now is that when I refresh the report I am prompted to enter 5 parameter. First 3 from the main...

Hello Bob, I have tried your suggestion and now the subreports are giving me zero results. Below is my record selection formula for both the subreports. {cr_all_informal.Region} = {?Pm-cr_all_informal.Region} and (({cr_all_informal.lvl1id} = {?levelinfoid}) or ({cr_all_informal.lvl2id} =...

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

Thanks Paul I will give this a try and share my resutls with you.

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

Thanks LB for the respone. I'll try it out on monday.

Hi Steve, I tried your crosstab approach and it seems to be working fine. The only problem is that I had the column headings displayed in the Page Header and now it is being displayed on the Report Footer page as well. How can I suppress it so that it displays everywhere else but not on the...

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

Thank you both. Both of the suggestions worked.

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!

I have tried your suggestion but it is still not showing in the proper(specified) sequence. I think the problem is that Group 1 (office) will not always have cases that have all the Statuses (Group 2). Is there any thing else that I can try? Thanks.

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

Thanks Dave!

I want to display it in the details section. I am not sure what the exact syntax would be. I do understand the logic but need help with syntax. Thanks for your help.

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