Setting Locations for all subreports

[Halfcan]

Using v8.5,

After updating my databases, I need to "Set Location"
in my main report.

After doing this on the main report, CR askes if I would like to propegate changes to the subreports.
I click yes, yet I end up having to set location for each
subreport.
Does anyone know why all my subreports are not changeing with the main report?

Thanks,

Andy

 

[mbarron]

I think when Crystal ask if you want to propigate the changes to the sub, it only means the fields that are linked to the sub, and not the locations in the sub. Mike

 

[Halfcan]

so then, you are saying that everytime I update my data base file(*.xls) I will have to set the locations for all reports by hand?

Is there a way to do this automatically?

We will extracting data to the same filename (*.xls used as an ODBC) everyday.

Thanks,

Andy

 

[mbarron]

In my experience with using Excel files - If the file name and column headers in Excel (I always use the named ranges, I'm not sure if they are needed) and file location are the same, you should be able to just refresh the CR with the new/different file.



Mike

 

[SFLLC]

We make a product called .rpt Inspector(TM). The current released version 1.00 (released October 2002) supports doing this on a limited basis with ODBC for a batch of reports.

We also have the next version in beta testing which has expanded this ability. We now have a wizard that supports selecting a batch of reports, selecting the source, selecting the destination (we now support ODBC, OLE DB, Access, Native SQL Server, Native DB2, Native Oracle, Native Informix, Native Sybase). And you can also define the actions to perform per report, per destination (they can be: set location, do a conversion, do a verify, etc.).

So it does allow you to move a virtually unlimited amount of reports (at the same time) for example from ODBC Oracle to Native DB2. If fields have changed, you will even be prompted to do a field mapping.

However, we currently do not support CR9 and this upcoming version will be support it.

We will be showing this latest version (and giving out free beta copies) at the 2003 conference for the Crystal Users Group of North America in Vancouver, Canada May 21-23, 2003.

You can also sign up to be part of this limited beta program.

Here's a little bit of what else the upcoming version does:
o data source / database conversion and migration (we can now do things like... batch set location, batch convert from ODBC to Native Oracle, batch convert from OLE DB to Native SQL Server, etc.)
o spell checker
o search and replace (search for all instances in as many reports as selected for "(c) Acme Corp" and replace with "(c) Whatever You Want" or for table names, formulas, etc...
o report "play" lists
o copy default parameter values from a master and propagate to selected

and a lot more....

Software Forces, LLC

http://www.softwareforces.com

makers of .rpt Inspector(TM)