Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: busi1
  • Order by date
  1. busi1

    Suppress data

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

    Suppress data

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

    Suppress data

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

    help with formula

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

    help with formula

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

    help with formula

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

    problem with group formula

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

    Supress Duplicate records

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

    Selecting data based on dates

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

    Selecting data based on dates

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

    Running Total

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

    Running Total

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

    Running Total

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

    Running Total

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

    select top n rows

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

    suppressing blank page

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

    selecting data

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

    selecting data

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

    selecting data

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

Part and Inventory Search

Back
Top