I have an employer id value (12-3456789) totally 9 digit. I have this field as a varchar(10) in my DB.
I wrote my stored proc to pull this info for my report.

(CODE)


SSRS Expression I have is…

Can someone help me understand what am I doing wrong in this VB6 function?

I have a Custom code in my SSRS report which will be invoked from my report. All it does it takes input (MilestoneTypeId) …

Hi Experts,

I have a report.

I noticed when I open a report.rdl file in VS2013 I see the main part of the report.  When I do a deploy of that .rdl file and copy the link into a browser a Selecti…

Hello,

I am developing a SSRS Report in which i have date parameters based on different selections. It has the date range like
1) Last week
2)Last month
3) YTD
4) Last quarter
5)Custom date
…

Hello Everyone,

I have a strange issue, i have developed a report which  has multiple parameters in it. When i am running it in visual studio its working fine but when i deployed it on web server a…

Hello,

I need some advice on setting up security/permissions to users in SSRS.
Here is the requirement
1.      Build one standard report using Report Builder. Publish this report in SSRS.
2.      Provid…

I am having issues getting a SSRS report site up and running and making it accessible form the internet. I can access the Report Manager URL from inside my network. I can also access the Web Service U…

I am trying to add multiple values for highlighting the cell. Trying to use "IN" and i don't think the syntax for the expression is correct...

Trying to add both values that are bold: (it works wit…

I am trying to run a query that will provide me with all the stored procs being used by report server and what report they are used in.

I would then like to some how compile this list of stored pro…

I need to show text after a field in SSRS. I am able to do an "If, Then" to replace a value, but would like to show text after the standard value. This is the expression I currently have:

=IIF(Fie…

If I define a variable in the OS like:

SET MyTest="Hello"

Is it possible and if so, how, to get that MyTest variable value into an RDL of SSRS? It's on SQL Server 2014.

It is possible to do …

Hi All,

I'm currently running SQL Server 2012 Standard SP1 on my Windows Server 2008 R2 and have login as SA user, somehow I cannot start the SQL Agent from SSMS and cannot edit the SQL maintenance…

Hi All,

I'm running the below database in older physical box:

(CODE)

and planning to migrate it to different box using offline backup method (cold backup). Hence I need to shrink the SQL serv…