Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Recall linked combos Post Reply Post New Topic
Author Message
Yamisquiff
Newbie
Newbie


Joined: 23 Jun 2009
Location: United Kingdom
Online Status: Offline
Posts: 10
Quote Yamisquiff Replybullet Topic: Recall linked combos
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Yamisquiff
Newbie
Newbie


Joined: 23 Jun 2009
Location: United Kingdom
Online Status: Offline
Posts: 10
Quote Yamisquiff Replybullet 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


IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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?
IP IP Logged
Yamisquiff
Newbie
Newbie


Joined: 23 Jun 2009
Location: United Kingdom
Online Status: Offline
Posts: 10
Quote Yamisquiff Replybullet 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.


Edited by Yamisquiff - 06 Oct 2009 at 6:51am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.