Crystal Report Parem Question

[Gizmo0917]

I am creating a report that I would like to use a LName,FName Combo as a Parameter. However in the original table it has the LName and FName as separate fields. So when I try to import the information into the Param Field it is impossible to import the info as a name field combined. I have created a formula that combines the first and last name but then when I use it there are no values to choose from. How can I get the values to fill in as LName,FName combo for my Param?

Thanks! Giz

 

[lbass]

For help creating a picklist, look at my post in thread149-39169. For the picklist report, use a formula like:

{table.LastName}+", "+{table.FirstName}

This assumes that you will enter some sort of instructions to the user indicating the need for a comma and space after Last Name.

-LB

 

[Gizmo0917]

Ok I built a new table with just the fields I wanted in it and combined the LName, FName via a combo exported this to a txt file and cleaned it up and imported it into the other report where I needed the Name Combo Field. I Made a Parm field of it and the people now show but when I pick a name from the pick list to report on no information pulls up into my report. Why?

Thanks!~The rest of this worked great. Please let me know how to associate it to the report that I am working on. It is a report that was already here when I came but I need a picklist that actully shows the names of the people instead of their log on id which is what the db admin has as their unique key (it is alpha)He also has this in the picklist set up as a param as well. It would just be easier to do the report for me if I can see the name of the person.

 

[Gizmo0917]

I don't think that he has the tables related correctly in SQL. this time I went in and used the two tables that he uses in the original report. I added the PracID from PatBill Table and then the LName, FName Fields from the Prac Table. Nothing comes up in my report but the headings. If I use the PracId, LName,FName fields from the Prac Table I see the names of everyone I need. He has these two tables joined on PracID from PatBill table and PracId from Prac table. The PracID is a alphalog in name that he has used as a primary key for these reports. All I am allowed to do is copy the report and then redo them and save them under a new name as my own. But how can I get these to work? Please Help!!

 

[lbass]

I guess in your situation I would create the picklist with the ID in the left column and the name formula in a second column. If you import this, the ID will populate the value field, and the name will populate the description field. Then in your record select use:

{?ID} = {Prac.PracID}

Otherwise, if you were going to use your original picklist with the name as the parameter, you would have to create a formula {@Name} exactly like you did when creating the picklist and then use that in the record select:

{?Name} = {@Name}

With respect to your tables, do you see an equal join? Do you expect that there is a record in the PatBill table for every record in the Prac table? Please provide a little more information. Also, what is the datatype for the {Prac.PracID} field? I don't know what you mean by "alphalog in name."

You might also try going to database->verify database.

-LB

 

[Gizmo0917]

Well I went back to the report and in the field that he (the dba) created as the ID field I imported the names into the description part of the field and this works! What I mean by an alpha log in for instance, is when we log into our system in the morning to get onto the Network. It is an alpha log in like your first initial and lastname. The dba here has used this as our primary key in the tables. He really should have used an employee ID numeric number instead. Those numbers don't change and aren't duplicated. Then the people would only be in the database once whether their name changed or not. Plus he hasn't related the primary key to other tables that we need to get information out of. It would just be easier to get the information from the database if it was set up properly. Thanks again for your help! I really really appreciate it!