SSRS Report Issue - argument length must be greater or equal to zero

(0) Share

Report

Posted on by dhawal

266

Hi All,

I have a SSRS report in production which is giving an issue "the sortexpression.value expression for the tablix contains an error: argument length must be greater or equal to zero ".

I have 7 expression in the report which are below : Please help to let me know if there is anything unusual in the below expressions which might be causing this issue. Will Appreciate if you give a solution to this issue. Thanks in advance

========
SNo
========
=RowNumber(nothing)

============
Ask Amount
============

=iif(IsNothing(Fields!hex_latestproposalamountValue.Value),Fields!budgetamountValue.Value,Fields!hex_latestproposalamountValue.Value)

============
Notes
============
=Switch(Fields!hex_donortype.Value = "Individual",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!ab_hex_date.Value & " - " & Fields!ab_hex_notes.Value, "ds_getKeyFollowUpOfContactFromOpp")(0),
Fields!hex_donortype.Value = "Corporate",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!af_hex_date.Value & " - " & Fields!af_hex_notes.Value, "ds_getKeyFollowUpOfAccountFromOpp")(0),
Fields!hex_donortype.value = "Foundation",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!af_hex_date.Value & " - " & Fields!af_hex_notes.Value, "ds_getKeyFollowUpOfAccountFromOpp")(0),
Fields!hex_donortype.value = "Government",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!af_hex_date.Value & " - " & Fields!af_hex_notes.Value, "ds_getKeyFollowUpOfAccountFromOpp")(0))

==============================
Date Proposal Started
==============================
=LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!pr_hex_proposaldate.Value,"ds_FirstProposalDate")(0)

=================
DMS Notes Date
=================

=Switch(Fields!hex_donortype.Value="individual",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!ab_hex_date.Value,"ds_getKeyFollowUpOfContactFromOpp")(0),Fields!hex_donortype.Value = "Corporate",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!af_hex_date.Value,"ds_getKeyFollowUpOfAccountFromOpp")(0),Fields!hex_donortype.value = "Foundation",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!af_hex_date.Value,"ds_getKeyFollowUpOfAccountFromOpp")(0),Fields!hex_donortype.value = "Government",LOOKUPSET(Fields!opportunityid.Value,Fields!opportunityid.Value,Fields!af_hex_date.Value,"ds_getKeyFollowUpOfAccountFromOpp")(0))

==============
Pipeline
==============

=Switch(Fields!hex_status.Value="Identification",Fields!hex_identificationcompletion.Value,Fields!hex_status.Value="Cultivation",Fields!hex_cultivationcompletion.Value,Fields!hex_status.Value="Solicitation",Fields!hex_solicitationcompletion.Value)

=============================
Pipeline sorting
=============================

=CInt(Left(Switch(Fields!hex_status.Value="Identification",Fields!hex_identificationcompletion.Value,Fields!hex_status.Value="Cultivation",Fields!hex_cultivationcompletion.Value,Fields!hex_status.Value="Solicitation",Fields!hex_solicitationcompletion.Value), len(Switch(Fields!hex_status.Value="Identification",Fields!hex_identificationcompletion.Value,Fields!hex_status.Value="Cultivation",Fields!hex_cultivationcompletion.Value,Fields!hex_status.Value="Solicitation",Fields!hex_solicitationcompletion.Value)) - 1))

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

dhawal 266 on at

Like (0)

Report

RE: SSRS Report Issue - argument length must be greater or equal to zero

Adding the Error Image

Was this reply helpful? Yes No
Suggested answer

Jarrod Williams 1,747 on at

Like (0)

Report

RE: SSRS Report Issue - argument length must be greater or equal to zero

Hi Dhawal,

Based on that error message I would say that you have a field that the Tablix is attempting to sort on. Find that field(s) and then make sure that it has a default value available to it, either in your script or on the field itself.

Was this reply helpful? Yes No
dhawal 266 on at

Like (0)

Report

RE: SSRS Report Issue - argument length must be greater or equal to zero

Hi Jarrod, Thanks for responding. I checked the Tablix 1 which was causing the issue. However, I couldn't find any sort expression in the Tablix 1 properties. I am still not able to figure out which field is giving issue. Attaching the screenshot for Tablix 1 Properties with no Sorting Expression. Also, additionally I also tried to remove the fields with expression one by one but still the problem/issue persists. Please help me if you have any other way to understand this.

Was this reply helpful? Yes No
dhawal 266 on at

Like (0)

Report

RE: SSRS Report Issue - argument length must be greater or equal to zero

I found that this particular statement is used in Sorting the Tablix :

=CInt(Left(Switch(Fields!hex_status.Value="Identification",Fields!hex_identificationcompletion.Value,Fields!hex_status.Value="Cultivation",Fields!hex_cultivationcompletion.Value,Fields!hex_status.Value="Solicitation",Fields!hex_solicitationcompletion.Value), len(Switch(Fields!hex_status.Value="Identification",Fields!hex_identificationcompletion.Value,Fields!hex_status.Value="Cultivation",Fields!hex_cultivationcompletion.Value,Fields!hex_status.Value="Solicitation",Fields!hex_solicitationcompletion.Value)) - 1))

Can you please help to let me know where can be the problem in this statement to fix the issue?

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

RE: SSRS Report Issue - argument length must be greater or equal to zero

It looks like the sortexpression is of the form left([field], len[field] - 1) - i.e. it is taking all but the last character. This will fail if the field is empty, so value will need to check that the field is not empty.

You should be able to make the expressions more readable by adding a calculated field to determine which field to use (hex_identificationcompletion or hex_cultivationcompletion), then another expression based on this value

Was this reply helpful? Yes No