Data provider

Hello Bob,

        i linked 8 data providers in my report through LOCATION so in my variables pan i got 8 LOCATION's (ex. LOCATION Query 1, LOCATION Query 2, LOCATION Query 3, ............)  it's showing all LOCATION's (basically all are same) so i want to show only one LOCATION and hide remaining LOCATION's .

Thanks in advance.


matt_man2004 (BOB member since 2004-06-12)

Hi,
If you want to remove from table. you can have any one of the location in the table it will show u all the locations. but if you want to remove from report manager window it is not possiable…


Sasikumar.M :india: (BOB member since 2003-08-01)

Also you can look if you can combine those 8 DP’s into one single DP… I’m not saying you can always but then thats one option for you to have single Location Object in the Report 'coz as stated earlier you cannot hide Variables that are shown in the Report Manager…


Sridharan :india: (BOB member since 2002-11-08)

I have to agree. If you have 8 DPs, then you will have 8 versions of the object. Really nothing you can do.


Steve Krandel :us: (BOB member since 2002-06-25)

As has been stated, there is no way to remove the extra ones from the left hand pane. I just want to be sure you understand that since they are linked, any one can be used in a report block and it will serve as a “proxy” for all the others. Pick any of the 8, and they will all have the same “master list” of values from all 8.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Thanks for your reply’s…….i cannot use single data provide, I have to use all 8 data providers and also getting LOCATION from universe (basically I am using same LOCATION for all data providers) but in my report I have to see only one LOCATION, then what is the best solution

Thanks again


matt_man2004 (BOB member since 2004-06-12)

If you are having 8 DP’s then you are bound to bring that many LOCATION Object if you have in each DP… Now you can use any one of the LOCATION Object from any of the DP if they are all Linked as stated earlier when you want to show in the report but you can’t hide or remove the LOCATION Object from the Report Manager pane without removing it alltogether from the DP…


Sridharan :india: (BOB member since 2002-11-08)

You wlll only see one in the report. You will see 8 in the Report Manager pane. There is absolutely NOTHING you can do to change this. This is simply how the product works.

What people were suggesting is that it is possible that you could implement contexts in such a way that your entire report could be solved in 1 data provider and still product the EXACT same results. Although this is possible, there is no way we can draw that conclusion without seeing the database.


Steve Krandel :us: (BOB member since 2002-06-25)