building a dataset !

  • Hi,

    I have 6 tables MustHave_...... , and a table project.

    i wanna display in ssrs a table which contain for each project, the percentage for each must have !

    should i use a join or a union for my 7 tables ?

    thank you

  • Like a lot of questions - the answer is it depends - we can't see the table structure you have there.

    Please read the link in my signature for how to get the best answer from us and how to get the information for us to see.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Hi,

    I just understand my need actually,

    I have 6 lists in Sharepoint that depend on another list

    and i wanna know how can i do a join between lists in Sharepoint, to create my dataset in SSRS ?

    Hope it's clear now ? (coz i can't write all the structure and details of the tables )

    Thank you

  • salmita (3/1/2013)


    Hi,

    I just understand my need actually,

    I have 6 lists in Sharepoint that depend on another list

    and i wanna know how can i do a join between lists in Sharepoint, to create my dataset in SSRS ?

    Hope it's clear now ? (coz i can't write all the structure and details of the tables )

    Thank you

    Looks like it's not possible: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/1afe35ce-8498-42b7-9f62-1c434f4cd2b5

    By the way, this is SQL Server T-SQL forum. It has no much to do with Sharepoint. You better to try some sharepoint forums.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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