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!

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

Search results for query: *

  • Users: aajay
  • Content: Threads
  • Order by date
  1. aajay

    moving database schema to spread sheet

    Hi I have database on sql server I would like to move database schema to excel spread sheet any idea. I do not like to move data at all. thanks,
  2. aajay

    stringreplace

    I need quick help how to replace (800) 223 4114 to 800 223 4114 Thanks
  3. aajay

    attaching processor to dev server

    Hi I have build application at my local machine it is working fine . Now as I deployed it on dev server some pages are breaking I wonder If some one guide me how to attach processor to dev environment so I can debug the application. Thanks
  4. aajay

    I have data like Return|Item Can

    I have data like Return|Item Cancelled|Item [CFY] Gifts I would like to display if data has | then display it in two text box like Textbox1 Return Textbox2 Item if data does not have | then display the "field value" in Textbox1 and Textbox2 should be "" any help would be nice thanks
  5. aajay

    using tables from multiple databases

    I have store procs in my database I need to use table from different databases all want to do is declare a variable and pass the database name to get the data e.g declare @dbname set @dbname = Fortunedb select name, id from @dbname +'.'+ vwGiving_Gift_Journal_RPT so I can change the...
  6. aajay

    Data for every fifth year

    How can I get data for every fifth year from table Hope you might have done that also thanks
  7. aajay

    Better way to do SUM

    I’m new bee I wrote store proc following select sum(a.Amount) as amount1 ,sum(b.Amount)as amount2 ,'Agencies' as CategoryName from DMAS_INFO di left outer join (select sum(Amount) as Amount ,ADISID -—current year from vwGiving_Gift_Journal_Rpt...
  8. aajay

    string

    Hi I have string M2549 - 2598 like to get M2549 I'm new to vb.net I try split function but couldn't get it any would be appreciated Thanks
  9. aajay

    Matrix Subtotal

    Hi, Report item matrix subtotal is using sum aggregate by default Is it possible to use other than Sum, like subtraction? I have to show like Total-row1-row2 in my subtotal column thanks
  10. aajay

    freezing column and header in a report

    I have report with many columns and large records I would like to freez header and specific column in same report when I freez header it's work when I freez column it's work but when I try to freez both in same report it does not work any advise how to freez both column and header in same...
  11. aajay

    windows 2000 crashing with warning

    My computer has dual boot up W2k and XP pro W2K keeps crashing after running for few minutes in the events log There are error as following "The server was unable to register the administer tool discovery information the administration tool may not be able to see this server. the data is the...
  12. aajay

    SQL in the record selection formula of the report

    Crystal Report 9.0 Data base SQL server I have a report that runs from a view. I would like to filter records in the report based on a SQL subquery that operates on the view. Is there a way to accomplish this in crystal? This is very similar to having a SQL in the record selection...
  13. aajay

    passing a SQL in the record selection formula.

    Crystal report 9.0 with service pack 3 data base is sql server 2000 I have a report that runs from a view. I would like to filter records in the report based on a SQL subquery that operates on the view. Is there a way to accomplish this in crystal? This is very similar to having a...

Part and Inventory Search

Back
Top