5
Answers

how to auto increment a column in a specific format

Mustaq Khan

Mustaq Khan

12y
1.4k
1
I have a column name JobCode , i want it to increment automatic in the formate A-1, A-2....A-200 then it should start from B-1,B-2...B-200 and so on upto Z-1...Z-200....!! i want to code to save the column value into sql server database.
Answers (5)
2
Thiyagarajan E

Thiyagarajan E

NA 1.1k 6.8k 8y
I found the Solution:
Finf the Report web config in the below path :
C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportManager\web .config
Replace or add below line: to set admin credential for all users to access the report.

<authentication mode="Windows" /> // Authentication mode to be set to windows

<identity impersonate="true " userName="UserName" password="Password"/> // identity impersonate to be set to true and User name & Password of the SQL Server administrator should be added.