how to display fixed number rows to a table in rdlc

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.?

eoswinAsked:
Who is Participating?
 
jimbobmcgeeCommented:
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

0
 
eoswinAuthor Commented:
thanks,...my database is oracle
0
 
jimbobmcgeeCommented:
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
0
 
eoswinAuthor Commented:
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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.