passing automatic filters in ASPdb

[Steve Davis]

I'm building reports with drill down capability and am having difficulty in figuring out how to set the ASPdb filter mode On by default with my filter criteria.

My Scenerio is:

report_level1 - is a "grouped by" report, the user can click on a hyperlink to drill-down too the second level, ie this level contains categories called, "FRUIT", "VEGITABLE", "MEAT" etc..

report_level2 - this report will show all records that belong to the above category as specified in the previous level, I want to do this by automatically setting the ASPdb filter to match the category above.

Implementing this way would then let the user clear the filter, and choose to filter on another category or all categories without having to go back to level 1.

How do you pass and set the filter on, via the querystring?

[Frank]

Steve,
If I understand your question which is how to drill down with a different filter criteria or another words a different SQL query which has nothing to dowitht he ASPDB filtering. If this is true then, the way to accompish that is to activate another file with the new query after the drill down from the first one. You can also combine the two into one file by have two ASPDB sessions within the same file.

Frank


On 12/23/98 10:15:16 PM, Steve Davis wrote:
> I'm building reports with drill down capability and am having
> difficulty in figuring out how to set the ASPdb filter mode On by default
> with my filter criteria.

My Scenerio is:

report_level1 - is a
> "grouped by" report, the user can click on a hyperlink to
> drill-down too the second level, ie this level contains categories called,
> "FRUIT", "VEGITABLE", "MEAT" etc..

report_level2
> - this report will show all records that belong to the above category as
> specified in the previous level, I want to do this by automatically setting
> the ASPdb filter to match the category above.

Implementing this way
> would then let the user clear the filter, and choose to filter on another
> category or all categories without having to go back to level 1.

How do
> you pass and set the filter on, via the querystring?

[Francois Le Palec]

Hi,

I know what you mean... I try to figure out during several hours how to
include my own criteria to the ASPDB filter... and here it is the solution :

Build your own form like that :

<FORM NAME=FRFORM_1 ACTION=&#34;demo.asp&#34; METHOD=post>
<INPUT NAME=&#34;Manufacturer&#34; TYPE=Text SIZE=25>
<INPUT TYPE=HIDDEN NAME=aspDBClick_1 VALUE=applyfilter>
<INPUT TYPE=submit NAME=aspDBFilterBut_1 VALUE=Filter>
</FORM>

It is important to have in this form :
1) a POST method for your form,
2) the same value for the aspDBFilterBut_1 and the ASPDB variable dbFilterParams = &#34;ApplyButtonText=xxx&#34; (see below),
3) and the number extension equal to dbunit.


And the 2 tricks : add in your ASP which implements ASPDB these lines :

Session(&#34;SV_Filter_1&#34=&#34;&#34;

MyDb.dbFilterParams = &#34;ApplyButtonText=filter&#34;

That&#39;s all !

Actually, the reason is that ASPDB needs to create the Filter Session variable
before it gets your criteria. In a normal way, it does it when you click on
the Filter button. But if you wanna emulate the ASPDB filter form, you need to insert this line in your code.

CU
Francois Le Palec
Teknika - Paris, France (<= sorry for my english...)


On 12/23/98 10:15:16 PM, Steve Davis wrote:
> I&#39;m building reports with drill down capability and am having
> difficulty in figuring out how to set the ASPdb filter mode On by default
> with my filter criteria.

My Scenerio is:

report_level1 - is a
> &#34;grouped by&#34; report, the user can click on a hyperlink to
> drill-down too the second level, ie this level contains categories called,
> &#34;FRUIT&#34;, &#34;VEGITABLE&#34;, &#34;MEAT&#34; etc..

report_level2
> - this report will show all records that belong to the above category as
> specified in the previous level, I want to do this by automatically setting
> the ASPdb filter to match the category above.

Implementing this way
> would then let the user clear the filter, and choose to filter on another
> category or all categories without having to go back to level 1.

How do
> you pass and set the filter on, via the querystring?