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 strongm 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: txkitten
  • Order by date
  1. txkitten

    remapping fields

    Are you using tables, views or stored procedures? Have you tried re- verifying the database? Contract Report Developer coogrcub@yahoo.com Houston, TX
  2. txkitten

    Crystal Reports and Nortel Symposium Call Center

    Where are the links attached to in each of the tables in the Visual linking expert? When you added the new tables was there a box at the bottom of the window that said "Perform Smart Linking"? If so, and you did not delete the unneccessary links, it is possible that is your problem...
  3. txkitten

    ODBC error

    Have you checked the SQL statement? Or have you made any changes to it? They sometime lose the joins when messed with. Let us know if it works. :-) Contract Report Developer coogrcub@yahoo.com Houston, TX
  4. txkitten

    Print Date range parameter value on the Page Header

    Start with a text feild and type: For Period To then simply insert your Parameter fields into it, in the correct placements. It should look like this when done: For Period {#FromDate} To {#ToDate} Then place this feild in your pageheader whereever you need it. When you run your report...
  5. txkitten

    Parsing a string In Stored Procedure

    oh...sorry...I misunderstood. I got it now. :)I'm very new to this whole Forum thing. Sorry if I've bugged you too much. But thanks again for your help. I'm really hoping this is the solution I've been hunting for. :) Take it easy. TxKitten
  6. txkitten

    Parsing a string In Stored Procedure

    Well, I will give this a try....thank you for the input. On a side note...the parameters in the IN clause DO work just fine. ...it's just annoyig to have to do 4 separate parts of this sproc, when the only real change is to the where clause. Again, thank you for your help...and I'll try and...
  7. txkitten

    Parsing a string In Stored Procedure

    Here's what I mean... If @SelectBy = 'Borrower' BEGIN SELECT punit,prenew, papply, FROM property, WHERE pstatus NOT IN ('X', 'T') AND pbnumber in ( @param1, @param2, @param3) End If @SelectBy = 'Officer' BEGIN SELECT punit,prenew, papply, FROM property, WHERE pstatus NOT IN...
  8. txkitten

    Parsing a string In Stored Procedure

    This was very helpful to me...since I have a similar problem. However, can this solution be used for only a part of a where clause? I have a large stored proc in which, depending on the selection made by the user the where clause looks for a different field. Plus I have to look at either a...

Part and Inventory Search

Back
Top