Search results for query: *

Thanks a lot 'Replace' did the trick!!!!!

Hi, I have backup data from SQL Server 7.0 and now when i'm trying to restore it into SQL Express 2005, I'm getting following error...... -------------------- Msg 3154, Level 16, State 2, Line 1 The backup set holds a backup of a database other than the existing 'GOSLDW' database. Msg 3013...

Hi, How i can load sample database 'Great Outdoors Sales data warehouse' into SQLExpress? I really appricates your help in this. Thanks, R

Thanks for quick reply. When i'm draging with + sign i'm getting same value as B2 in this case 11 in all the rows. it's copying value not formula. Any idea why? -R

Hi, How can i get following result in Excel? A B Length Start 10 1 25 11 10 36 20 46 Here A is length and B is starting position after adding column A. So at B1 it start with 1 but B2 is B1 + A1 and for B3 A2+B2. Which...

Hi, I'm novice to Unix. How can i ftp file from Unitx to my local PC desktop. Could someone tell me step by step commands to do this? Thanks in Advance, R

Hi, I'm using Crystal-10 DB = ORACLE I have report in which i have two formulas and wants to show formula as per group's value. These formulas calculate employee expense as per department number. So if there is DeptNumber = 001 then I would like to use Formula1 and if DeptNumber = 002 then...

Hi, I want to display some formulas as per group name. How can I do that with Crystal 10? Colm1 Grp1 Formula1 Grp2 Formula2 I know I have to put some code in Formula's suppress section. But I don't know what type of expression I have to put to suppress...

Hi All, Is it possible to run crystals report from command line prompt with parameters? I would like to run some reports in batch process with different parameters by using Windows scheduling. Can anyone share his or her experience? I’m using CR 10. Thanks, -R

Ido, Can you please describe in detail? Thanks, -R

Hi, I need some ideas that how can I develop below report, I have requirement in that I have to display employees who has made expense above average for department. And report should display average for whole department. Report is grouped on department. Report format is like, Hotel...

Hi, I have one report in which I need nested parameter, like base on selection of first parameter value second parameter should display values and sameway upto last parameter. I have total 4 parameters, First one on Country, second parameter is Region, third parameter is Division & fourth...

Thanks this is what i was looking for. Thank You

Hi, I have one report in which I’m using two tables Region & SalesSummary. Region table contains department structure and SalesSummary table contains summarized 12 months sales data with department ID. Now in my report I want to display all regions (group of departments) irrespective of their...

Hi, I have parameter field, which is drop down list from one of table field, displays Department name. I want to put Dept1 as default value so if user doesn’t select anything from list report should filter out data for Dept1. But if user selects any other department value then report should...

Hi, CR10 I have report in which I’m using report total within one of calculated field but I’m always getting 0 for report total within calculation. Dep1 10 Dep2 20 Dep3 10 Cal 60-10=50 <-This is calculation. (Dep1 – Total) Dep4 10 Dep5 10 Total 60 How I can change...

I also have similar situation. What is ianoctdec's formula?

Hi, Can subreport contains subreport? Like Report A contains Repport A1 as subreport and within Report A1 there is another subreport Report AA1. Is this possible?

Hi, I'm using CR10 I have report format like this(it is mannual crosstab), ------- Grp1 Revenue $4,000.00 Grp3 Comm and Floor Brokerage $200.00 Grp3 Compensation and Benefits $100.00 Grp3 Occupancy...

Hi, I'm using CR10 with Business View. I have couple of questions, 1. Is it possible to add 'SELECT' statement in Formula Field or SQL Expression field? 2. Is SQL expression field feature unavailable? I don't see in field explorer window. Thanks, -R