Recent content by see123

Actually this table is temp table(Staging) to load the data from txt file. I use this table to load daily files and manipulate the data to load into my main tables. thanks for the suggestions......

Thanks for the quick reply George. I used SQL_Latin1_General_Cp1250_CS_AS for my table column which converted this column as ?. This will work. Is there a way I can convert this as pipe |. Once again thanks for the quick response

I am importing a txt file into MS SQL table. One of the column in txt file has special char as í. This char is loading into SQL as f. I am using format file to load the data. Any Ideas why this í char is converting as f. thanks in Advance

Hi Rudy thanks for your help. Is there a way I can display ID number where Addr field is null. In my first example it worked by using Min function. in some cases ID no is different. Here is the sample data. ID Name Addr 1 John 2 John 1234 data way 3 John 1234 Data Way 4...

I have a data that looks like this ID Name Addr 1 John 2 John 1234 data way 3 John 1234 Data Way 4 Peter 5 Peter 3456 P street 6 Peter 3456 P Street How can I display the above data 1...

Here is my Initial data Name Date Bonus ABC 1/1/2004 200 ABC 1/4/2004 200 ABC 1/7/2004 200 ABC 1/10/2004 200 ABC 1/2/2004 200 ABC 1/5/2004 200 ABC 1/8/2004 200 ABC 1/11/2004 200 I want to make this data to display like this Name...

I have field in DB as number X = .6250. I need to display this filed as 0000000.6250 Used a formula to convert this filed to fixed length ToText(X,"0000000.0000",2,"",".") But this number is rounded to 000000.6300 any ideas please

Hi, Iam trying to export my report output to CSV Sepearator Character as | and Delimeter as " everything works fine. But I have date field in the report which is Displaying as "1/1/2005". For dates I don't want to export in quotes. Is there any solution to pass the DATE without Quotes...

Hi Iam using crystal reports 8.5 This is how my data looks like AA 125.22 BB 114.00 CC 135.30 From above results I rounded the field CC to 135.00 by using formula-1 and stored the difference amount of .30 into another formula-2. Now I want to add the difference amount...

I want to insert a UP ARROW symbol in my report. does anybody know what is the shortcut key for this.

Iam using crystal reports 8.5 version. I created report with 11x17 paper size. Which is runnig fine in my local machine. When i call this report from my webserver report display format is gone and paper size is Legal. How can set paper size to my current report paper size?

Iam using crystal reports 8.5 version. I created report with 11x17 paper size. Which is runnig fine in my local machine. When i call this report from my webserver report display format is gone.Paper size is legal iam missing my data. How can i display this report with the same papersize (11x17)...

Hi KC, its displaying inactive count also. here is my @count: IF {rpt_SK_user_activities;1.Active} = true then 1 else 0 Count(@count)

Hi, My report looks like this Group : abc # users = 3 Count of active users ? Name date Status --------------------------------------------- aaa 01/01/01 Active bbb 01/01/01 Active ccc 01/01/01 Inactive Group : XYZ # users =3 Count of active...

Hi, How can i display the page nos(on each page) in on-demand subreports. thanks