Cascading Dynamic parameters
Hello,
Please find attached the screen shot of the tables involved.
The NtoNlist table is connected to physican and activefacilitylist using left join on the phnpi and the facid.
The report requires such that when I select a facility or multiple facilities as the facility parameter it should populate a cascading prompt which has only physicians who are in the nTonList.
Please help.
Not sure how to create it as a cascading parameters or any other work around.
screenshot.gif
Please find attached the screen shot of the tables involved.
The NtoNlist table is connected to physican and activefacilitylist using left join on the phnpi and the facid.
The report requires such that when I select a facility or multiple facilities as the facility parameter it should populate a cascading prompt which has only physicians who are in the nTonList.
Please help.
Not sure how to create it as a cascading parameters or any other work around.
screenshot.gif
Last Comment
ASKER
I made the join to inner join for NtoNlist on Activefaciltylist and NtoNlist on Physician.
How to implement the cascading parameter ?
How to implement the cascading parameter ?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Facility is from activefacilitylist and phnpi should be from which table while creating the parameter
You choose the fields you want the user tosee and select from. The linking fields don't come into it.
mlmcc
mlmcc
ASKER
what should the selection formula be
What do you mean?
{FacilityField} = {?FacilityParameter} AND {DoctorField} = {?DoctorParameter}
Change those to match the names of the fields and parameters
mlmcc
{FacilityField} = {?FacilityParameter} AND {DoctorField} = {?DoctorParameter}
Change those to match the names of the fields and parameters
mlmcc
ASKER
hello mlmcc appreciate your thoughts..but is there any alternative to cascading parameter
You can use 2 parameters but then they won't be limited to related values
mlmcc
mlmcc
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
mlmcc