What I have in this list (SQL Call is below) is a subset of a table with 3 orders (could be more) worth of parts.... I need a summation of what are the common parts (based on Part), and in a seperate query, based on Part and Part_Rev. Using SQL Server
SELECT ORDER_ID, PART, PART_REV FROM ORDER_DETAILS
WHERE ORDER_id IN(203,198,205)
View Complete Post
Can we use different resultset in our Report. Like if we have written two select statement in our SP, how can we use the different result set to bind them in our Report.
Thanks in advance.
I have two webparts. One has to fetch column values from List A and the other has to fetch the values from List B. List A and List B has common column "Service". This column is multiple value lookup type in List A and single value lookup type in List
B. I have to connect two webparts in such a way that clicking on Service (mutiple value lookup filed) from the first webpart filter the second webpart on this column basis.
As, the first webpart has mutliple values, i am not able to filter on a single value as it is treating the multiple values as a single string.
Can anyone suggest me how to achieve this?
Thanks in advance,
Currently i trying to do display / hide multiple web parts (content query) based on user click. I have created 5 content query, on default it will show only 1 web part and others web part will be "hidden". When user click another selection, it will show
the correct web part information and hide others. I will really appreciate if anyone could give me the idea, guideline to perform this task.
Roughly i have an idea which is using getElementByID to control the webpart ID however i did not try it yet . I also go through below link however i still cant understand well how it works. Thank you.
Ref: Show/Hide Multiple Web Parts by Bryon Wyle