ReportViewer Extract DropDown

All,
I am using the ASP.Net ReportViewer control, but I cannot extract data
because the extract format type dropdown is not visible in the control. I
have the ShowExtractControls property set to True and I can see the Extract
link, but it is disabled
Is there something else I need to configure to allow the dropdown to populate?On Dec 19, 4:10 pm, Rex Mahel <Rex Ma...@.discussions.microsoft.com>
wrote:
> All,
> I am using the ASP.Net ReportViewer control, but I cannot extract data
> because the extract format type dropdown is not visible in the control. I
> have the ShowExtractControls property set to True and I can see the Extract
> link, but it is disabled
> Is there something else I need to configure to allow the dropdown to populate?
This link might be helpful.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1968399&SiteID=1
Also, you might try checking: C:\Program Files\Microsoft SQL Server
\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config (...
\MSSQL.2\... could be ...\MSSQL.3\... based on if you have SSIS/SSAS
installed). Of course, this would be a long shot. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Looked through the link, checked the cache issue, "Do not save exrypted pages
to disk" was unchecked, checked C:\Windows\Temp security properties and
granted full control to SQLServer2005ReportingServicesWebServiceUser user.
Nothing had any effect.
Any other ideas?
"EMartinez" wrote:
> On Dec 19, 4:10 pm, Rex Mahel <Rex Ma...@.discussions.microsoft.com>
> wrote:
> > All,
> >
> > I am using the ASP.Net ReportViewer control, but I cannot extract data
> > because the extract format type dropdown is not visible in the control. I
> > have the ShowExtractControls property set to True and I can see the Extract
> > link, but it is disabled
> >
> > Is there something else I need to configure to allow the dropdown to populate?
>
> This link might be helpful.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1968399&SiteID=1
> Also, you might try checking: C:\Program Files\Microsoft SQL Server
> \MSSQL.2\Reporting Services\ReportServer\rsreportserver.config (...
> \MSSQL.2\... could be ...\MSSQL.3\... based on if you have SSIS/SSAS
> installed). Of course, this would be a long shot. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Reports Parameters

I use the Reports Servers Design to Design My report, but I need to use multi value fot Report Parameters, But Don.t to do.

Mulit Parameters (Type = 'A' , 'B')

A Value are '1' , '2'

B Value are '3' , '4'

I use SQL Script to Run

Select * From XXX

Where A IN (@.Type)

@.Type may be 1,2,3,4 or 1,2 or 3,4

How to slove

Thanks

this one must work for you:

select the parameter from the Report Parameters menu check the multi-value and then select the radio button non-queried, this should have you a list box with two columns, list all the possible values and labels for what do you want to be visible in the control. Then you can also set the default value you want to in the panel below it.|||

hi BLueDeViL

The Values could store 2 Values like value=1, 2 lable=A

thanks

william

|||

William,

I got your point, and if that's so..i think it is not yet possible. And even the logic of having 2 values for a single label..even the compiler will be confused.

Because take a look at the scenario, what if the user selects 'A' in the multivalue control? Do you think there is a logical way of determining the value, if they both have the same label? The label acts as the index, and that index is only referring to a one dimensional array! If the reporting services shall have a multi dimensional array, where in your case should include 2 values in a single index..this shall be done accordingly.

Hope you got my point. As of now I don't know if that is already possible, but as far as I know it is not yet implemented!

Thanks and more power,

Mark Guerra