Problems in Showing Graphs

  • 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]


    Kind Regards,

    Sundaraguru S

  • 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

  • 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


    Kind Regards,

    Sundaraguru S

  • 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

  • Hi Prasad Bhogadi 

    Thanx for giving your ideas...

    What i need means..

    I have to show graph only for those who are having more than one Address ..  If any one service not having more than one address, That time i need not show the graph..

    Thanx

    Kind Regards

    Sundaraguru S


    Kind Regards,

    Sundaraguru S

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply