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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chelseatech

  1. chelseatech

    Crystal Reports 11 on-demand subreport help

    Grouping on Server might speed up some of the subreports. Or schedule a Stored Proc to build the required summaries into a working table and base your report on that. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  2. chelseatech

    How to display Oracle BLOB which is a PDF letter on Crystal Reports?

    PDF is not an IMAGE format supported by Crystal. It is a DOCUMENT format. BLOB fields that are JPG, PNG or BMP can be displayed inside the report. If the field contains text that is HTML or RTF it can be interpreted in a field formatting option. Editor and Publisher of Crystal Clear...
  3. chelseatech

    New Crystal Reports version around the corner?

    There is a crystal Reports 2010 but it's just to keep developers with Visual Studio 2010 happy. Crystal Reports 2011 is expected in Q2, so should see something in the next month or so. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  4. chelseatech

    Formula

    The 4:87 still looks strange. To get an average convert to a base unit number. I would use Hour({Field}) * 60 + Minute({Field}) Then create an average of that number and convert back: myHour := Fix(Sum((FormulaAbove}) / 60); myMin := Remainder(Sum({FormuaAbove}),60); ToText(MyHour,0) + ":"...
  5. chelseatech

    Crystal reports XIr2 export to pdf

    The Image resolution appears to depend on the settings for the default printer. Make sure it's not a low resolution printer like "Microsoft Imagewriter". Or see if setting the report to "No Printer". That appears to improve image resolution in the viewer. Editor and Publisher of Crystal...
  6. chelseatech

    adding formulas to a cross tab

    The first thought is that "Average" is one of the summary options available in the Crosstab Expert. What version of Crystal Reports are you using? Crystal Reports 2008 includes a neat Embedded Summary Feature where you can take two summaries and calculate a new summary using them. it is...
  7. chelseatech

    Dynamically change location of OLE object

    A Txt or HTML file can use our cViewTEXT utility. Doesn't currently work with Excel or Word Documents, although I'm looking at that for a future product sometime in the new year. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  8. chelseatech

    Can CR detect a crlf in a memo field?

    I would use the following formula.. Split ({Table.memoField},Chr(10)+chr(13)) [3] To get the 3rd line in the field. Use [1] for the 1st, [2] for the second, etc. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  9. chelseatech

    dynamically change width of report

    Crystal Reports 2008 also has the option to change page orientation dynamically from portrait to landscape. Not available in earlier versions though. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  10. chelseatech

    What Exactly Is Crystal Doing?

    Yes they are processing the subreports twice (once on the first build to get the page count, and again when each page is viewed). I've noticed this with CR 2008 (and XI) when processing some of the things I'm doing inside my UFL's. There are all sorts of ways to speed up a report. Could you...
  11. chelseatech

    Text after a report

    You should put that text in the group footer and set that section and the text object to NOT keep together. I've got clients doing something similar here. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  12. chelseatech

    How to get report to view in URL?

    You could use one of the Crystal Report delivery methods, or use a report scheduler like our cViewSERVER to export the report as HTML to a page on your web server. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  13. chelseatech

    retrieving the first entry in a comma-delimited field

    The [2] represents an index on an array. In Crystal the first value is index number 1. So Split({table.field},",") [4] will retrieve the 4th value from your csv field. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm
  14. chelseatech

    Hierarchical Summary Calculations

    Are you using a hierarchical group or an alias table to created a fixed number of group levels within your hierarchy? If you sue the hierarchical grouping option, you can jsut select the summary field and "Summarize across hierarchy" Works like a charm. Editor and Publisher of Crystal Clear...
  15. chelseatech

    building group based on multiple records

    I can't see any way to do this using the standard tools inside groups as what you are asking for is to get the data, group it by Type and Order, and count the number of NULL values and then regroup based on whether all the records for that order are NULL or not. Grouping only happens once...

Part and Inventory Search

Back
Top