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,
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.