Skip to Content
0
Former Member
Aug 21, 2007 at 09:52 PM

Dynamic Parameters

10 Views

Post Author: JewelCode

CA Forum: Data Connectivity and SQL

I am using SQL Views as my query sources via ODBC connection. I'm using Crystal XI R2 with a Sybase SQL Anywhere 9.0.1 DB.

I created dynamic parameters of Last Name and First Name as two separate dynamic parameters and they drill down appropriately.

To make it simpler for my clients, I thought I would create a field in my SQL view in the database that concatenates the two fields, so I created a new field in my view called SortName and it is LastName + FirstName.

I deleted out my independent parameters (which worked great, had me pick the last name and then the first name and then only pulled that report) and put in my single parameter for SortName.

When I go to view the report, it pulls up the SortName correctly in the Select Parameters box and I select a client from the list and it will only pull up a completely blank report.

So, if I use the Last Name and First Name independently, it works great, as soon as I use the concatenated SQL field, Crystal won't pull the data.

At first, I had put a comma between the last name and first name but I thought maybe the dynamic parameter feature in Crystal might not be handling the punctuation correctly, so I took it out and no difference, it just pulls up a blank report. Same data, just put into one field and for some reason Crystal doesn't like it. I don't know how Crystal would even know because the data is passed as one field in my View.

I can reproduce this with any fields independent and then concatenated.

Any ideas?