sql reporting services

[member27]

Hi all Iam using Sql reporting services.i want to generate serial No . I have placed the serialno field inside a group and used the expression rownumber("datasetname") serial Number is generating in random wise..it Should come in ascending order... any one can help me

[Wendelius]

Could you put the numbering into the datatable instead of the report (I'm assuming you use dataaset as the datasource to the report). One way is to create an autonumbered field into the datatable.

The need to optimize rises from a bad design.My articles[^]

[member27]

while adding a new datafiled in dataset and i kept the expression field as rownumber("dataset")..it automatically closes the application.. suggest me any other solution to keeppa autonumber in report and i want to keep tat filed in grouping row...

[Wendelius]

cbenan wrote:

while adding a new datafiled in dataset and i kept the expression field as rownumber("dataset")..it automatically closes the application

I don't understand this. If you simply add a column to the datatable and put the numbers in the rows, you would have the data you want when launching the report. I don't see how this would close the application unless you have an error.

cbenan wrote:

suggest me any other solution to keeppa autonumber in report and i want to keep tat filed in grouping row

That was the only solution that came into my mind.

The need to optimize rises from a bad design.My articles[^]