asked on

How to import an excel file into a parameter

I have an excel spreadsheet with 2 columns of data
I would like to import this information into a parament box, so that the user can select from the list
How can this be achieved without having to enter each line?
Gordon

Mike McCracken

I assume you added the Excel file as a data source for the report
What version of Crystal?

mlmcc

Gordon Hughes

ASKER

Hi Mike
Have not added it as a table in the data base as i am creating the report for a client.
The version is crystal reports XI

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gordon Hughes

ASKER

Hi mimcc
Good to hear from you
How do i add it as a data source and then how do i import it
I guess i do not have to do the same on the client’s database
Gordon

Gordon Hughes

ASKER

Hi Mimcc
Ok i have added the table to my database
When i edit the parameter if i select the table and the fields i can see the data if i select the down arrow but it is not populating the columns
So if i run the report i cannot see the list!!
Help please
Gordon

Gordon Hughes

ASKER

Hi
Am also trying to allow a filter for the assigned to

the formula is
if {WO.ASSIGNEDTO} ='ALL' then 1 else
if {WO.ASSIGNEDTO}<> {WO.ASSIGNEDTO}then 0 else 1

And I have set the select to = 1.00
But I think the formula is missing something as it is not working
Gordon

Gordon Hughes

ASKER

Hi mimcc
I have added the bale from the excel spreadsheet and appended the data to the parameter
Just need to correct the selection formula
Am I then able to remove the table i created?
Gordon

Gordon Hughes

ASKER

Meant I have added the data

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial