Search results for query: *

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

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

Hi, I have a date field called Table_create_date.It should select the data of previous seven days everytime i run the report. I am using crysatl 10.0 and oracle 9 Thanks,

Hi, I have a report where i need to select the data from two databases. I am getting names fields and company information of the customers from 5 tables in one database and address information from 1 table in other database. I created a subreport for the address information. When i run the...

Hi, i want to design a report from two databases. i have 25 fields to be included in the report from the two databases and i am also not sure how to include the 25 fields in the report as all should be in the details section. i am using crystal 10.0 and oracle 9 Help is appreciated. Thanks

Hi, I have a report with five fields program, activities,name,target and status. Report is grouped on program and activities. Programs have multiple activities and some activities don't have programs.I want to display all the activities only which have programs. I am using Crystal 10.0 and...

Hi, I have 5 parameters 1) OwnerName 2) Offerings 3) from date 4) to date 5) status All the parameters should be optional except from date and to date. These are the conditions how i select the parameters 1) name, from date and to date 2) offering, from date and to date 3) status, from date...

Hi, When i am trying to login in to enterprise or CMC it's giving me the following error. Unable to connect to cluster @webserver.com to retrieve updated CMS member list. Logon cannot continue. i am using crystal enterprise 10.0 and oracle 9 Thnaks in advance.

Hi, I am getting this error when i am trying to log in to enterprise CMS host 'LJOHNSONXP.COM' can be contacted, but there is no CMS running at port 6400 When i start the cms and try to log on,it is giving me this error Transport-Communication error can someone help me out? I am using...

Hi Synapse, Saving i mean setting the destination to a folder on the web server and also i have set the default printer the same one i used during designing but it still gives the same error. Thanks in advance

Hi All, i am new to crystal enterprise. i want to schedule a report and save the instance on my web server. i am not sure whether its possible or not. i am using crystal enterprise 10 and oracle 10 when i schedule a report i am getting this error No default printer. File C:\Program...

Hi, I have 5 parameters 1) OwnerName 2) Offerings 3) from date 4) to date 5) status All the parameters should be optional except from date and to date. These are the conditions how i select the parameters 1) name, from date and to date 2) offering, from date and to date 3) status, from date...