How do I easily find a field in a report?

[aaron_gerber]

I'm in the process of removing a data source from a report, replacing all occurrences of its fields with corresponding fields from another data source. To do this, I need to be able to find the fields on the report canvas. I know that if I select them in the Report Explorer, they highlight on the canvas, but what if I can't find them in the Explorer? Is there a good way to search for specific text in the Report Explorer?

Thanks!

[former_member11696]

FYI - everything will soon be 64 bit only so it's time to convert to Tables.

CR 2016 end of life is 2024 so you have 1 1/2 years to convert.

https://wiki.scn.sap.com/wiki/display/BOBJ/SAP+Crystal+Products+-+End+of+Mainstream+Maintenance+Date...

Not sure why you are having problems, could be a mix, or you need to Verify database first...

[aaron_gerber]

don.williams, I see that you're an SAP employee, so I will direct these questions to you:

We were told that JobBoss will no longer support the Access-based reports we have been using, and we need to move everything over to Crystal Reports. If Crystal no longer supports the use of .ttx files as data sources, why does JobBoss supply reports that use .ttx files instead of ones that are compatible with Crystal? Is there any way to acquire non-legacy versions of the supplied reports? In addition to using TTX files as data sources, I find there are formulas in the reports that use JB-specific functions that, because of the absense of the dll, throw an error whenever they are being checked for errors.

[former_member11696]

Yes it likely is the cause.

32 bit versions of CRD will end in 2025 so you should start upgrading your reports now so it's not such a strain on resources (Your Report Designers/Creators) when you will be forced to update them.

[former_member11696]

Hi Aaron,

One problem you are going to run into is with CR 2020 the legacy TTX data sources are no longer available to be used, see this for more info,bottom of the page, Field Definition is NA:

https://www.crystalreports.com/datasources/

The problem with the TTX as a data source is it was unique in that the data structure doesn't really follow any typical structure so it's impossible to Set Location to any other type, ODBC OLE DB etc.

We still ship the database dll for those still using TTX as a data source but for 64 bit Version of CR 2020 it's no longer available. You can still use it but no changes will be possible.

I highly suggest you need to look at using a real data base and and data source.

Unfortunately there is no mapping Ability available that can map TTX data sources to Table/Fields.

Only way is to have 2 copies of CR Designer open and Copy paste objects from one the other.

Don

[aaron_gerber]

Thanks, Don!

I'm trying to figure out the implications of that. I don't really know whether my employer has intentions of going to 64-bit. Would it definitely be a mistake to work towards making the report include the requested additional information as I am trying to do, by replacing the TTX source with a "real data source" for only one subreport? Is it possible that the mixed use of TTX and "real" data sources throughout the report and its subreports is what's causing the 'invalid grouping condition' error?

[ido_millet]

As shown in the image below, lots of matches to _ttx.job} but if I search for r_ttx.job I get no matches.
Given that your Labor_Sub_Command.rpt subreport uses a Command as the data source, perhaps you need to look at the SQL statement for that subreport's command.

[aaron_gerber]

I tested the SQL query in MS SQL Server Management Studio, and it runs as intended, aside from taking way too long to load, and I don't see why long loading would lead to a grouping condition error. Thanks for taking a look at it!

[ido_millet]

Can you make the rpt available for download (e.g. one drive)?
And specify the field your are trying to eliminate.

I'll use my report inspection tool to see if I can spot the problem.

[aaron_gerber]

I don't have OneDrive, but I do have Dropbox. Will that work for you?

[ido_millet]

sure, any file sharing method should be fine.

[aaron_gerber]

I'm giving links for two files. One is the main report, which uses JobBoss' TTX schema file as it's data source. I wouldn't be surprised if that doesn't cooperate with your inspection tool (at least, it has caused me a lot of headaches). So, the second is the subreport where I'm trying to ditch the TTX data source.

https://www.dropbox.com/s/jgjnfvt4rk0mzfd/CA_ClosedJob.rpt?dl=0

https://www.dropbox.com/s/iylg22nahklpb9c/CA_ClosedJob_Labor_sub.rpt?dl=0

[aaron_gerber]

Oops! forgot to mention, these were after I eliminated the data source CA_ClosedJob_Labor_ttx source, and it started throwing the invalid grouping error. Would it more help you help me if I gave the versions from before eliminating that source?

[aaron_gerber]

...and the field I could not find was CA_ClosedJob_Labor_ttx.Job

[ido_millet]

Reports can have grouping levels without custom group sort or group selection logic.
So there's nothing special about that.

[aaron_gerber]

Thanks for that!

I have a data source I want to eliminate, but Crystal says one of its fields is in use, even though the definitions file does not contain it anywhere. From that save point, I tried eliminating it anyways, and it ended up giving me an invalid grouping condition error.

[ido_millet]

Try to export the rpt to Report Definition format and search the resulting text file.

[aaron_gerber]

Thanks! What does it mean when both the "Group Sort Fields" and the "Group Selection Formula" sections (3.0 & 4.2) are blank, even though the report contains multiple group levels?