Search results for query: *

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

Hi LBass Listed below is the formula I used. I applied the following in the running total formula builder in the Type groupfooter ( onlastrecord or {table.type} <> next({table.type}) ) or ( {table.type} = next({table.type}) and {table.study} <> next({table.study}) ) Sample Data: I would...

Thanks LB but I get the same result. I applied the following in the formula builder ( onlastrecord or {table.type} <> next({table.type}) ) or ( {table.type} = next({table.type}) and {table.study} <> next({table.study}) ) Is an additional formula necessary on the reset? Currently I have the...

If I apply the formula below in the reset portion of the formula builder, I only capture the last study. ( onlastrecord or {Type} <> next({Type}) ) I'm trying to show Type1 in the Group footer as 26 studyA =1 studyA =2 studyB =4 StudyC =10 StudyC =20 Type2 in Group footer...

Thanks so much for everyone's responses, unfortunately I'm still confused. I'm not sure how the following suggestion could work in the formula builder of the running total. ( onlastrecord or {table.type} <> next({table.type}) ) should this be added to what I currently have in the formula...

Thanks dgillz for your quick response. I'm still a little confused. I've tried to use the OnLastRecord however it doesn't work within a group, it only checks for the last record of the report. I had thought since I needed to capture the last study by type and then sum the study by type, the...