Print Page | Close Window

Recall linked combos

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7919
Printed Date: 17 May 2024 at 12:08am


Topic: Recall linked combos
Posted By: Yamisquiff
Subject: Recall linked combos
Date Posted: 05 Oct 2009 at 1:55pm
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


Replies:
Posted By: lockwelle
Date Posted: 05 Oct 2009 at 2:31pm
how about a dynamic cascading parameter.  you seem to imply that the call type is related to the company, if so, select them in such a way that the relation is there and then create a dynamic parameter that allows the filtering based on the company.  You will be able to send either or both of the parameters to a stored proc or in the filter criteria.
 
HTH

Posted By: Yamisquiff
Date Posted: 06 Oct 2009 at 1:04am
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

Posted By: lockwelle
Date Posted: 06 Oct 2009 at 6:06am
how are you creating the reports?  it can be done via the IDE if using the CR product or through Visual Studios, it is just a style of parameter...what version of CR are you using?

Posted By: Yamisquiff
Date Posted: 06 Oct 2009 at 6:47am
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.

Posted By: lockwelle
Date Posted: 06 Oct 2009 at 1:56pm
I thought that 10 had cascading parameters, if not, I don't know off-hand how to accomplish it.  It's been a while since I had to use the CR parameter sheet.
 
Sorry I can be of more help.


Print Page | Close Window