Is there any way to show or hide the Document Map dynamically depend on parameters?

hi, all
I have a class report with class no as paramter.
This parameter could be null. So, if users enter null, it will show all
of them for all classes. Otherwise, it will only show the data for that
class.
So, what I am thinking about is, if the parameter is null, report shows
all data, it will be very nice to show the Document Map on the left
side. If users entered class no, then there is only one class in this
report, no use to show or use the Document map, right?
Does anyone know how to do that?One idea is to call your report through a URL and pass rc=DocMap=true or
false
Med bouchenafa
"Nick" <nick_1394@.yahoo.com.cn> a écrit dans le message de news:
1137522580.946890.33140@.f14g2000cwb.googlegroups.com...
> hi, all
> I have a class report with class no as paramter.
> This parameter could be null. So, if users enter null, it will show all
> of them for all classes. Otherwise, it will only show the data for that
> class.
> So, what I am thinking about is, if the parameter is null, report shows
> all data, it will be very nice to show the Document Map on the left
> side. If users entered class no, then there is only one class in this
> report, no use to show or use the Document map, right?
> Does anyone know how to do that?
>

Is there any way to show or hide the Document Map dynamically depend on parameters?

hi, all
I have a class report with class no as paramter.
This parameter could be null. So, if users enter null, it will show all of them for all classes. Otherwise, it will only show the data for that class.
So, what I am thinking about is, if the parameter is null, report shows all data, it will be very nice to show the Document Map on the left side. If users entered class no, then there is only one class in this report, no use to show or use the Document map, right?
Does anyone know how to do that?

If you are using the ReportViewer controls that shipped with VS 2005, you can read the values of the parameters from ReportViewer.ServerReport.GetParameters (or LocalReport depending on the mode you are using) and set ReportViewer.DocumentMapCollapsed programmatically.

If you are using url access to the server, you could use rc:DocMap=false to hide the document map, but this would require you knowing the value of the parameter beforehand, so it wouldn't work with the built-in parameter prompting.

Is there any database midware like asp script?

Is there any 'database midware' liked asp script? The following code is 'database midware' class in java, is there any code/script for asp3 (not asp.net) in jscript/vbscript ?
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.util.List;

public class ASPD {
public ASPD() {
}

private Connection connection;
private Statement stmt;
private ResultSet rs;

public void connect(String connectionString) {
//TODO
}

public void disconnect() {
//TODO
}

public void query(String sql) {
//TODO
}

public int update(String sql) {
//TODO
return 0;
}

public boolean execute() {
//TODO
return false;
}

public void preparedQuery(String sql, List parameters) {
//TODO
}

public int preparedUpdate(String sql, List parameters) {
//TODO
return 0;
}

public boolean preparedExecute(String sql, List parameters) {
//TODO
return false;
}
}//EOF
Any help is thankful.If you are talking about classes that support data access, you might want to look at Active X Data Objects that come bundled in MDAC.|||There are tons of example scripts available, look for example here (http://www.aspwebpro.com/tutorials/asp/dbconnectionopen.asp)

Hope this helps.