Advertisements
Home > SSRS > Executing Informix DB Stored Procedure in SSRS

Executing Informix DB Stored Procedure in SSRS

Recently we got a requirement to pull the data from IBM Informix DB and prepare report using SSRS.

For who does not know what is Informix, refer here

Below are Stored Procedure details

Name: sp_getcustomersbycity

Description: Accepts date range and City codes as parameters and returns Customer result set.

Query Execution Syntax in SSRS:

{

call sp_getcustomersbycity(‘2015-09-30 20:00:00′,’2015-10-31 19:59:59′,’0′,’HYD,BLR’,null)

}

🙂

Advertisements
Categories: SSRS Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: