Reporting Services :: Value Expression For Text Box Specifies A Scope That Is Not Valid For Nested Aggregate
Apr 22, 2015
I'm trying to sum a column in a report. in Most columns I can just wrap the row level expression with "Sum()" and it works. However, I have run into a few that give the following error. The Value expression for the text box ‘Textbox241’ specifies a scope that is not valid for a nested aggregate.  The scope must be the same name of the scope specified by the outer aggregate or the name of a group or data region that is contained in the scope specified by the outer aggregate.Here is my row level expression that works.
=Code.Divide(sum(Fields!WeeklyUnits.Value),sum(Fields!EstUnits.Value))
*
(Code.Divide(sum(Fields!EstHours.Value),sum(Fields!EstHours.Value,"Job")))
Here is my attempt to Sum the row level for the footer area.
=Sum(Code.Divide(sum(Fields!WeeklyUnits.Value),sum(Fields!EstUnits.Value))
*
(Code.Divide(sum(Fields!EstHours.Value),sum(Fields!EstHours.Value,"Job"))))
View 9 Replies
ADVERTISEMENT
May 6, 2015
I am trying to create a column chart that calculates the percentage of computers in our IT environment that are Actively communicating to our SCCM Server.
I have two datasets:
1. Total_Count_Of_AD_PC DataSet.
2. PC_With_Active_SCCM_Clients dataset.
Basically i wan to calculate the percentage for each Region (i.e. AP for Asia Pacific, EMEA, Americas).
Below is the Total_Count_Of_AD_PC  Dataset screenshot.
Below is the PC_With_Active_SCCM_Clients dataset.
Below is the expression that i used that is causing the error.
=CountDistinct(IIf(Fields!Region.Value="AP", "PC_With_Active_SCCM_Clients"),(Fields!Name.Value, "PC_With_Active_SCCM_Clients"),Nothing)/CountDistinct(IIf(Fields!Region.Value="AP", "Total_Count_Of_AD_PC"),(Fields!name.Value,
"Total_Count_Of_AD_PC"),Nothing)
Below is the error message....
The Y expression for the chart ‘Chart2’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
View 6 Replies
View Related
May 21, 2015
I have created a heat map and it is working pretty well. The only issue I am having is that the expression for the fill is using "DataSet1"
=Code.GetHeatmapColor(sum(Fields!AnnualPremium.Value),Min(Fields!AnnualPremium.Value,"DataSet1",Recursive),
Max(Fields!AnnualPremium.Value,"DataSet1",Recursive))
This is making the heatmap look at the whole dataset instead of just what I am grouping by. Within the Dataset there are Regions and Credit Unions. Since the Dataset is looking at an entire region, the heatmap is coloring based on all data for the region. I need to heatmap to color based on the Credit Unions in that region. The Credit Unions are a group. I need the group to be the value it is referencing in the heat map and not "DataSet1". I have been told to use scope or a variable but cannot get it to work correctly.
View 3 Replies
View Related
May 2, 2007
Hi,
I get the above error everytime I try to export to Excel; exporting to PDF works fine.
The only way I can get rid of the error is by deleting all the data from within the report (not ideal!). Anyone got any ideas on what could be causing this?
Many thanks,
Mani
View 1 Replies
View Related
Jun 1, 2015
I have a data field in a SSRS Report that contains the requestor's User Id. Their ID is prefixed with "PRIV"...And I'm assuming that is the direct result of the network domain. I need to create a SSRS expression to determine if the User ID is prefixed with "PRIV" and then parse that out and use what's behind the "" as their true User Id.
example...."PRIVID123456" should appear as "ID123456" in the report data line.
View 5 Replies
View Related
Oct 28, 2015
I have created 1 report with 2 datasets. This report is attached to the 1st dataset.For example,1st one is "Smallappliances", 2nd is "Largeappliances".
I created a tablix and, the 1st column extracts Total sales per Sales person between 2 dates from 1st dataset (Small appliances). I used running values expression and it works fine.
Now, I would like to add another column that extracts Total sales per sales person between 2 dates from 2nd dataset (Large appliances). I am aware that I need to use Lookup expression and it is giving me the single sales value rather than the total sales values. So, I wanted to use RunningValue expression within lookup table to get total sales for large appliances.
This is the lookup expression that I added for the 2nd column.
=Lookup(Fields!salesperson.Value,Fields!sales_person.Value,RunningValue(Fields!sales_amount.Value,
sum, " sales_person"),
"Largeappliances").
I get this error when I preview the report.An error occurred during local report processing.The definition of the report is invalid.An unexpected error occurred in report processing.
(processing): (SortExpression ++ m_context.ExpressionType)
View 7 Replies
View Related
Oct 29, 2015
I have one row group in report which is on stage
format like ..
Stage     Files
I Â Â Â Â Â Â Â Â 10
O Â Â Â Â Â Â Â Â 20
U Â Â Â Â Â Â Â Â 30
T Â Â Â Â Â Â Â Â 40
Now the files are coming by forming group on stage.
here , stage I has 10 files coming and i have one column with these rows as TYPE_Id which is either 1 or 2Â now i want to build an expression to see if the files have included such file which has files type 2 and if number >1 then i want to return a flag ..
i had tried iif but it is returns same if files contain of type 2 or not .
how to write a expression which tell me that these stage files has type_ID =2 files
View 2 Replies
View Related
Oct 19, 2007
Can any1 tell me why i am getting an error
SELECT DISTINCT
--p.voucher,
--p.amount,
p.siteID,
b.siteID,
SUM((round(b.total,2,2)) - SUM(round(p.amount,2,2))) AS OutStandingBalance,
SUM((round(b.total,2,2)) - SUM(round(p.amount,2,2))) AS CashCheque,
SUM((round(b.total,2,2)) - SUM(round(p.amount,2,2))) AS Vouchers
FROM
BillingTotal b,
Payment p
--WHERE
-- s.sitename=@cmb1
--AND p.siteid = s.siteid
-- p.voucher = 0
-- p.voucher = 1
GROUP BY p.siteID,b.siteID
Msg 130, Level 15, State 1, Line 1
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
View 8 Replies
View Related
Nov 8, 2006
Hi there
I have a sales report that is pulling up data and displaying the detailed lines and the aggregate/summary lines grouped by a single field.
THe report say has 10 summary/aggregate lines and each summary lines have a maybe 20 more lines to it.
I want to NUMBER the SUMMARY lines only. In a new column on the summary line cell, if I type, =RowNumber(Nothing), I get a count of all its sub-lines displayed. How can I limit the scope of numbering to just the summary lines and make sure it does not include the sub lines involved ?
View 7 Replies
View Related
Aug 10, 2009
When publish report define file (SSRS2008 ) to SSRS2008 server , it throws that the report definition is not valid. But I use VS2008 deploy it and  it is succeeded to publish to SSRS2008 Server. Why ?
<errorinfo>Details: '.', hexadecimal value 0x00, is an invalid character.</errrorinfo><code> Reporting Service 2005 m_ReportingService = new ReportingService2005();this.m_ReportingService.CreateReport(reportName, parentFolder, overwrite, report, null)</code>
View 7 Replies
View Related
Jun 14, 2013
I am getting this error when upgraded to SQL Server 2012. Earlier the same report(.rdl) just working fine on SQL Server 2008 R2.
Message = System.Web.Services.Protocols.SoapException: The value of parameter 'param' is not valid. ---> Microsoft.ReportingServices. Diagnostics. Utilities.InvalidParameterException: The value of parameter 'param' is not valid. ---> System.UriFormatException: Invalid URI: The Uri string is too long.
Is there anything changed in SQL Server 2012 regarding this.
View 8 Replies
View Related
Oct 7, 2006
I have the problem of aggregating semi-additive measures correct in higher levels in a matrix control of reporting services. I use the "Microsoft SQL Server Analysis Services" data provider. I have a calculated measure saved in the AS2005 cube which looks like:
[Measure].[Net Sales (kg)] = iif( [Measures].[Sales Volume KG] = 0, 0, [Measures].[Net Sales (RLG)] / [Measures].[Sales Volume KG] )
In the matrix, I have a 4 level Product Dimension on the rows (4 groups matrix1_level1 ..... matrix1_level4) and the visibility of the groups is toggled by each upper level, so I can drill in the product dimension. I place this measure in the data part of the matrix with (sum(Fields!Net_Sales__kg_.Value)). On the leave level all values ar correct. But on each other level, I see the sum of the sublevels.
After a lot of pain researching, I found that I have to use the "aggregate" function instead of the "sum" function, because aggregate uses the aggregating which comes from the data provider and the "Microsoft SQL Server Analysis Services" data provider is able to do that. Thats all of documentation I found. I have played around with this function, but always when I use it, I get no values on all levels. I tried the "scope" parameter of the aggregat function, nothing changed.
I tried aggreagate(Fields!Net_Sales__kg_.Value, "matrix1_level1"), aggreagate(Fields!Net_Sales__kg_.Value, "SalesCube") (SalesCub is the name of my Dataset in Reporting Services I use), aggreagate(Fields!Net_Sales__kg_.Value, "matrix1") and last but not least aggregate(Fields!Net_Sales__kg_.Value), all is the same, no values.
It seems to me, that the aggragate function returns "Nothing", because than, according to the Online Help, no values will be shown. But according to some blogs and forum entries, the "Microsoft SQL Server Analysis Services (AdomdClient)" Data provider should deal with aggregate. Have I do some special entries in the "Advanced..." Settings of the data provider??
Can someone tell me, what I'm doing wrong, and did someone know a good documentation (with examples) for the aggregate function on the internet. The Help-file doc is very, very poor!!!
Thanks
Hans
View 4 Replies
View Related
Oct 22, 2015
We have two measures
[Measures].[NSPO]
is in FACT1 Â Measure Group
[Measures].[NetSignedPremium] is in FACT2 Â Measure Group
The requirement is Measure.[NetPremium] should be the greater of
[Measures].[NSPO] OR [Measures].[NetSignedPremium].
Â
All three measures are created in the cube and this logic is to be applied in the Calculations section of the cube.
Using an IIF statement like one mentioned below does the job, but data does not aggregate correctly for the
Measure.[NetPremium]
Measure.[NetPremium] = IIF ([Measures].[NetSignedPremium] > [Measures].[NSPO], [Measures].[NetSignedPremium] , [Measures].[NSPO])
To ensure that the columns are aggregated I have to use a SCOPE statement at the leaf level
[01 UWR Reference].[UWR Reference].Members Â
Â
SCOPE(
    FILTER( NONEMPTY( [01 UWR Reference].[UWR Reference].Members  ) ,
         ( ( ([Measures].[Net Signed Premium Rcvd])
         - ( [Measures].[NSPOTest] ) )
             < 0 ) )) ;
        This =  [Measures].[Net Signed Premium Rcvd] ;      Â
