How to use SP with Pivot concept to make data Source

[Alex K.]

Hello,

Can you please check the sent database.
We could not find the GetPivot_Info procedure in sent database.

Thank you.

[nicegaurav]

Hi,
I am sending database backup again, please have a look.

Thanks

[Alex K.]

Hello,

For the correct retrieve column from procedure with pivot concept please set the following option:

Code: Select all

StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;

Thank you.