0 votes
1 view
in BI by (17.6k points)

How can i use substring in SSRS......i have something like (vaibhavameta)....i want only first 5 letters
vaibh

1 Answer

0 votes
by (47.2k points)

You have 2 options: 

  1. You could limit the data length in your query so that you only return the first 5 letters to the Report Server, to begin with... this is what I'd recommend only because the fewer data going across the wire, the faster you report will execute.
  2. You could have a look at the LEFT() function as I believe that will get you what you need directly from the reporting services IDE.

You can enroll for MSBI training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.  As part of this training, you will learn data integration and creation of reports, dashboards, and cubes for faster reports generation. 

Related questions

0 votes
1 answer
asked Aug 27, 2019 in BI by Vaibhav Ameta (17.6k points)
+2 votes
3 answers
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !

Categories

...