ENDÂ SCOPE; Â
My problem is the FILTER within the SCOPE statement does not work. How to modify the filter in SCOPE? OR How to make IIF Aggregate correctly?
View 4 Replies
View Related
Oct 21, 2015
I want to create subscription for a report.
While creating it gives error "Operation is not valid due to the current state of the object".
I am able to create subscription for other reports deployed. But it gives error for subscription of a particular report.
Tried deploying the report with other name then too it does not allow me to create subscription.
View 3 Replies
View Related
Apr 18, 2015
I have a table with one of the column(EmpHiredate) datatype is char(10). It has value like "20141023". I need to display this value as date format(dd/mm/yyyy) in report. Following methods i tried in textbox expression but no luck.
=Format(Fields!EmpHireDate.Value,"dd/MM/yyyy")
=Cdate(Fields!EmpHireDate.Value)
Error:[rsRuntimeErrorInExpression] The Value expression for the textrun ‘EmpHireDate.Paragraphs[0].TextRuns[0]’ contains an error: Conversion from string "20041023  " to type 'Date' is not valid.
Is it possible to convert string to date using SSRS textbox expression ?
View 7 Replies
View Related
Jun 3, 2015
When i try to restore the encrypt key to reporting service getting the below error.The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '147'. The expected version is 'C.0.9.45'I found the table in Database  called DBUpgrdaeHistory
UpgradeID DBVersion
Datetime
31 147 Â Â Â Â Â
[code]...
View 4 Replies
View Related
Apr 20, 2015
We are constrained to use a model that stores records in a main table and various attributes of the record in a second table. Something like this: main record table CAR, attribute table CAR_DETAILS with CAR_DETAILS have key value pairs like "color" "blue" and "doors" "4".
For reports we need to flatten the one to many nature of this to get CAR and color and doors by using an aggregate function like:Â
car_id, max(car_detail.value) filtered on car_detail.key = "color", max(car_detail.value) filtered on car_detail.key = "doors".Â
This works on other tables but the car_detail table (shall we say) appears to store its values as blobs. In any case when we attempt to aggregate we get "The query uses an aggregate function on a large value type expression. Large value type expressions can not be aggregated."
Since we can't change the model, we would need to use another function to change this to a smaller string (or date, these are actually mostly date), but none of the very limited set of functions available seems to work to make this aggregation possible (and there is no "first" or anything else similar).Â
The list of functions available in Report Model Queries can be found at [URL] .....
View 2 Replies
View Related
Apr 21, 2015
I have report showing sales by Vendor. I need to list all the vendors with Monthly Total>5000 and combine the rest as "OTHER VENDORS"
Vendor is a Group in my report, so I tried to put an expression as a Group on:
=IIF(Sum(Fields!Mth_1_Sales.Value)>5000,Fields!Vendor_No.Value,"OTHER VENDORS")
I've got an error: "aggregate functions cannot be used in group expressions"
How do I get Vendors with Sales < 5000 into "OTHER VENDORS" ?
View 4 Replies
View Related
Jan 15, 2008
Is it possible to nest list items that use different datasets? I am currently working on a report that consumes information from several different tables. Is there a way to achieve this using nested data regions?
Here are some of the items from the report-
IT Plan
----------
IT Plan Headers 1-10
IT Plan Projects
-------------------
Project Headers
IT Plan Project Sponsors
-------------------------
Sponsors 1-n
IT Plan Project consumers
---------------------------
IT Plan Project Survey
------------------
Survey Qs and Responses...
IT Plan Project Alignments to Intiatives
-----------------------
Alignments 1-n
..... several other such subsections.
and then the information gets repeated for the next IT plan.
I thought it might be possible to nest data regions. After placing nested lists on my reports, when I try to associate data from other datasets onto to the nested list, the report designer UI only exposes aggregate functions like Count or First in the expression editor --> Fields collection. It does not let me associate other datasets.
If anybody can provide some details on the best approach to tackle a huge report like this, I would really apprecaite it. I am currently going with the Sub reports approach.
Thanks
Kaushal
View 4 Replies
View Related
Jun 8, 2001
We are migrating a SQL 6.5 application with 1900 stored procedures that use 100's of temp tables to SQL 2000.
A problem we have encountered was that we started out getting an "invalid column" errors on certain procedures. Investigation determined that the error was being generated in a nested procedure. The table that caused the error ended up being a temp table that was created using "select into". The following select statement from that temp table gave the invalid column error.
First thinking it was the "Select Into" we then discovered that the outer most procedure had created a temp table of the same name prior to executing the lower level procedure. After the select into, the next statement was a SELECT that went against what it thought was the inner temp table. However, it grabbed the outermost temp table and then couldn't find the appropriate columns and generated the error.
The solution, of course, was to rename the inner most temp table. We also remove the "select into" in the procedure by explicitly creating the temp table.
We tried creating some test procedures to attempt to reproduce this scenario without complete success.
Our test created 3 procedures (sp1 calling sp2 calling sp3) to mimic the current scenario. Sp1 created a temp table and executed sp2, which executed sp3. Sp3 created another temp table using the same name as the one created in sp1.
If we create all three procedures at the same time, it doesn't matter if we change the order in which they are created or whether we create the inner temp table explicitly or with a "select into", SQL Query Analyzer won't let us create the procedure because it finds that the temp table has been declared twice. If we create the procedures separately however, they compile and allow sp3 to create a temp table by the same name as sp1. After creating the procedures independently, they runs properly in all cases with everything in proper scope and no problems.
Admittedly, this is bad coding to start with, but what is happening with the scope of the temp tables within the stored procedures?
Thanks,
Glen Smith
View 1 Replies
View Related
Jun 11, 2015
I am using SSRS 2014. I'm using a matrix instead of a tablix because it allows me to have dynamic columns. In the example I'm showing, two of the columns use the sum function to get the total counts per practice. The third column contains percentages so I averaged for the total but the value is inaccurate compared to the value I would get if the divided the the two totals that are sums of the counts. Is there a way for me to specify that I want to divide the total counts numerator divided by the total counts denominator?
Here's an example report output with the percentage column averaged (inaccurate):
PCP Â Â Â Â Â Â numerator denominator percentage
John Smith  66       104 63.46
Tom Jones   4         36   11.11
.
.
.
Jane Doe    1   1     100
Total 708 Â Â Â Â Â 1005 Â Â Â Â 72.3
So the 72.3 value is from Avg(metricvalue)
I would like to do this instead: % total = 708/1005, which equals 70.5 - a significant difference.
The metricvalue column is what is the value for every number above (Because it's a matrix).
View 2 Replies
View Related
Nov 20, 2015
Here I am trying to do switch then nested IIF in it. I dont know where i missed but this doesnt work.for first condition in switch, 'WEEKLY', WW2 and WW1 is in number form but of text/string datatype. so after cast them to integer/number datatype then those are use in iff operation.for second condition in switch, 'MONTHLY', WW2 and WW1 is month name. so the objective is to get month number from month name. After that, then WW1,WW2 are use in iff operation.
=SWITCH(Parameters!date_range_type.Value
= "WEEKLY", IIF((cInt(Parameters!WW2.Value) - cInt(Parameters!WW1.Value)) > 10, Parameters!WW1.Value,IIF(cInt(Parameters!WW2.Value) < 11,1,cInt(Parameters!WW2.Value) - 10)), Parameters!date_range_type.Value = "MONTHLY", IIF((cInt(MONTH(datepart("YYYY",today())&
"-" & Parameters!WW2.Value & "-01")) - cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW1.Value & "-01"))) > 10, MONTH(datepart("YYYY",today())& "-" &
Parameters!WW1.Value & "-01"),IIF(cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW2.Value & "-01")) < 11,1,cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW2.Value
& "-01")) - 10)) )
if i run report for 'WEEKLY' only, means doesnt need switch and the other iif condition, it working fine. so does when run on 'MONTHLY' only.
View 2 Replies
View Related
Jun 23, 2015
I have a scenario where I would like to use the 'OR' statement in SSRS expression.
I have the following fields:
GLnumber, ProgramControl, GLAmount & EscrowDepositAndWithdrawal.
What I would like to do is as follow:
If GLnumber is 12200.22162 then I would like to take EscrowDepositAndWithdrawal
OR
If ProgramControl is 'escrow' then I would like to take EscrowDepositAndWithdrawal
OTHERWISE I would like my expression to take GLAmount My expression looks something like this:
=IIf(Fields!GLNumber.Value = "12200.221620" OR Fields!ProgramControl.Value = "ESCROW",Fields!EscrowDepositAndWithdrawal.Value,Fields!GLAmount.Value)
It appears only the first IF statement is true. It does not appear that the OR statement never be true.
I am not sure why the OR statement never satisfied. I know I have a record with ProgramControl = "ESCROW".
View 2 Replies
View Related
Mar 25, 2008
Hi all,I wrote the following expression in one cell in my table
if there is no value for fields i am getting the following out put in that particular cell.
I am calculating percentage.
I have more than one datasets in my report.
=Round(100*Sum(Fields!WCOUNT_5.Value, "MaxNumeracyCountForSelectedSch")/Sum(Fields!QCOUNT.Value, "MaxNumeracyCountForSelectedSch"),2) & "%"
NaN%(This is the result in Cell)
Pls help me.
View 5 Replies
View Related
Apr 20, 2015
Below is my query, it output's a percentage based on some calculations that i've had to make to fit in with requirements.The trouble is that it is also coming with NaN values which i need set to 0%,modify the below query to accomplish this?
=Sum(IIF(IIF(ISNOTHING(Fields!TotalHours.Value) = true,25,Fields!TotalHours.Value) <= 24,1,0)) / Sum(Fields!SubTotal.Value)
View 7 Replies
View Related
Sep 22, 2015
I have a ssrs report R1 having a button B1 and a another report R2. On the click of B1 i want to download R2 in excel format.I have used action->Go to url property on B1 and have used the below expression to fetch the url for downloading R2 in excel format.
Â
=Globals!ReportServerUrl &"?" & Globals!ReportFolder & "/" & "ReportName" &
"¶m1=" & Parameters!param1.Value &
"¶m2=" & join(Parameters!param2.Value,",") &
"&rs:Format=excel"
The above expression is working.But if the parameter values contain "&" then i need to handle it in the url so i used the below expression.
=Globals!ReportServerUrl &"?" & Globals!ReportFolder & "/" & "ReportName" &
"¶m1=" & Replace(Parameters!param1.Value,"&","' + escape('&') + '") &
"¶m2=" &Replace(join(Parameters!param2.Value,","),"&","' + escape('&') + '") &
"&rs:Format=excel"
but it is not working and giving the below error.The path of the item ' ' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath).
How to handle the "&" in the expression?
View 2 Replies
View Related
Aug 1, 2007
@StartDate is a report parameter and CustomerNo is the field I want to render on the report,I want to combine the sql ,but it display the error message below when I preview the report.If I query in the design form and input the value of the parameter ,it run correctly .
---------------------------------------------
Data sql:
declare @sql nvarchar(4000)
declare @sqlWhere nvarchar(4000)
set @sql='select CustomerNo from table1 '
set @sqlWhere=''
if @StartDate<>''
begin
set @sqlWhere =@sqlWhere + ' StartDate=''' +@StartDate + ''''
end
if ltrim(rtrim(@sqlWhere))<>''
begin
set @sqlWhere =' where ' + @sqlWhere
end
set @sql=@sql+@sqlWhere
exec sp_executeSQL @sql
------------------------------------------
Error message:
[rsFieldReference] The Value expression for the textbox €˜CustomerNo€™ refers to the field €˜CustomerNo€™. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
View 5 Replies
View Related
Apr 24, 2015
Is it possible to format part of an expression?
I have an expression:
=(Fields!Intervention_Date_Of_Service.Value & vbcrlf & Fields!Intervention_Comment.Value & Fields!Intervention_ID.Value )
I would like my report to display Fields!Intervention_Date_Of_Service.Value underlined
i.e.,
"4/6/2015 12:45:00 PM"
Applied Data Script
ID 76584
View 2 Replies
View Related
Nov 22, 2015
I have a report with an expression to give a calculated field value (VoidDays)Â as follows:=DateDiff("d",Fields!Void_Start.Value, IIf(Fields!Void_End.Value is nothing, today, Fields!Void_End.Value))I have a number of different codes in the output such as VLOSS, VMAINT, VHOUS etc.When I run my report my days total for VLOSS is always correct but all other values are one day short. In the example shown in image below VMAINT should be 6 days and VHOUS should be 20 days which would then both add up to the VLOSS of 26 days
Â
I cant currently fix these days at source for a number of reasons hence I need to fix these on the report output.How can I add one day onto each of my Void Days Total for every code except VLOSS which is always correct.
View 11 Replies
View Related
Jun 22, 2015
I need returning a 0 from my lookup value versus it currently returning a blank space in my SSRS report.Â
=Lookup(Fields!InsuranceCarriersID.Value , Fields!InsuranceCarrierId.Value, Fields!TotalBalance.Value, "InsAgingSubReport")
View 3 Replies
View Related
Sep 30, 2015
I have a field called end date which can be empty to I have it coded to set todays date if empty using the following
=Iif (Fields!actual_discharge_ date. value Is Nothing, Today(), Fields!actual_discharge_date.value) which works fine.
The problem is I have to figure length of service which is coded as=
DateDiff("d", fields!approved_start_date.value, fields!actual_discharge_date.value)
Which works except when there is no actual discharge date. it will not see the current date that the first expression adds but still shows a huge negative value.
View 6 Replies
View Related
Jun 3, 2015
Is there a way of taking a result from a query and pulling out a certain account number and displaying those account numbers - as fred? Eg. I have a drop down of account number (s) however they pull from a table that only displays them as account numbers. I would like to give more a description to certain account numbers that are pulled. Eg. account number 234 will be fred and account number 555 will be sam etc. Trying to add it to the query on the dataset is complicated, so I was wondering if I created an additional blank field with an expression to be able to do this?Â
View 7 Replies
View Related
Jun 25, 2015
I would like to suppress the entire row in tablix if no data despite multiple expresions used in a text box.
If data the it will show per the DB data else it should not show anythig or leave it as blank row
The issue is where I have appended ";" and "'" in the expressions but still comes in the report output because it is appended even if no data.
View 19 Replies
View Related
