Search results for query: *

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

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?

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

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

Hi, How to find out the Average login time. My Result set NAME ID STATUS LOGINDATE abc 1234 LOGN 2002-12-02 11:19:29.207 abc 1234 LOGOUT 2002-12-02 11:21:29.207 abc 1234 LOGIN 2002-12-02 11:22:32.200 abc 1234 LOGIN 2002-12-02 11:30:32.192...

Iam getting the above error when iam refreshing rpeorts more than 5 times. Any Idea. Thanks much

Hi All, Iam having a problem when iam trying to refresh my report at run time.If a pass a one parameter to the report and execute it works fine. and I tried to refresh the report with same parameters then my report is refreshed with all the values not based on the current parameter. Iam using...

Hi All, Iam having a problem when iam trying to refresh my report at run time.If a pass a one parameter to the report and execute it works fine. and I tried to refresh the report then my report is refreshed with all the values not based on the current parameter. Iam using RDC for dispplaying...

Hi to all, can any one tell me how to unload the formcontrols. This is where iam loading controls using control arrays.If i click on the listbox form controls shoulb be unload help me out pleaseeeee Private Sub lstReportList_click() Dim cboIndexParamList As Integer Dim dtPickIndexParamList...

Hi, Iam having some problem while displaying crystal report at vb runtime here is my code in the form level i declared Dim ADOcnn As New ADODB.Connection Private Const MAPSMACHINELIST = "rpMachineTest.rpt" Private Sub cmdPreview_Click() Me.MousePointer = vbHourglass...

Hi, My result set is looks like this col1 col2 col3 col4 col5 ============================= AA1001 1 01/01/01 John 1 AA1001 1 01/01/01 Jack 1 AA1001 1 01/01/01 Jill 1 AA1001 1 01/01/01 Ann 2 AA1001 1 01/01/01 Rob 2 AA1001 1 01/01/01 Chris 2 I want to...

Hi, when iam trying to place a datafield called actiontext varchar(1000) in crystal and try to view that report it says NOT SUPPORTED.Iam using OLE DB. can any one help me thanks much seethu