A data source instance has not been supplied for the data source
-
Hi All, I have an SSRS report when we export it to excel, it is exporting in 4 different tabs rather in one tab, I want it to be exported to one excel tab. I have set the Disabled property in Page break of both the groups that exists to =IIF(Globals!RenderFormat.Name = "CSV" OR Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL", true, false), in report preview it is displaying correctly and generating the excel with only one sheet, but unfortunately when I try this in report viewer, it is displaying the following error "A data source instance has not been supplied for the data source 'DataSet1'." Actually when I investigated it looks like it is missing the parameters, because the reports parameters are generated from the report dynamically some how they are not getting generated. It runs perfectly in the report preview why isn't getting generated when I run from report viewer I am not understanding. Can anybody please help me in this regard? I need some help any link, suggestion or code snippet any help would be really helpful. Thanks in advance.
"There is enough hatred in the world, lets spread love compassion and affection."