SQL Server Reporting services only displaying the last row [closed]

sq1bmfud  于 12个月前  发布在  其他
关注(0)|答案(5)|浏览(81)

Closed. This question needs debugging details . It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem . This will help others answer the question.

Closed 6 days ago.
Improve this question

I have built a report pretty basic just a table wiht 45 rows of data. Problem is its only showing one row of data and its the last row. It displays just fine in the dataset and proc. any suggestiosn?

The table is in the body of the report.

soat7uwm

soat7uwm1#

make sure the fields don't have first() or last() in them.

dtcbnfnu

dtcbnfnu2#

probably you have put the fields in the header of the report
build your first report with the report creation wizard and after change it the way you want it

of1yzvn4

of1yzvn43#

or you can just try create a table in the detail part (not header nor footer) of your report and drag some fields from the datasource explorer into the table, after click the preview tab and you will some a table with some records. good luck

eeq64g8w

eeq64g8w4#

You could check if there are any filters associated with the dataset. Click on the Edit DataSet button and check the Filters tab.

8ehkhllq

8ehkhllq5#

What I did is insert a new table; this time, don't delete the header (I found out I deleted it before), and then create the table again.

(Restarting can always help fix something in IT... hilarious...ha ha)

相关问题