Use SQL Procedures an set DSN Dynamic
Hi,
Can i use a Stored Procedure for Fast Reports ?
I use is in Crystal Reports.
When i start my Statistc, i set any values (from Jear - to Jear, City....) and send this values as Parameters to the Procedure.
The Result will showed in Crystal Reports.
For any Reports, i have different Procedures or views.
The Fields are the same, but the Data are differently.
Can i change the DSN bevore opening the Report ? (from the view viewAdressen to viewAdressen1)
Can Fast Reports do this ?
Can i use a Stored Procedure for Fast Reports ?
I use is in Crystal Reports.
When i start my Statistc, i set any values (from Jear - to Jear, City....) and send this values as Parameters to the Procedure.
The Result will showed in Crystal Reports.
For any Reports, i have different Procedures or views.
The Fields are the same, but the Data are differently.
Can i change the DSN bevore opening the Report ? (from the view viewAdressen to viewAdressen1)
Can Fast Reports do this ?