Recent content by mnmdesigns

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!