Recent content by bsibengal

That was it exactly!! I will add that to my arsenal! [medal]

I added several subreports to report footers, where they happily run. My issue is that if one subreport result 'ends' about half the way down a page, and the next subreport has more results data than a half page, it will start the next subreport results on the next page. If the subreport...

The command itself will not change, as the table names are the same. The cut and paste may not be feasible, as the database name is what is changing. We are using a similar stock table structure for each of our clients, but need to point to a different instance or database name. The Commands...

Changing the datasource in a Crystal Report is simple when using individual tables, but we have not been able to find an easy way to do this when using Crystal commands for the datasource. Any tips on how to change the datasource when using Commands?

That solution did not work, but I did have success taking your suggestion theory and creating an interim formula parameter that is set to equal the passthrough parameter. I added the following line to the select: {BUDGET.DESCRIPTION} like "*"+{@FiscalYear}+"*" And it worked. thanks!

Crystal Reports 9. I am passing through a Parameter to a subreport. I expect the parameter to be given a value by the user similar to"FY 07" for fiscal year. I then need to select a record based on a text description field containing the parameter value. For example, I want records described...

Perfect. All of the above worked fantastically! thanks!

To answer Madawc's question - the data for each person comes from different tables. For instance, the address information is in a separate table from the phone number, etc. I do have another question, in that the subreport boolean parameter selection still shows when running the main report...

Thanks! We realized that we were trying this correctly, but the dropdown to select {?HideAddress} actually has a scrollbox within the dropdown. Once we figured out how to scroll down, we found the {?HideAddress} just fine.

Version 10 I have a report that displays the Directors and Officers and other important people in a company by Generic Title. Each person then has information displayed about him. To do this, we have created a subreport that shows all Directors. Each Director then lists his address, phone...