Click here to Skip to main content
12,357,409 members (73,019 online)
Rate this:
Please Sign up or sign in to vote.

I am new to SSRS. I have created a dataset in which i called a store procedure. If i did modify the store procedure and run the query in dataset properties and click ok, the query is running fime but the fields are becoming empty. I dono the reason for it and how can i overcome it. Pls help... Thanks in advance.
Posted 27-Nov-12 0:40am
Edited 27-Nov-12 0:43am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

First thing you can do is refresh your data-set fields.

Sometimes it saves the changes and sometime it does not.

If the above option doesn't work then try to connect it again,refresh it and you don't need to drag and drop the data-set values.
Dhivya.J 28-Nov-12 6:59am
I have tried what you said but still i m facing the issue... Any more ideas? Pls help..
Dhivya.J 28-Nov-12 7:02am
If I refersh fields simply without executing the query, i m getting my dataset with empty fields.. Pls help.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Dont delete the existing one otherwise you have to drag and drop the dataset Fields again.Try to add the SQL Stored Procedure again.And then Refresh the dataset. Try to run the report. Make sure you are connected to right Database.

Second thing execute SP in SQL Server itself and check if its really returning Some values.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100