jcrawford08
Technical User
Hi all,
I'm Running CR XIR2 in a SQL environment;
The report I'm working on needs four seperate ID Numbers displayed, for ease, lets call them:
Num1
Num2
Num3
Num4
These are contained in table "Provider_IDNums" that we have linked to the primary "Provider" table:
{Provider.ProviderID}={Provider_IDNums.ProviderID}
In this situation Num1 is ALWAYS present, so in the main report I presently have the selection criteria set:
{Provider_IDNums.DocName}="Num1" and then the field {Provider_IDNums.IDNumber} in the details of the report.
The other three numbers I have being brought in through sub-reports presently. I have them linked on the primary field and then some advanced formula and grouping work to actually show "None" if there isn't a match for the given {Provider_IDNums.DocName} otherwise display the {Provider_IDNums.IDNumber}.
My question is - would it be better to pull in three additional 'Alias' tables and do a LOJ on them to pull this information in?
My goal is to potentially improve performance, so is there a performance advantage in using Alias tables vs. Sub-reports?
Tips, ideas and thoughts are always welcome!!
Thanks!
jcrawford
-jcrawford-
Not in word only, but in deed also... 1Jn3:18
I'm Running CR XIR2 in a SQL environment;
The report I'm working on needs four seperate ID Numbers displayed, for ease, lets call them:
Num1
Num2
Num3
Num4
These are contained in table "Provider_IDNums" that we have linked to the primary "Provider" table:
{Provider.ProviderID}={Provider_IDNums.ProviderID}
In this situation Num1 is ALWAYS present, so in the main report I presently have the selection criteria set:
{Provider_IDNums.DocName}="Num1" and then the field {Provider_IDNums.IDNumber} in the details of the report.
The other three numbers I have being brought in through sub-reports presently. I have them linked on the primary field and then some advanced formula and grouping work to actually show "None" if there isn't a match for the given {Provider_IDNums.DocName} otherwise display the {Provider_IDNums.IDNumber}.
My question is - would it be better to pull in three additional 'Alias' tables and do a LOJ on them to pull this information in?
My goal is to potentially improve performance, so is there a performance advantage in using Alias tables vs. Sub-reports?
Tips, ideas and thoughts are always welcome!!
Thanks!
jcrawford
-jcrawford-
Not in word only, but in deed also... 1Jn3:18