Search results for query: *

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

Solved it! You put an unlinked subreport in the report header. In this you have a shared stringvar array which you dynamically populate with the values from the lookup table on which the main report's groups are based. Then call that shared array's members into the required number of...

Thanks for another good answer, LB. Unfortunately I need to read the array values from somewhere, I can't hard code them. The column names are to be the same as the group names from group one, but the group one names won't be known until runtime - and there are 34 possible fields that could be...

Thanks, lbass. That works. As you say it has to go in a footer (damn, there go my carefully crafted drill-downs!) but it is a great solution. Duncan

Using Crystal V.10 connecting to SQL Server 2000 via an ODBC DSN. I am building a manual crosstab and need to populate column headings based on the group names for group one. Group one is from a formula, as the user can select how to group the report at runtime via a parameter. There could be...

Thanks, but... Unfortunately, that will show the median of each detail row, rather than of the set that belongs to that day, in the same way that showing the value on condition shows that detail value. But with values you get useable information for each row and you can sum them to get a...