Koren
Posts: 83
|
| Posted: 03/12/2011, 11:54 AM |
|
Often I dynamically adjust the datasource of my grids using the following on "BeforeExecuteSelect" of the grid...
global $market_abbr;
$Component->DataSource->SQL = str_replace("cg_",$market_abbr."_",$Component->DataSource->SQL);
$Component->DataSource->Where = str_replace("cg_",$market_abbr."_",$Component->DataSource->Where);
$Component->DataSource->Order = str_replace("cg_",$market_abbr."_",$Component->DataSource->Order);
$Component->DataSource->CountSQL = str_replace("cg_",$market_abbr."_",$Component->DataSource->CountSQL);
I created a simple report with the Report Builder.
When I use the above action on the Report, all the DataSource is adjusted correctly, with the exception of the "ORDER". Where can I dynamically adjust the order statement in a Report? Any insight would be GREAT!
Thanks!
Koren
|
