Subreport Shared Variable in MainReport CrossTab?

[DataDog]

CR V10

I have a subreport where I calculate the sum of miles driven last month for company vehicles. I use a shared variable to bring the mileage forward to the main report. It displays great in the Vehicle ID Group. Why can't I use that shared numbervar (formula) in a CrossTab?

DataDog
'Failure Is Not An Option'

 

[lbass]

You can, if you have version XI. One reason to upgrade. Maybe there is another approach. Perhaps you could return the sum of miles in a command object that you link to the group?

-LB

 

[DataDog]

Command Object? What's that, lbass? I thought I knew my Crystal but I don't know what that is ....

DataDog
'Failure Is Not An Option'

 

[lbass]

Go to database->database expert and see whether you have "Add command" as one of your datasource options. You can write a SQL query from scratch in this area and use it as a standalone datasource or to link to a table or to another command.

-LB

 

[DataDog]

Thanks lbass, Our Systems folks are evaluating rev XI, I'll take my report and do a smoke test against their XI.

DataDog
'Failure Is Not An Option'

 

[lbass]

I think "Add Command" has been available since 9.0, but I think its availability depends upon your datasource, so if you can't see it with 10.0, it might be a datasource issue.

-LB

 

[DataDog]

No, I've got the "Add Command" to enter my own SQL, it was just your "Command Object" that threw me!

I was going to make some fun on communications (i.e. American vs Canadian vs British English) till I remembered that we (an American Insurance Company) had one of our guys from the SOUTH on Catastrophe Duty in Louisiana. He COULD NOT understand the Cajuns! Never mind....

DataDog
'Failure Is Not An Option'