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

I think you can use following API for the purpose.... ' To prevent object going out of scope whilst the timer fires: Private Declare Function CoLockObjectExternal Lib "ole32" ( _ ByVal pUnk As IUnknown, ByVal fLock As Long, _ ByVal fLastUnlockReleases As Long) As Long Hope this helps...

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...

Thanks lupins46. Using Excel 97 Extended option indeed gives better relsults. Rgds, Prasad

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...

Thanks Brian. I will have a look at Visual CUT's capabilities. Regards, Prasad

Great ! I didn't know about that ability of CR. Could you please tell me how to conditionally supress deatail sections ? Thank you very much LB for all your help. Prasad

LB, Because of this format, I tend to add 12 formulae for 12 months and diff at the end. But as you said later months will be blank in this case. Is there any way I can suppress those blank columns and reduce the spacing betn last month having the values and the diff column at the end ...

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

Thanks LB, Actually end users are not ready to accept such format of the report. They want months going fwd from left to right and at the end "Diff" column. ~ Prasad

Hi LB and K Thanks for your help. So if I am running the report at start of May, I have to create the 4 formulas for Jan, Feb, Mar, Apr. If I am running the report at start of July, I have to create 6 formulas for Jan to June. But I think I have to add the foumula at design time. right ...

I just get all the data by where clause such as "where date is between JAN-2004 to DEC-2004" So if I run report at May end, I get the data only for 5 months. Thanks again. Prasad

Thank you very much LB. I think this will work. But one problem, at any time report will have variable number of months. I mean in March, it will have data for Jan, Feb, March. ( And I need difference between March and Feb ) In May, it will have data for Jan, Feb, March, April, May. ( And I...

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...

Thank you very much for your responses. But I am using latest version Access 2003 and still getting the error. :-( Regards, Prasad

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 Ken, You are right, using pass-through query I am able to run sybase stored procedure. Thank you for pointing me in right direction. Cheers, Prasad

YES !!! It worked very well. Thank you very much cmmrfrds. Cheers, Prasad