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 SkipVought 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. pajr777

    PDF/Spreadsheet in Wen Reporting Environment?

    I am embedding the Excel or PDF file into a blank Crystal Report - this creates the approrpiate icon in the Crystal Report. I'm trying to use Eportfolio as a single point of distribution for Crystal Reports, Excel reports and PDF files. CR8.5, CE8.0 Thanks, Paul
  2. pajr777

    PDF/Spreadsheet in Wen Reporting Environment?

    Hi, Can someone give a step by step guide on how to do this? I have CR on my desktop, and save the report in a shared directory on the server hosting CE. I run the report publishing tool to add the report, and then view it using Eportfolio. On my PC, clicking the PDF/Excel Icon opens either...
  3. pajr777

    Select a DATE Parameter in CR and use it as a DATETIME data type in SP

    Hi, I have a stored procedure which requires datetime parameter. When I create a CR on the SP, CR automatically creates parameters matching those in the SP. However, I want the user to enter DATE parameters and not DATETIME parameters. EG I want the use to enter @From = 01 Jan 2003 , @To = 31...
  4. pajr777

    Suppressing Grand Totals in Drill Downs

    Hi Amit, I ran a few tests on my dataset: Query Analyser first run: 14 secs Web viewer: 9 secs Query Analyser second run: 8 secs So no, no performance issues there. I'm using CE 8.0 and the ActiveX viewer. Paul
  5. pajr777

    Suppressing Grand Totals in Drill Downs

    Thanks, I got it working in the end. I used something similar, a formula in the RH section and then 'mock' page headers in the GH section. I'm new to Crystal, and still on the learning curve!
  6. pajr777

    Suppressing Grand Totals in Drill Downs

    This doesn't work when the Grand Total is in the Report Footer section. Should I create a new group and put it in Group Footer section?
  7. pajr777

    SQL Query

    Every time you add a view or table in the SQL database you need to quit and restart CR - I haven't found a way to force it to refresh the list. Can you paste the sequel statement from Crystal?
  8. pajr777

    Suppressing Grand Totals in Drill Downs

    Hi, How can Grand Totals, contained in the Report Footer Section, be suppressed whilst drilling down? Thanks, Paul
  9. pajr777

    SQL Query

    Add database, click options and make sure the 'Views' checkbox is ticked. Then use it just like a regular table.
  10. pajr777

    Embedded objects and eportfolio

    OK, thanks. Is the best solution to install CR on the CE server and remote terminal into it? I've tried duplicating the directories (ie file in C:\reports on my machine and c:\reports on Enterprise machine) and that doesn't work. Is there a log anywhere that gives an error (file not found)?
  11. pajr777

    Embedded objects and eportfolio

    I have a simple report which contains an icon to a PDF and an Excel spreadsheet. When I open the report in Crystal Reports and click the icons, the appropriate program starts and loads the file. When I publish the report and then view it in eportfolio, the icons appear as expected but double...

Part and Inventory Search

Back
Top