0

I've been trying to use a Stored Procedure in Datazen, but every time I build the dataset, it doesnt actually return any data (yet doesnt give me an error and does give me the column headings). I've tried the same query in SSRS 2016 and the new mobile report builder, and both work a charm, but Datazens just not having it.

USE [SSRS_Reports_SPs]
EXEC [dbo].[Test]

Really, I just want to know if its possible in datazen, and if so what I might be doing wrong. Cheers

ostrich160
  • 21
  • 1
  • 5
  • Do you have `SET NOCOUNT ON` in the beginning of your SP? There was such problem with some PHP code, all was working without errors, but when fetching SP results - there was nothing, this option helps. – gofr1 Jul 29 '16 at 11:03
  • No it doesnt start with SET NOCOUNT ON, shame that sounded like a simple solution – ostrich160 Aug 02 '16 at 08:32
  • So it works now? Or this was not helpful? – gofr1 Aug 02 '16 at 08:35
  • No its not working now I'm afraid – ostrich160 Aug 02 '16 at 09:09
  • Stored Procs certainly work in DataZen but if you're in SSRS 2016, the previous version of DataZen has now become the Mobile Report Publisher. What do you mean by DataZen? – strattonn Aug 15 '16 at 01:07

0 Answers0