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 gkittelson 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. phillyon

    Can anyone tell me if the property

    Personally, I wouldn't have the auto-reimport option checked. You should not need to reimport subreports unless you have changed the database structure or the look of the subreport. If this is the case Crystal can be a bit picky at times about recognising the new subreport version and the...
  2. phillyon

    Crystal Smart Viewer for Active X

    I have always had problems with CR 8.0 and IE 5.0 with the Smart Viewer. Are the other machines that work fine IE 5.0 also? If the other machines are IE 5.5 or newer then you could upgrade the IE 5.0 machine and hopefully solve your problem. Phil.
  3. phillyon

    Missing text on large print job

    Nobody has had problems printing reports with large volumes of data using the Web Component Server??
  4. phillyon

    Totals

    Create a formula field to convert your numeric and use the ToNumber function eg. ToNumber({yourfieldname}) ToNumber("123.45") Returns 123.45. As for the totals, insert your newly created formula to the report in the details section, right click and choose Insert then SubTotal and...
  5. phillyon

    OLAP Time Dimension

    This is the t-sql cursor that I use to create a calendar table for use as a time dimension - hope it helps: if exists (select * from sysobjects where id = object_id(N'[dbo].[MXCUSTOMCalendarTB]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MXCUSTOMCalendarTB] GO CREATE TABLE...
  6. phillyon

    Missing text on large print job

    Environ: Crystal Reports 8.0: ver 8.0.1.8 CRW32: ver 8.0.1.547 reports via URL to IE 5.5 crviewer.dll: ver 8.5.0.473 printer: Canon iR 5000-6000 plc6 When a user runs a large print job (approx 800 pages, two sub reports per page) - on perhaps 3 or 4 printouts - seemingly at random some text...
  7. phillyon

    To get date part only in SQL out of datetime field stored as getdate()

    The between function will only return you dates between the two you have specified. In this case your dates are 08 06 2002 at 00:00:00:000 time and 08 07 2002 at 00:00:00:000 time. This means you will only get dates between 08 06 2002 at 00:00:00:001 (the first one thousandth of a second of...

Part and Inventory Search

Back
Top