Search results for query: *

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

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

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

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) + ":"...

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

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

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

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

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

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

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

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

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

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

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

If you are running Crystal 2008 you can use the new Grid functions in a formula to create an embedded summary. I've covered this in a previous issue of Crystal Clear, but do that example next week in my blog at www.crystalkiwi.com/blog.htm Editor and Publisher of Crystal Clear...

It all depends on what account your IIS is running under. Make sure your ODBC is a System DSN as that is visible to all accounts and processes running on your machine. A User DSN is only visible to that user. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm

Most of the world uses D/M/Y as a date presentation format. For outside the US assume that. Editor and Publisher of Crystal Clear www.chelseatech.co.nz/pubs.htm

You need to configure the OBDC with the 32 bit ODBC config program. Crystal can't see the 64 bit ODBC, so needs the 32 bit ones. I don't think the upgrade was the solution to your problem. It was the 32/64 bit confusion. There is a longer article in our newsletter discussing this. Editor...

Is your field a date or a string? Make sure the variable matches the same type. You can also convert the string, by extracting sub strings, and then building them with a date function. provide an example of what you are trying to do Editor and Publisher of Crystal Clear...