Greetings,
First off, I have very little experience with VFP so please be kind. I've been searching for examples of passing the record id from a Foxpro form to an SSRS report that is expecting a parameter.
From the app, I call an x_ routine that builds the majority of the url where I'm trying to capture the parameter (RecordID)and append it to report string. The variable ($1) is appended to the Reporting Services url i.e. cUrl = "
RecordID syntax matches the parameter syntax in SSRS.
I'm really close as when I click on the app's report view process in the form, it starts IE with the SSRS url string displaying the example above. The report fails as it's trying to pass "$1" to the SSRS parameter, but when I change the $1 with a RecordID i.e. 190 and refresh IE, the report runs. The app routine syntax is x_htmlrpt(FORM.RecordID).
I will be able to have more specific info when I get back into the office.
Thanks in advance.
SonicG
First off, I have very little experience with VFP so please be kind. I've been searching for examples of passing the record id from a Foxpro form to an SSRS report that is expecting a parameter.
From the app, I call an x_ routine that builds the majority of the url where I'm trying to capture the parameter (RecordID)and append it to report string. The variable ($1) is appended to the Reporting Services url i.e. cUrl = "
RecordID syntax matches the parameter syntax in SSRS.
I'm really close as when I click on the app's report view process in the form, it starts IE with the SSRS url string displaying the example above. The report fails as it's trying to pass "$1" to the SSRS parameter, but when I change the $1 with a RecordID i.e. 190 and refresh IE, the report runs. The app routine syntax is x_htmlrpt(FORM.RecordID).
I will be able to have more specific info when I get back into the office.
Thanks in advance.
SonicG