Hi Guys,

I am currently scratching my head,

I have two set of parameter values that are used for report selection.

The first parameter value selects the company

The second parameter value selects the call type

how can I get the call type list to filter depending on what company is selected instead of having a full list of call types as we have over 200 of them and it becomes a little tedious.

Any ideas on this one.

Could I use the SQL expression field in order to achieve this.

Many thanks for anyone looking at this post.

Warren

Hi Thanks for the reply lockwelle,

Sadly I do not have access to crystal reports enterprise and am writing stand alone reports. I dont think that this is actaully possible. I have looked into creating cascading parameter fields but they all seem to refer to doing this using business objects which I currently do not have.

Many thanks for the suggestion though.

Warren

Hi there,

I am currently using Crystal reports 10, I do have access to 11 also from my other office remotley. But ideally would prefer to do the report in 10 as I am using the reports via a viewer that is built into our service desk software which is about 5 years old.

Many thanks,

Warren

What I am trying to achieve is a link between two Parameter fields so that when the report is ran though a viewer the first paramter that is set is the customer and then the next is a filtered list showing items that a relivant to that customer only not a list of all items for all customers.

e.g.

Company A, -IBM Server -IBM PC - IBM InfoPrint
Company B, -FSC Server, FSC PC - Lexmark Printer

instead of

Company A, -IBM Server -IBM PC - IBM InfoPrint, FSC Server, FSC PC - Lexmark Printer

Company B, -IBM Server -IBM PC - IBM InfoPrint, FSC Server, FSC PC - Lexmark Printer

So in a way the second parameter needs to filter out items which are not relivant to that speicifc company.


Edited by Yamisquiff - 06 Oct 2009 at 6:51am