Search results for query: *

Hi lbass, Thanks for the above solution, priority worked except it's not pulling the right count of families for the programs. Below is the running total I created for the family counts and placed it in the program group footer. Running total for count of families: 1) distinct count of...

Thanks for the reply lbass, it worked fine. But what if the families are associated with more than 2-3 programs and I need the count of families in this program order 1) 88304 2) 87801 3) 88302 4) 88102 (The report has to determine the priority order, say if the family is associated with the...

Families Programs county 110012719 88102 214 110012719 88102 214 110012719 88304 214 110012719 88304 214 110012720 88304 214 110012720 88304 214 I need the distinct counts of families for programs for every county. But I want distinct count of families...

sorry Brian, I might have mistyped 1 in first line ...({table2.DUEDATE2} <1 currentdate)). There is no 1 in the line. I replaced you code with my dtabase fields and see the all the records are falling under overdue (some of the records are satisfying the 2nd condition and still seeing them under...

Thanks Brian, I tried it and it's still not working. One more thing not sure if this is the case. table2 is empty in the database (do you think as there is no data it's failing at first or condition) if so how can write to check if that column has no data and still go thru all the conditons in...

I'm a using crystal reports 2008 & oracle 10g. I'm grouping the report where the data from 2 different tables has to be displayed under the respective groups based on the logic. Here's the formula if ((DateAdd('d',30,{table1.APPDATE1}) < currentdate) or ({table2.DUEDATE2} <1 currentdate))...

I'm new to crystal reports and I'm using crystal reports 2008 and Oracle 10g. I created a group on the below formula.All the records should be displayed according to the logic in the formula. if ((DateAdd('d',30,{table1.RECD_DATE}) < currentdate) or ({table2.DATE} < currentdate)) then...

Hi, I have a report which displays the following data. PO Number PO Date Vendor 111111111 01-01-07 xxxxxx 111111111 01-01-07 xxxxxx 111111111 01-05-07 xxxxxx 111111111 01-05-07 xxxxxx 111111111 01-06-07 xxxxxx I want to supress the Duplicate PO numbers and Vendors if...

Hi Synapse, Thanks for your reply. Say for example i have 300000 total records, i want records came in from april 27th 2006 till date( One year recency) in the same way the other two. I have like couple of parameters in this report. I want to pull this recency data based on a field called table...

Hi, I am trying to select the data based on the recency. I want to show the total number of records in this format. ---------------------------------------------------------- 1 Year Recency 2 Year recency 3 Year Recency I want to create a formula where it selects the most recent...

Hi LB I tried evaluating the fileds using that formula and placing all the fields in detail section, but all the fields for each cost center are populated multiple times(cost centers displayed multiple times) I have budget and other funds for all the periods ( i checked it by running the...

Hi ibass, I tried Using that evaluation formula, its giving me a blank report.

Hi, I have a report which Looks like this: Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec Budget Forecast Committed Spent Accrual Total All the five fields in this report ( Budget, Forecast etc..) are caluculated fields in the view i created for this report. I have 6 Cost...

Hi, I have a report which Looks like this: Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec Budget Forecast Committed Spent Accrual Total All the five fields in this report ( Budget, Forecast etc..) are caluculated fields in the view i created for this report. I have 6 Cost...

Hi, In a table i have 3500 records with different employee toltals(ult_tot).I would like 500 contacts from the largest companies, one contact per company(there are duplicates). The ULT_TOT is the field to use for company size. Ideally I would like a split of payroll and IS/IT contacts...

Thanks Synapse

Hi, I have placed 2 subreports in detail A and Detail B of the main report. When i run the report, subreport in Details A section is bringing the data where as the 1st page in the 2nd subreport placed in Details B is blank. I want to suppress the blank page. Help is appreiciated... I am using...

Hi, i will do the grouping as you suggested, but i have question whether i can still display the committed funds and invoices by monthly wise. My design of report looks like this. Jan Feb Mar Apr May June July Committed Funds Invoices Accruals Thanks

Thanks Turkbear for the reply, for example: i have a committed fund for 1000$ in january and i have a one invoice paid against it for 400$ in january and the second invoice against the same committed fund paid in may for 400$. Now the two invoices should be added and placed under january for...

Hi, I have a report in this format jan feb mar apr may june july Committed Funds Invoice Amount Accrual(committed-invoice) For every committed fund there are some invoices. Eg: If i have a committed fund opened in Jan and it has two Invoices against it ( one...