Dynamically pass Crystal Reports formula to a Stored procedure Parameter

[XrayboX]

I'm using a proprietary front end to run a Crystal Report that ignores Crystal Reports prompts.
It looks for specially named formulas (disCustomValue1 , disCustomValue2, etc) in the crystal report, and dynamically populates it with necessary values based on the answers supplied to proprietary front end's coded prompts.
(for testing purposes, in Crystal Reports, those formulas can be populated with static value that will get replaced at run time).

I need to join tables to a stored procedure that requires a value (StockCountID) passed to it.
When the front end executes the report, the only place that value (StockCountID) needed by the stored procedure, exists is in disCustomValue1
I have no problem creating the joins

I can't modify the stored procedure to remove required value be passed to it.
While the version of Crystal Reports is the same, I don't have access to where the .rpt file will be run, I only have access to my local copy where report is being written, and tested against a copy of the database

Is it possible to dynamically pass a formula's value to a crystal Report parameter for a stored procedure




SAP Crystal Reports 2020 Support Pack 1 Patch 7
Version 14.3.1.3953
Connection Info
Database Type: OLE DB (ADO)
Provider: SQLOLEDB
OLE DB Services: -5

Database
Microsoft SQL Server 15.0.4360