Search results for query: *

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 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 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 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 I am using Crystal reports I am using a sub report within a main report As I could not use a page header in the sub report, I am using a psuedo group as a page header for the sub report I am using the property of "Repeat Group Header on Each Page" in the Change Group Option Now, this seems...

Hi I am using crystal reports10 I could not open up a crystal report Whenever I am trying to open that report I am getting the error "crw32.exe has generated errors and will be closed by windows" and entire crystal reports application is shutting down by itself I could not open up a...

Hi I am using Crystal reports 10 I have a sub report with its page numbers in the page footer section of the sub report Now ,when I imported that sub report into the main report the page footer section is missing and I am not able to see the page numbers All that I see is the page numbers of...

Hi I am using Crystal Reports 10 I am trying to share variable values within sub Reports I am having two Sub Reports inside a main report. They are Report A and Report B In Report A, I have a variable, which is as follows Shar_Var whileprintingrecords; SHARED numbervar shar_var := 10; I...

Hi I am using Crystal reports 10 Whenever I am importing a sub report into a main report The page header section of the sub report is being changed into report header section I would like to avoid that before the import data was there in the page header section of the sub report After sub...

Hi Thanks Ibass and Turkish bear for your responses Actually I knew what the problem was The report1 itself has a sub report rep_sub built in it When I am trying to insert the Report1 as a sub report into the Main report , the sub report within the sub report (ie sub_rep) is not getting...

Hi I am using Crystal Reports 10 I have two sub reports Report1 and Report2 in the Main report, in a group header Now I need to insert Report2 below Report1. The thing is , Report1 is running into 30 or 40 pages and cannot determine exactly where I need to place the Report2 Can someone...

Hi I am using Crystal reports 10 I have a multiple value parameter field I am storing the values of employees number in the parameter field '{?emp_no}' At the beginning of the report I entered 10 empployee numbers 10, 20 , 30..etc Is there a way that I can construct a formula field which will...

Hi I am using Crystal reports 10 I am retrieving the employee details I will be giving the employee number as the paramater as for that parameter value I was able to retrieve the values For example , if passed {?epm_no} value as 10, all the employee with number 10 used to come up If I...

Hi I am using crystal reports 10 In the data expert section, I am fetching the data from backend table using a command I need to fetch all the employees based on a divisioon number which I give as a parameter The query which I am giving is select * from emp where div_no = '{?div_no}'...

Hi I am using Crystal Report 10 I have a sub report, which is included in the main the report There are some variables which are shared between sub report and main report The total sum got from sub report is taken as a shared variable in the main report calculations The problem is.. Whenever...