How to setup MS Query?

Aspose.Cells Product Family
1

Hi,

Im trying to install Apose.Cells.ReportingServices V2. But the installation is getting cancelled asking for the setup MS Query. MS Query installed in my system.

How to resolve this?


Thanks and Regards

Mukesh kv

2

Hi Mukesh,

Thank you for considering Apose.Cells.ReportingServices .

Please ready to install disk.

Please click Excel Data->Import External Data->New Database query menu.

Popup installation MSQuery dialog.

3

Hi,

I was searching for something to enhance the Excel export feature of the Report designer of SSRS.
I have installed Aspose Cells for Reporting Services v1.2
Now what should I do to use it ? Am I wrong on this software’s purpose ?
I saw the “Please setup MS Query” message during installation but I don’t know what’s the point on this as I just export to Excel from Business Intelligence Development Studio’s Preview tab.
MS Query seems to be import related.

a+, =)
-=Clément=-

Microsoft Visual Studio 2005 SP1, Business Intelligence Development Studio 2005

4

hi Mukesh,

Aspose.Cells.ReportingServices.Client build dataset through MS Query.

If you only need export data from SSRS , you may ignore setup Ms Query or only setup services component.

If you need export data from VS2005 ,please manual modify config file.


1. Find RSPreviewPolicy.config and RSReportDesigner.config at vs2005 installation path (${InstallationPath}\Common7\IDE\PrivateAssemblies).
2. Open RSPreviewPolicy.config file and add CodeGroup info.




3. Open RSReportDesigner.config file and add extension info.



4. Copy aspose.cells.reportingservices.dll to ${InstallationPath}\Common7\IDE\PrivateAssemblies path.