| Author |
Topic |
|
Dev@nlkss
134 Posts |
 Posted - 2008-12-30 : 04:20:07
|
| Hi All,In my report i have 5 inputs(parameters)first 4 for Geographical Areas(Zone,Region,Area and SmallArea) and 1 for status(boolean).From the areas I can select All or some of them to view the details in that selected areas.But my problem is when i start selecting 'zone' continously its asking for selecting Region-->Area-->SmallArea.Bcoz I am loading Regions based on Selected Zone.this is OK when i want to view the details of last area(i.e smallarea) But some times i may require to view only upto selected Area level(Zone Or Zone-->Region etc..) Can anybody tell me how is it possible in sql reporting services. Thanks in advance.Satya |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 04:25:18
|
| just make the parameters Region,Area and SmallArea of nullable typeby selecting Allow Null Value option and make the default values of them as nul. Then in query behind do the filteration on them only if they have a not null value. |
 |
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-30 : 04:34:47
|
| No Visakh I am doing same thing now.is there any other solution.have u got my problem.Satya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 04:45:09
|
quote:
Originally posted by satya@imi
No Visakh I am doing same thing now.is there any other solution.have u got my problem.Satya
another solution will be to included a hardcoded value like No Selection as default for all and include it among the parameter values as well. so that when you select zone, the other parameters will have No Selection as value.In query behind you do filtering only if value is other than No Selection. |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-30 : 05:24:07
|
| (just make the parameters Region,Area and SmallArea of nullable typeby selecting Allow Null Value option and make the default values of them as nul. Then in query behind do the filteration on them only if they have a not null value.)Visakh what u told is working for textboxes but i am loading in to dropdown list.Satya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 05:32:23
|
quote:
Originally posted by satya@imi
(just make the parameters Region,Area and SmallArea of nullable typeby selecting Allow Null Value option and make the default values of them as nul. Then in query behind do the filteration on them only if they have a not null value.)Visakh what u told is working for textboxes but i am loading in to dropdown list.Satya
what i told was to include no selection option in code for populating the dropdowns. |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-30 : 05:38:56
|
| That is ok but instead of making it as hardcoded.how can i do it which u told by making as null as default value.Satya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 05:40:39
|
quote:
Originally posted by satya@imi
That is ok but instead of making it as hardcoded.how can i do it which u told by making as null as default value.Satya
that you need to do it in parameters tab set default value as null and also include null as a value among parameter values list |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-30 : 06:16:31
|
| Visakh I need some more help from you.In my query i included null as intial value following original values.working fine for first dropdown. but when i select some value from first dropdown in second dropdown values are loading but they are getting replace by null i.e all values of dropdown are showing as null values. so that further dropdowns are not loading its original values.please solve my problem.Visakh am i clear.Satya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 06:19:33
|
| that means its problem with query you wrote for populating second dropdown values. are you passing first parameter value in query to get associated second param values? |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-30 : 23:28:11
|
| Visakh do we have Text and Value properties for dropdown in sql server reporting services like in .net.why bcoz i have to diplay Area name in dropdown and have to send AreaID for Query input.Currently i am displaying like "AreaName--ID" and splitting ID value in query is this right way..Or else can i do in some other way if so plz tell me its urgentThank youSatya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 03:15:07
|
yup. you can write query as followsSELECT AreaName AS Display,ID AS ValueFROm YourTable... then use above query as source for dataset which populates area combo. then in parameter properties use from query option and select dataset. then give label as display field and value as value field. then it will show areanames in combo but will pass ID corresponding to it upon selection to db. |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-31 : 05:01:00
|
| Thanks Visakh Its workingU saved my timeThanks againSatya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 05:02:37
|
Welcome  |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2009-01-02 : 08:46:00
|
| Hi Visakh,Can you tell me the details about MS cirtification exams for SQL developer.-->What are the pepers it contains.-->Which books are best or any free online material links-->Which is the best book for SQL Server Reporting ServicesThankQSatya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-02 : 09:03:26
|
quote:
Originally posted by satya@imi
Hi Visakh,Can you tell me the details about MS cirtification exams for SQL developer.-->What are the pepers it contains.-->Which books are best or any free online material links-->Which is the best book for SQL Server Reporting ServicesThankQSatya
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx |
|
|
|
|
SQL Server Reporting Services