Solved

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

Posted on 2009-04-03
2
481 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL LINE CONTINUATION ISSUE 12 31
SQL: launch actions one before the other 10 22
export sql results to csv 6 34
Simple SQL query from two tables 13 51
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

808 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