Search results for query: *

Thanks for your response There are hundreds of records in the report2 which I am passsing as a sub report Placing this sub report in the main report is causing this subreport to be repeated in every change in group value So it is consuming hundreds of pages Also , evne though I am using the...

Hi I am using Crystal Reports 10 I am having two reports The two reports are got from two different tables Each employee is given two types of tests The two tests results are stored in two different tables emp_Test1 and emp_test2 The employee takes the test1 2 times and takes the test2...

Hi There would be abt 20 - 30 different groups . How do I pass on the values of Sum(sal) for those 20 - 30 groups from the sub report to the main report Thanks

Hi ianoctdec thanks for the reponse I have the report which displays the employee data grouped on division If I do it by a command, then it might not get values of the individual groups numbers that are there inside the report within the report, for whatever division that is being...

Hi Ianwaterman Thanks for your response Actually I would like to create a seperate column field which would calculate the sum of salaries for a division All employees are grouped by division So in the group footer of division so this formula is placed beside the division number Hence I...

Hi I am using Crystal reports 10 I need to create a formula field / SQL query field which looks like this Select sum(sal) from employee where div_no <>'05' and start_date ='01-jan-2004' and mgr = {'?mgr}' where {'?mgr'} is the parameter which is being entered How can I do it ? I need to...

Hi Wichitakid I am not aware of the data base in the main frames All that I get from my manager are the csv flat files with data I would be building the report from these flat files I wish I could give information on this . But my knowledge on this limited . I aplologize for that Can we...

csv files are got from main frames .. I am not aware of the making for the csv files There are certain conditions in the bonus report like if montly bonus < 25 then montly bonus = 25 else montly bonus if montly bonus > 500 then montly bonus = 500 - .16 * montly bonus else montly bonus...

Hi Thanks both Wichitakid and Turkishbear for your suggestions Actually I need to get the montly group totals from the bonus report to be shared to the basic salary report I could not just dump in the individual values because There are individual formulae which are governing for calucalting...

Both the reports are from 2 different flat files Bonus.csv and Employee csv Again the values ..Salary and Bonus ..which are displayed are again group values and not individual values The values in the flat files are weekly values I am grouping them together to get monthly values It is the...

Hi I am using Crystal Reports 10 I am having two reports for discussion I am using a report which has the fields employee number , employee name location, division and Bonus There is another report which has the fields employee number , employee name location, division and Base salary...

Hi I am using Crystal Reports 10 I am having two reports for discussion I am using a report which has the fields employee number , employee name location, division and Bonus There is another report which has the fields employee number , employee name location, division and Base salary...

Hi There are 8 types of directions 01 - north 02 - south 03 - east 04 - west 05 - southeast 06 - southwest 07 - northeast 08 - nothwest The user may enter any directions of his choice For that directions , he entered .. The sales amt are calculated in the individual states Once all the...

Hi Ibass Thanks for your message Infact I am looking for is slightly different The grand direction totals need be done only after the indidual states direction totals are done In my report , I need to show both the individual totals as well as the grand group totals Again the directions are...

Hi I am using crystal reports 10 I am having different groups in my report I am taking report state wise of the sales data. I have a field which is sales_amt Each state is divided north direction, south direction east and west direction I take the sum of the sales direction wise ie...

I am using Crystal REports 10 I am having a group which keeps repeating on every page as a page header Now this group is also printing in some blank pages even after the data printing is over I want to eliminate this How can I do this ? I have unchecked the "KEEP TOGETHER " check box in the...

Hi I am using Crystal Reports 10 In my report , I am using a string variable. But it has unnecessary character "*" repeating in 5 - 6 instances . How can I replace that value "*" with a blank space " " . Could some suggest code? thanks Srini

Hi I am using Crystal reports 10 I was retrieving values from the employee table using a Command The command I am using is "select * from employee where dept_no ='{?dep_no }'" {?dep_no } is the parameter , I am using to retrieve the department number Earlier, I was submitting only one...

Hi I am using Crystal reports 10 In my report I have two parameter fields Parameter 1 and Parameter 2 Hi I am using Crystal reports 10 In my report I have two parameter fields Parameter 1 and Parameter 2 Actally they are {?emp_deptno } and {?dept_deptno} Earlier the users used to enter both...

Hi Lbass Thanks a lot for your suggestion It worked Thanks a lot to you