Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008 SSRS
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:40am
Edited 27-Nov-12 0:43am
v2
Rate this: bad
good
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.
  Permalink  
Comments
Dhivya.J at 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 at 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
good
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.
  Permalink  
v2

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 359
1 Richard MacCutchan 320
2 OriginalGriff 280
3 Jared Sanow 145
4 Snehasish_Nandy 115
0 Sergey Alexandrovich Kryukov 5,939
1 OriginalGriff 4,885
2 CPallini 2,473
3 Abhinav S 1,507
4 Richard MacCutchan 1,437


Advertise | Privacy | Mobile
Web04 | 2.8.140814.1 | Last Updated 30 Nov 2012
Copyright © CodeProject, 1999-2014
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