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: CrystalQB
  • Content: Threads
  • Order by date
  1. CrystalQB

    Crystal Reports Server XI - Invalid Object Reference Error

    I am working with Crystal Reports Server XI. The datsource for my reports is a Stored Procedure in SQL Server 2005. The report runs fine in my development environment, both on my machine and when I run it on the reports server itself. (remote desktop) And I can sucessfully upload it to the...
  2. CrystalQB

    CRXI Drop down Parameter pass to SQL Procedure

    Not sure if the subject was descriptive enough...sorry...but here's my dilema. Working with Crystal XI Datasource is SQL 2005 / Stored Proc Fairly simple report with date parameter (user chooses month and year) built into SQL PROC The user needs to be able to choose a Company from a drop...
  3. CrystalQB

    Need to exclude null values sometimes

    This is a weird situation...but I'm hoping someone can point me in the right direction to pull the data I need. This dataset requires me to pull all values (DtlVal) from a table where a HeaderCode is in an array of values. (i.e. HdrCode in ('400000','400100','400200', '400300'...
  4. CrystalQB

    TSQL Optimization help required

    Can Anyone help me with this?? Running SQL Server 2000 -- I have this query, a fairly simple one...but hits several tables and has several case statements and LEFT OUTER JOINS. I know this is not the best way to go about this, because it takes over 45 second to run for just one PO_NUMBER. Not...
  5. CrystalQB

    SubReport Links cause Subreport to dissapear

    Hoping someone can help point me in the right direction... I am working with CR9 and SQL Server 2000 Stored Procedures. My report is a PO Form that requires many subreports. I've been able to combine some fo the main form data and eliminate a few of the subreports, but not all. Now, all the...
  6. CrystalQB

    Multiple subreports bad?

    Hi all, I am trying to determine the best way to go about this report I have been assigned. Working with Crystal 9 -- SQL Server 200 stored procedure is my datasourse, and it's on an OLE DB connection. The dilemma is, the origianl report has about 9 subreports, all with different tables and...

Part and Inventory Search

Back
Top