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 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: *

  1. CrystalDuck

    Dynamic Header / Footer Subreports

    I have a bit of a problem, and am wondering if I can avoid making several versions of the same report just to accomodate the size of the page. First of all, I just began using CR 10. And am still farely new to it. But I've been using Crystal since before version 7 so I'm pretty familiar with...
  2. CrystalDuck

    Very Slow SP with TempTables

    Well, I can't seem to figure out why this works this way, but I will try to explain. I have data out of 4 different tables that I need to pull together. I have split them up into invidual temp tables, because when I try to pull it into one temp table it takes well over an hour. (And even...
  3. CrystalDuck

    Parameter range of values

    I've found numerous posts on the site that has very similar questions to mine...but nothing quite "on the money". So I thought I would post the code I am using and see what I'm doing wrong. All I get back is a dataset for the #Dealer_Number_Search that looks like this: Dealer_Number...
  4. CrystalDuck

    String variable passed to OPENQUERY

    I am on SQL Server, rtying to hit an Oracle database, and feel like I'm so close, but it just don't wanna take it....help. DECLARE @previous_date smalldatetime, @cmd varchar(4000) --DROP TABLE #OPEN_CLOSE_ALL Create Table #OPEN_CLOSE_ALL (PRI_ACCT_ID varchar(14), SHRHLD_SHORT_NAME...
  5. CrystalDuck

    Formula Syntax for CR 8.5

    I am working with Crystal Reports 8.5 and a SQL server 2000 data source though an ODBC connection. One of my co workers sent me this formula text and is baffled as to why it's not working. It's a little over my head, (honestly to me, it doesn't look like it would work at all for a few reasons...
  6. CrystalDuck

    Exporting from CR9 to txt or csv...with headers?

    Okay, I'm using CR9...I am having no trouble exporting to a .csv file for the Export format. However when I use the Application for the destination, it automatically wants to open the .csv in Excel. Okay, so I only use the Disk File for the Destination. (since my file is over 65,000...
  7. CrystalDuck

    FIND specific data in a String Field

    I am working with Crystal 9.0 with a SQL 2000 database. In my report, I need to display the data from a certain string field, but only up to a certain level. Example: "The quick brown fox jumped over the lazy dog.~~Hey Diddle Diddle, the cat and the fiddle..." Okay, now...I only want to see...

Part and Inventory Search

Back
Top