how to display fixed number rows to a table in rdlc

Posted on 2011-04-20
Last Modified: 2012-08-13
i have a subreport which needs to print exactly 10 rows.  even if the datasource fetches 2 records , i want a print 10records.. can you tell me how to do that.?

Question by:eoswin
    LVL 16

    Accepted Solution

    Is your report data source a SQL Server 2005/8 query?  If so, it might be easier to alter the query to always bring back 10 rows.  For example:
    SELECT * FROM my_report_table ORDER BY col_01 ASC

    Open in new window

    might become:
    WITH cte_nums AS (
        SELECT n = ROW_NUMBER() OVER (ORDER BY a.object_id, b.object_id)
        FROM sys.columns a, sys.columns b
    cte_report AS (
        SELECT *, n = ROW_NUMBER() OVER (ORDER BY col_01 ASC)
        FROM my_report_table
    SELECT n.n, r.*
    FROM cte_nums n
        LEFT JOIN cte_report r ON n.n = r.n
    WHERE n.n BETWEEN 1 AND 10

    Open in new window


    Author Comment

    thanks, database is oracle
    LVL 16

    Expert Comment

    If it is Oracle 10g upwards, it should be very similar, as WITH and ROW_NUMBER() are ANSI standard.
    Try changing sys.columns to all_tab_columns; otherwise it should be the same

    Author Comment

    sure try that...

    Is there any way i can print a rdlc table on a top of a fixed rectange with lines accross looks like a table?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Java/J2EE and SOA

    This course will cover both core and advanced Java concepts like Database connectivity, Threads, Exception Handling, Collections, JSP, Servlets, XMLHandling, and more. You'll also learn various Java frameworks like Hibernate and Spring.

    This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
    One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on could not pull conte…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now