February 11, 2007 at 1:36 pm
Dear All
I am Sundaraguru from India..
Can any one give idea for error while showing the graph informations in Reporting Services.
I have a record set with 6 records. First 3 is same employee , next 1 (4th one) is 2nd employee. And 5,6th record is another one employee.
Here i need to show the graph who are having more than one record then for me 1st & 3rd Employee i have to show graph's..
IN REPORTING SERVICE DESIGNING TIME:
(ListMain) - Group By - AddressId
In Body First i placed one list in that i placed all the
necessary information about employee. ( for that i gave
group by Employee-Address ID).
DetailList: - Parent list is -> ListMain , Group By - AddressId
In that i placed another one list - This list is contain the
employee detailed informations(Group By is-Emp-Address Id)
GraphList: - Parent list is -> ListMain , Group By - EmpId
Reporting is showing all the Employee. But i need it only who are having more than one Address Informations.
Please give your suggestion for getting report for who are having more than one Address...
I am using SQL Server 2005 , & VS.Net 2005 With November 2006 CTP
And Send your valuable suggestions to following mail id's sundaraguru_s@apollohealthstreet.com and sundharmail@yahoo.co.in.
Advance Thanks
Kind Regards
Sundaraguru S [Confused]
February 12, 2007 at 7:30 am
You can set the Hidden property to False using expressions and checking the AddressID. But its better to handle this in your stored procedure or query. Post your Query or stored procedure.
Prasad Bhogadi
www.inforaise.com
February 12, 2007 at 10:27 pm
Dear Prasad Bhogadi
Thanx for Ur suggestions..
I am using CommandText only ( this is client request)..
Select
* From mst_ServiceUser as Users INNER JOIN mst_Address as Address ON Users.ServiceUserId = Address.ContactUserID and Address.ContactUserType = 'S'
The above query only i used..
Advance Thanx for U.. Any one knows then please give Ur valuable suggestions to me..
Kind Regards
Sundaraguru S
February 13, 2007 at 4:46 am
Use this query to fetch only the data where employee has more than one address. You can also use derived tables.
SELECT *
FROM
mst_ServiceUser as Users
INNER JOIN
mst_Address as Address ON Users.ServiceUserId = Address.ContactUserID
AND
Address.ContactUserType = 'S'
AND
ServiceUserID IN ( SELECT ContactUserID FROM mst_Address
GROUP BY ContactUserID
HAVING COUNT(ContactUserID) >1)
Thanks
Prasad Bhogadi
www.inforaise.com
February 13, 2007 at 5:33 am
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply