| Author |
Topic |
|
Zoma
Yak Posting Veteran
76 Posts |
 Posted - 2008-09-22 : 09:11:57
|
| Hi AllI've been having this problem for quite few number of days now.Ive been designing this new report for our client,I have to add parameters or filters in these report so they can generate the data or values they looking.I have added parameters & its multi value paramater,But when u select some value lets say"Supervisor B and F,Than FiledWork G", It just brings all the data in the fields not the ones you wanted,Now im looking for that query or a filter expression that can bring that data. Or should i just use a filter,But wats worse is im not familar with Filters.Pease Help guys i just want to know if is there anything else i can do or an expression that u can use to manipulate that data you want.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-22 : 09:19:32
|
| How have you written backend query? is "Supervisor B and F,Than FiledWork G" single value or two values comma seperated? what's the reporting application you're using? |
 |
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-09-23 : 05:54:31
|
| Thanks for replying. Supervisor and field work,has their values which are seperated,it's like they differentiated as "Supervisor A,B,C,D Also the FieldWork where they work"A,B,C,D,E. So users want to have a drop down where they can select which Supervsr(maybeA,B,C) Than select which FieldWork they want to view for that Supervisor. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 06:07:07
|
quote:
Originally posted by Zoma
Thanks for replying. Supervisor and field work,has their values which are seperated,it's like they differentiated as "Supervisor A,B,C,D Also the FieldWork where they work"A,B,C,D,E. So users want to have a drop down where they can select which Supervsr(maybeA,B,C) Than select which FieldWork they want to view for that Supervisor.
then just add two filters and populate them with supervisor and fieldwork values in the report. |
|
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-09-23 : 09:02:40
|
| I did try adding a filter to use my parameter as an expression,But i just get an error and Im using Report Designer! If some one could please atleast get me a query where you can use it as an expression and selects those certain values u want the parameters to view. THANKS! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 09:08:27
|
quote:
Originally posted by Zoma
I did try adding a filter to use my parameter as an expression,But i just get an error and Im using Report Designer! If some one could please atleast get me a query where you can use it as an expression and selects those certain values u want the parameters to view. THANKS!
whats the error? |
|
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-09-23 : 09:23:01
|
| " An error occured during local report processing. An error has occured during report processing. Failed to evaluate the FilteExpression." |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 09:26:43
|
quote:
Originally posted by Zoma
" An error occured during local report processing. An error has occured during report processing. Failed to evaluate the FilteExpression."
this is because of problem in evaluating filter expression. what was filter used? |
|
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-09-23 : 09:49:08
|
| I added a filter on the Dataset. in the edit tab,then the expression is i selct the parameter i wanna use. |
|
|
|
|
Parameters or Filters