Recent content by quinn23

Hi lbass I have placed a text box over all the counts in the sub report which has eliminated the magnifying glass from showing in the main report but you can still drill into the sub report.

Thanks lbass I did what you suggested but it still brings me into the subreport groupfooter where the summary counts are contained. Everything else in the sub report has been suppressed. I'm just trying to prevent the user from clicking at all on the sub report, the magnify glass shows.

I'm currently using Crystal XIr2 I have a main report listing all automobile detail. I have a sub report that contains one group on AutomobileID. I've created several counts contained in the Group footer. This sub report will act as a summary view to be displayed in the master report. I have...

Lbass I revised the Composite sql in the command script so that only one date per state is showing. I then followed your original advice to insert a max. This is working perfectly! Thanks again

Thanks again LBass, unfortunately we are using a Composite Data Source. The SQL Expression builder is not available.

Since multiple dates are being shown I use a max count of the RunID. Each RunId has one date associated with the State. In the detail section expert I suppress where the following is true {table.RUN_ID}<>{#MaxRunID} This allows me to show the correct date by state, just not sure why I can't...

That's correct I would need to drill into the detail.

I agree LBass a Cross tab would be much easier. The problem is that the Cross tab needs to be drillable placed in either the report header or footer so that I get one single cross tab. Your assumption is correct concerning the dates per states. There are multiple dates per state. I have used...

Thanks Ian, unfortunately that did not work. I wasn't familar with that option, good to know for future reference

Hi I'm currently using Crystal XIR2 against a Composite data source. I'm trying to create a report with a cross-tab look with out using a Cross-Tab. The report has one group(Country). Within this group I have one field containing all the states(State). The third field is a date(date) When I...

Good afternoon all. I'm currently working with Crystal XIr2. We have several fields containing tool tips. Is there a timer function that will allow the tool tip to remain visible for ten seconds? I have seen the "timer" function, but this just returns the time in seconds from midnight. It...

The formula is now working as expected. I believe the report was corrupt. I simply started over and sumed study as a running total and placed in the groupfooter of the Type and it worked. I appreciate everyone's suggestions, and help. Thanks again

Hi Lbass There are two fields in the report I'm using table1.type table1.study The report contains two groups one is on table1.type the other is table1.study From the detail section I create a running total(Sum) on study, and now reset on groupType change. I then drag the running total into...

I don't think I even need a study group. I'm doing an insert Running total of the Study field from the detail section and then moving that to the Group1_footer(Type)

Hi LBass The report has two groups The first group is Type The second group is Study All summaries are displayed in the groupfooter of Group1_Type Detail Section: contains the Study. I do an insert running total (sum)on Study, and apply the formula logic in the evaluate portion. The formula...