Setup Parameters for Multiple Variables in a String

[davismar]

I have 2 fields in my report with the following criteria in the "select expert"

{tvw_CustomAccountFieldData.CustomFieldLabel} in ["Date Site Survey Complete", "Digital Ports Available", "Phone Software Level", "Phone System Type", "VoiceMail Software Level", "Voicemail System Type"]

and
{tvwr_CustomCategories.CustomFieldCategoryName} in ["A - Remote Access Information", "Customer Site Survey Info"]

I need to be able to create parameters for each one of the CustomFieldLabel names above, and allow the user to select all of the CustomField Category Names that pertain to it.

For example - VoiceMail System Type (parameter)
user is able to select from the table all field names identified in either the "Remote Access Information" or "Customer Site Survey Info" category field name.

And, if the Remote Access Information field name is blank, then the report should return the result for the data from the Customer Site Survey Info field name.

Does anyone have any ideas?

 

[lbass]

This isn't clear. It sounds like one of these fields is a higher order category of the other. Please show how these fields would display if placed in the detail section so we can see how they relate to each other.

It is also unclear what you are trying to do with the parameter.

-LB

 

[davismar]

I have a group on tblAccounts.AccountName, which is placed in the detail section first. Next, the detail section shows the following:

Custom Field Label Custom Field Value

Report Footer has: tvwr_CustomCategories.CustomFieldCategoryName} where I have identified A - Remote Access Information", "Customer Site Survey Info"] as the 2 category field names within the table.

From there, here are the results:

Custom Field Label - I've identified only the following to pull from the table:
Date Site Survey Complete", "Digital Ports Available", "Phone Software Level", "Phone System Type", "VoiceMail Software Level", "Voicemail System Type"

The corresponding "value" for the above field names shows as follows:

A.D.Electric Date Site Survey Complete 8/29/2011
Digital Ports Available: 2
Phone Software Level: 7.32
Phone System Type: Aspire M
VoiceMail Software Level: 11.13
Voicemail System Type: NEC AspireMail

The parameter:

I want to create options for:
1. The Phone System Type (with a selection from the table)
2. The VoiceMail System Type (with a selection from the table)
However, I also need to show the other information on the report.

But sometimes, it will be necessary to find ALL Phone System types that result in "Aspire M", for example.

The other issue is that if someone doesn't fill in the VoiceMail System Type field in the A-Remote Access Information I eluded to above, I want the report to look for the value in the Customer Site Survey Info (i.e. Category Field Name)

Hope that helps clarify things.

 

[lbass]

Still not clear. Please show what two rows of data would look like in the detail section when you add both the label and the value to detail section. Please label each.

-LB

 

[davismar]

A.D.Electric

{tvw_CustomAccountFieldData.CustomFieldLabel} / {tvw_CustomAccountFieldData.CustomFieldValue}

CustomFieldLabel Custom Field Value

Phone System Type Aspire M
Voicemail System Type NEC AspireMail