Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by prasadmokashi

  1. prasadmokashi

    One Datatable out of two

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

    Scroll left on Workbook open

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

    ActiveX Exe and form non dependent timer

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

    FTP From Unix to Windows

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

    Export to excel

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

    Export to excel

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

    Exporting to Excel

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

    &quot;Difference&quot; column to cross tab report ?

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

    &quot;Difference&quot; column to cross tab report ?

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

    Exporting to Excel

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

    &quot;Difference&quot; column to cross tab report ?

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

    &quot;Difference&quot; column to cross tab report ?

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

    &quot;Difference&quot; column to cross tab report ?

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

    &quot;Difference&quot; column to cross tab report ?

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

    &quot;Difference&quot; column to cross tab report ?

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

Part and Inventory Search

Back
Top