Search results for query: *

Hello, I have a data in following xml format <GraphData> <days>10</days> <yield stream="mystream">100</yield> <yield stream="yourstream">200</yield> </GraphData> <GraphData> <days>20</days> <yield stream="mystream">250</yield> <yield stream="yourstream">300</yield>...

Hi, I have many columns in my excel worksheet ( upto "AS" ). When it opens up, by default it is scrolled to the rightmost column. I want to see the first column ( A ) on my worksheet open. i.e. scroll to the left most. Can anybody please tell me how can I achieve this using VBA ? Thanks, Prasad

Hi, I am using Ant 1.6.2 to FTP files from unix server to local windows folder. following is my code, public static void getFiles(String ftpServer, String user, String pwd, String fileName){ try{ FTP ftpclient = new FTP(); FileSet fs = new FileSet(); File destination = new...

Hi, When I export the report to Excel, the values in the report span over 2-3 columns or rows of excel whereas I expect it to occupy only one cell per value. Is there any way of correcting this ? Also is there any way of coloring the excel cells same as report ? I am using v10 of CR and...

Hi, I would like to export different reports to different tabs of the same excel workbook. Is this possible in Crystal Report ? Thanks & Regards, Prasad

Hi, I have created cross tab report which shows sum of expenditure on each user from each department for each month in the following format March April May June Admin John 100 110 110 115 Peter 200 200 210 205 Finance Rita 110 110 110 110 David 200 200 210 220 What I would like to...

Hi, I am running sybase stored procedure using pass-through query. I want to get the output of this stored procedure into one table in my access database. I tried OutputTo excel and then TransferSpreadsheet to table. But as procedure output is more no of records ( > 30000) , it gives error...

Hi, I am running sybase stored procedure using pass-through query and want to send the output to excel worksheet. DoCmd.OutputTo acOutputQuery, "runSP_VolumeCompare", acFormatXLS, sFileName Query returns around 30,000 records. I get following error when I try to send that output to excel...

Hi, What I currently do is : I run stored procedure in Sybase using SQL Advantage. Store the result in xls file and import that xls into Access to create table. But this requires lot of manual process before I get the data into Access and start working on it. I was just wondering if there is...

Hi, I have created one form with two combo boxes and button.When I select options in two combo boxes and click that button I would like one form to open in "datasheet" type view with the records filtered on the conditions selected in combod boxes. Could anybody please help ? Thanks, Prasad

Hi, When I try to register one ocx file using regsvr32, it doesn't get registered ( I don't find any entry in registry ) as well as regsvr32 doesn't show me any message whether registration succeeded or failed ( I am not using silent mode ) When I use regsvr32 on this particular ocx, nothing...

Hi, I have a stored procedure which gives me some output. Can I create select query on the output of this stored procedure ? Thanks, Prasad

Hi, I am new to socket programming and threads in java. I am trying to do the following. When the client connects, socket accepts the connection and then hands it over to thread & goes back to listening requests.... created thread keeps on waiting... Now at any point of time, I have number of...

Hi, I am writing one batch file having many commands. I would like to show the output of each command on the screen as well as I want to write it to some log file. Can anybody help me, how can I have output at two different places at the same time. Thanks, Prasad

Hi, This is my first encounter with C# and having problem with the encoding. One process is sending me the byte array which may contain DBCS and Unicode characters ( such as russian, chinese ). I want to convert it to string ( using unicode encoding I guess.......), such that unicode...

Hi, I am very new to Sybase. Could you please tell me, similar to Oracle do we have something like 'Decode' in sybase ? Thanks & Regards, Prasad

I am using Compute clause......and now I want to order the results based on the computed value. I referred the documents, but it seems impossible because compute clause itself needs one order by clause. So for example, I have records in table1 User Acct...

Hi, I want to read from the text file which contains unicode characters & then print the whole thing using printer object in Visual basic. But instead of actual unicode characters only question marks '?' getting printed. I am sure I am reading the file correctly because if the same text read...