Click here to Skip to main content
Search within:



Next

Refreshing already created dataset in ssrs after editing it
Sign Up to vote bad
good
See more: SQL2008SSRS
Hi
 
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:40
Dhivya.J598
Edited 27 Nov '12 - 0:43
v2
Add a Solution


2 solutions

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.
  Permalink  
Posted 30 Nov '12 - 3:24
Member 95814881.7K
Edited 30 Nov '12 - 4:11
v2
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.
  Permalink  
Posted 27 Nov '12 - 3:19
Member 95814881.7K
Comments
Dhivya.J - 28 Nov '12 - 6:59
I have tried what you said but still i m facing the issue... Any more ideas? Pls help..
Dhivya.J - 28 Nov '12 - 7:02
If I refersh fields simply without executing the query, i m getting my dataset with empty fields.. Pls help.
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 294
1 OriginalGriff 195
2 CPallini 163
3 Mahesh Bailwal 159
4 Tadit Dash 148
0 Sergey Alexandrovich Kryukov 10,169
1 OriginalGriff 7,749
2 CPallini 4,181
3 Rohan Leuva 3,482
4 Maciej Los 3,089


Advertise | Privacy | Mobile
Web03 | 2.6.130523.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid