May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Unable to retrieve the data from lists.Unable to retrieve the data from lists.
Previous Previous
 
Next Next
New Post
 4/26/2011 9:08 AM
 
Hi,

I have a list which contains all the regions and this list is used for pushing the values to a Region Parameter.
When I run the report with all the regions as selected.
I am unable to retrieve the data related to some of the regions.
I have checked for list name,column name and everything but could n't find any problem with that .

The query works fine in Dev Environ - same doesnot work in QA & PROD.
Is there anything to check for in SSRS or Enesys that would be resolve this issue.

I am using MOSS 2007, SSRS 2005 & Enesys

Appreciate your help on this.
New Post
 4/26/2011 1:13 PM
 

Hi,

I would first try to narrow down the problem.

Do you know exactly the regions that cause the problem?

If you select this region only don't you get any data?


Frederic LATOUR
ENESYS
New Post
 4/26/2011 3:49 PM
 
I have narrowed down the problem, if i select all the values and run the report - only some of the values are returned.All the regions include North America also.
If i particularly selected a region(for ex:North America,Japan) none of the values are returned.
NO data is retrieved if i select Japan,North America for example here.



New Post
 4/26/2011 5:16 PM
 

It's hard to tell what's going on without the data and the report.

In order to narrow down the problem even further, I would do the following:

  • make a copy of the report
  • Remove the filter and ensure that you get all the data (even Japan)
  • Add a simple filter with a simple report parameter. Not a multi value one, not even drop down list, just a string so that you can enter "Japan" when you run the report.

What do you get?


Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Unable to retrieve the data from lists.Unable to retrieve the data from lists.

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement