Recent content by DuncanSutcliffe

You don't tell us what version you're using, but if you have the full version of CR (9 or upwards), try checking the "Retain Original Image Colour Depth" box in File -> Report Options. If you're viewing reports in a browser over the web, you need to look at the instructions at...

If you really just want to use the Query Builder, you can do something as simple as: select si_name, si_scheduleinfo.si_submitter, si_scheduleinfo.si_endtime from ci_infoobjects where si_endtime > '2006-01-01' and si_instance = 1 This will list every instance that happened since 1st Jan 2006...

Have you tried to start Tomcat from a command line to see if you get a better error message? NET START Tomcat5 There's also a logs folder in your Tomcat installation folder which should contain information about any startup failures. Duncan

There's some sample code on the BO knowledgebase for looping through all a report's objects and setting the tooltip to a character that doesn't display: http://support.businessobjects.com/library/kbase/articles/c2012262.asp Duncan

I don't believe there's any solution included in the Crystal Enterprise box, but it would be possible to do it programatically, as you can set the Password property of an InfoObject and then use its Commit method to write back to the CMS. Problem would be how to tell any script you wrote which...

I would check the font of the field containing that symbol. When set to a standard font such as Arial or Times New Roman, does it work? Duncan

Then you just need to apply that same syntax to each individual object rather than to the group. The Suppress option is on the Common tab of the Format Field dialog. Duncan

Yes, in the Section Expert for the relevant group header section, click the X+2 button next to "Suppress". Then enter a very simple conditional statement: DrillDownGroupLevel = 0 This will ensure that the section is suppressed until its group has been drilled into. Duncan

It's all in the parentheses: {QryRep.ReqDate} in {?StartDate} to {?EndDate} and (IF {?Cellname} <> "All" then {QryRep.Cellname} = {?Cellname} else true) and (IF {?ProductType} <> "All" then {QryRep.tblMain.Prodtype} = {?ProductType} else true) Should do the trick. Duncan

You're likely to find that without joining the tables, Crystal will generate a data set that is the Cartesian product of all the queries - like a cross join. This will not only be wrong (hideously wrong), but will take an exceptionally long time to run and sort. Build one query that contains...

If the queries are "unrelated" in the sense that you can't join them, shouldn't you be using subreports? Having unjoined tables in the Database Expert will generally produce very strange results. Or am I misunderstanding the issue? Duncan

A subreport can't contain page headers or footers, as you'd then end up with two page headers and two page footers on each page. What you can do is insert a dummy group in your subreport as its first group. Just create a simple formula like "If True Then 1 Else 0" and group on it. Set the...

Solved it myself. You have to create a new increment formula for each section and place that in the footer section. You can then choose not to increment the counter by doing: If [logic that controls display of section] = True then i:=i+1; Fortunately I only have about 8 sections to do this...

Using CR 10. I need to alternate the colouring in a group footer that has multiple sections. Certain sections may be hidden at runtime by a user choice, so I need to set colouring dynamically. I have followed the usual habit of using a counter. In the report header I set up: //@Counter...

It's certainly possible to drill down on charts. To achieve this, set up your report's groups in the normal way, hiding each section you want to be able to drill down into. Now when you click the Insert Chart... icon, the default will be to create the chart based on an existing group or...