I’m trying to make a Report that I made in CR (when back on 8.03), as an SSRS report in E10.
The CR report runs fine in E10, except when users have issues with the CR Runtime viewer.
The CR report uses the original RDD (JobPickl to be exact). But when I try to make an SSRS report using that same RDD, some of the fields available in CR are not available in SSRS.
Specifically, JobList. It is in the CR dataset
But not in the SSRS dataset:
In fact, the tables listed in each aren’t even the same.
If different dataset is the norm, any suggestion on how to get the list of jobs selected in on the Filter tab of the print Pick List program?
I edited the RptParameter Query, adding “
,T1.JobList” to get:
="SELECT T1.BarCodes,T1.DecimalsQuantity,T1.JobList FROM RptParameter_" + Parameters!TableGuid.Value + " T1"
and added the new field
But how would one know that the JobList field even existed, without seeing it in a CR report?
In E9 fortunately in the RDD you can see both included AND excluded table fields, but in 10.0 it was more awkward in that an exclusion had to be first created, then negated, to make sure a specific field would be available in a given report.
Maybe a dashboard could be created, which would give information on included and excluded fields in an RDD. Field Help reveals tables such as RptTable, RptCalcField, RptExclude, etc.
If you create a Crystal RDD from the SSRS one, just long enough to Generate Only a report you could view its XML.