Search results for query: *

I have a collection of reports that have worked perfectly on the test installation/universe, but on production they hang when scheduled. They work in Preview, but if scheduled (I've tried a variety of combinations of settings) the report goes to Pending, then to Running, then to Pending, then...

I have created a simple report that distinct counts the number of people by country. However, I get different totals if I run the Report with different criteria. So Germany shows 720 people when I run the report against everything, but shows 2434 if I run it just for Germany. (and various...

Anybody got any clues as to why: select distinct count (a.serv_dept_id) as Number_of_Teams, a.incident_id from act_reg a group by a.incident_id is ignoring the 'distinct' bit and behaving as a normal 'count'? Am reporting against an sql server db and using crystal 10 (not that either of...

I have just taken the two CRCP exams for CR XI and felt the need to comment. First some info / comments that maybe useful to others taking this route. Pass marks: Exam 1: 70% (45 questions) Exam 2: 75% (40 questions) Time: about 80 ish minutes each, I was finished in 30, including checking...

I'm trying to use InRepeatedGroupHeader to conditionally format a textbox with "Continued.." in it. However, it seems to ignore whether or not the group stretches across numerous pages. Can anyone shed some light on this?

Is there an easy way to calculate the average time for a date-time field?

I'm using CR 10 and need to display the totals as percentages, however, this is not one of the summary operation options. Can it be done within the cross-tab, or do I need to workout the percent in formulas before hand?

I have created a report grouped on a date field by quarter, however I need to change the date ranges used for the default quarters. Is this possible without creating a formula calculate the date range?

I want to limit the rows returned from a table (Parent) by the content of a Child table's field or if the Child does not contain a row linked to the Parent table. The Child is joined to the primary key on the Parent table. I am using version 8.5.

I have a report that I have filtered so it only displays people enrolled on 2 or more courses at a college. The report looks fine, and shows only the correct people. However, when I insert a Summary or grand total to show how many people fit this criteria it counts all of them (including the...

I am currently studying for the final CRCP exam. Unfortunately a big chunk of it is based on 'Report Design Methodology' and mentions 7 stages of development and ideal formats of specific documents with the associated course that I have never heard of. Does anyone have any idea what this is...