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 Chris Miller 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: njp1
  • Order by date
  1. njp1

    Database/Table Structure and Sample Data

    The SELECT is returning string data (this database stores all records as strings) and the stored procedure parameters are strings. The main report parameters are strings. I found a white paper on stored procedures on the Crystal Decisions support site. It recommends that any variables or...
  2. njp1

    Database/Table Structure and Sample Data

    I tried two ways to link the subreport to the main report 1. When adding the subreport initially and I tried using the Link tab of the Add Subreport window and the parameters for the stored procedure do not appear. 2. Using Change Links I tried to link the subreport and again the parameters for...
  3. njp1

    Database/Table Structure and Sample Data

    I found the answer to my second issue on http://www.sql-server-performance.com/stored_procedures.asp I have to use the WITH RECOMPILE option in my stored procedure. Thanks for the reminder that alternative resources exist out there.
  4. njp1

    Database/Table Structure and Sample Data

    I am not very familiar with stored procedures but I gave it a try. I should explain why I want this: It is for database testing. I do a lot of database testing and I use reporting to verify that an application is working properly. I would like an easy way to get a list of a table's columns...
  5. njp1

    Database/Table Structure and Sample Data

    I have created a report that prompts the user for a table name (i.e. JC10) then it lists the column id and column names within the table. Using SQL Server 2000 and Crystal Reports Developer 8.5 It uses the following SQL query: SELECT sysobjects."name&quot...

Part and Inventory Search

Back
Top