Sorry, i did not understand. Are you asking to create an other dataset and use lookup function to link both of them? I tried it it did not work.

Yes, in SSRS expression we use IIF. But when in query designer when creating a dataset, we use IF. Please correct me if i'm wrong.

In the SP. In the original SP based on parameter selection it gives two different results set i.e. one for SSRS and other for SSIS. I thought when i hardcode...

I set nocount on and it is displaying the results. Before it used to not export any data. I sed the below script in my ssis package and it is...

I used below conncetion string and it worked.

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=0.0.1.23;

Initial Catalog= Adbcfg;Package Collection=Default Schema;Default Schema= adc;User ID=user;

Password=pass;

In the above link, it showed how to create a linked server. But i need to create a datasource on SSRS server to which my reports needed to be pointed?

Yes, I just did it.

Thank you.

Thank you it solved my issue.

I'm sorry I didn't explain it correctly. I need all products and products with status NA must have onhand greater than zero. Below is what i want to display:

ProductStatusOnHand

1230DI20

7689TO20

6758NA10

I used ROW_NUMBER function only to get the rank with partition. But i could not get get total rank for each city.

I figured a work around to get the MAX...

Sorry for the confusion. Thats why i did not add UPC before.

UPC is universal product code. Few products may have same UPC. This is a business thing.

So if they...

I need to use sum on inventory as I was grouping on UPC. To avoid confusion I did not use UPC field.

Now when you run the query below you...

I have used a different way, it runs fine but it displays same vale if the date is same for two rows. Below is the example. Please see row 2...

ProductRDateQuantityOnHandRunningTotal

10112/15/2012 0:00355635

10111/11/2012 0:00315666

10111/1/2012 0:00235689

101112/26/2011 0:0010456193

21342/10/2012 0:00272627

21341/26/2012 0:00542681

This is how i want to see. Can we do that without using cursor?

The problem is we are not allowed to use open queries in out campany.