Results 1 to 4 of 4

Thread: Using Different MSSQL tables to populate table in RDLC report.

  1. Jun 16th, 2014, 08:49 AM #1
    bmf073
    bmf073 is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2013
    Posts
    29

    Using Different MSSQL tables to populate table in RDLC report.

    Hi,

    i just wanted to populate rdlc report table with different MSSQL tables depending on the required condition.

    N.B the structure of all sql tables and table in rdlc report is same.

    Thanks

    Bilal
    Reply With Quote Reply With Quote
  2. Jun 17th, 2014, 02:01 AM #2
    FunkyDexter
    FunkyDexter is offline
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: Using Different MSSQL tables to populate table in RDLC report.

    Thread moved to Reporting as you should get better answers here
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
    Reply With Quote Reply With Quote
  3. Jun 17th, 2014, 12:13 PM #3
    wes4dbt
    wes4dbt is offline
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,508

    Re: Using Different MSSQL tables to populate table in RDLC report.

    Haven't used rdlc in a long time but I think the solution would be to create the report using a Dataset as the datasource. This way you can load the dataset from any database tables that have the correct fields. Here's a start http://msdn.microsoft.com/en-us/library/ms252094.aspx Also, Google "create rdlc report using dataset", there's lots of info.
    Reply With Quote Reply With Quote
  4. Jun 17th, 2014, 01:08 PM #4
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Using Different MSSQL tables to populate table in RDLC report.

    I have no idea what RDLC is...

    with that said, I would normally use a VIEW for something like this - so the "source" of data could be any table.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width