Solved

Can someone please check the format of th value in my textbox, I am getting an error?

Posted on 2009-04-03
2
484 Views
Last Modified: 2012-05-06
Hi,

I have a textbox in my report with this:
= "Total Number of Incidents in Service Alliance queue: "&"          "&(Fields!seq.Value, "IncidentsInSAQueue")

and it is giving me an error:
C:\Reports\Astea\Astea\Service_Alliance_Incident_Report.rdl The value expression for the textbox textbox3 contains an error: [BC30198] ')' expected.
 Can someone please show me what the issue is?

Thansk,
Rhonda
0
Comment
Question by:Rhonda Carroll
2 Comments
 
LVL 16

Expert Comment

by:Auric1983
ID: 24059451
Rhonda,

Try this

= "Total Number of Incidents in Service Alliance queue: &     " + First(Fields!seq.Value,"IncidentsinSAQueue")

in SSRS the concatination charactor is a +
0
 
LVL 11

Accepted Solution

by:
shorak earned 250 total points
ID: 24075291
Try the following (assuming you want the first seq value from the dataset 'IncidentsinSAQueue'):

= "Total Number of Incidents in Service Alliance queue: " & "          " & First(Fields!seq.Value, "IncidentsInSAQueue")

Also, are you deliberately adding extra blank spaces? What you could do is put the blank spaces in the first part of the expression.. ie:

= "Total Number of Incidents in Service Alliance queue:           " & First(Fields!seq.Value, "IncidentsInSAQueue")

Hope this helps

Rob
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Group By Question 4 20
Help With SQL Query 9 33
too many installs coming along with SQL 2016? 1 17
SQL 2012 clustering 9 13
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question