October 10, 2013 at 8:06 am
Hi folks,
I was wondering if anyone can help me out please.
I was using Stored Procedure in SSRS but when I use SP and click on Refresh fields the fields are not getting updated in SSRS.
I have around 6 parameters to pass to stored proc.
I tried in the follwing ways.
1)change the Querytype to Text
Execute sptest @param1,@param2,@param3,@param4,@param5,@param6
2)change the Querytype to StoredProcedure and selected my SP
Gave Refresh fields
But its not working for me.I would be very greatful if you could help me out.
October 10, 2013 at 8:09 am
What is not refreshing?
Is it the output column names OR the parameter names?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);October 10, 2013 at 8:14 am
The output column names are not getting refreshing.
October 10, 2013 at 8:23 am
Are you using a temporary table in the stored procedure?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);October 10, 2013 at 8:31 am
yes I have three temp tables in my stored procedure.
Won't it work if I have temp tables in SP?
October 10, 2013 at 9:33 am
What version of Reporting Services are you on? If it is 2012, you can use WITH RESULTSETS, if not, you might be able to use a dummy statement in the SP:
IF 1=0
SELECT TOP 0 col1, col2, col3 etc
FROM YourTable
(where the column names and datatype match exactly to the actual output of the SP.)
... at the top of the SP sometimes works to provide enough column information.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);February 16, 2015 at 11:30 pm
u got any solution to this..? I am getting same problem..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply