Access DB

I am trying to connect to an access database using Reportin Services 2000.
I can develop the reports just fine on my local computer, and I can get to
the file from the server. However, when I try to connect I get a path not
found error. I tried to connect with no username password and using admin,
but again I get an invalid path. So I tried to set up a DSN. It worked
just fine, but when I reference the ODBC drivers and the DSN I get no ISAM
drivers installed and path errors as well. I am logged into the machine as
admin and have full rights.
Any suggestions?
John WrightNevermind I found the problem.
John
"John Wright" <riley_wright@.notmail.com> wrote in message
news:%23pccxDtbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>I am trying to connect to an access database using Reportin Services 2000.
>I can develop the reports just fine on my local computer, and I can get to
>the file from the server. However, when I try to connect I get a path not
>found error. I tried to connect with no username password and using admin,
>but again I get an invalid path. So I tried to set up a DSN. It worked
>just fine, but when I reference the ODBC drivers and the DSN I get no ISAM
>drivers installed and path errors as well. I am logged into the machine as
>admin and have full rights.
> Any suggestions?
> John Wright
>

Access .Rdl from Asp.net webforms

Hi,

I am new to Sqlserver reporting.I have created few reports using vs2005 busineess intelligence projects and report designer-wizards.

I want to add/access those reports from webforms?is it possible?or do i need to deploy reports over report server.If i run the server i am able to see the report.

If i want to access from .aspx page what do i need to do?I tried adding existing item,.rdl but i do see only .xml part of .rdl .

Can anyone help me on this.

Thanks,

kar1978

Use ReportViewer control

It can be used with

// Set the processing mode for the ReportViewer to Remote

reportViewer.ProcessingMode =ProcessingMode.Remote;

or

reportViewer.ProcessingMode =ProcessingMode.Local

Accesing Reports from outside the domain

How do I set it up so that people who are inside my local network, but
outside my domain to get access to my reports.
Any thoughts would be great
JeffCan't you just add the individuals to the security of the report...
e.g. DOMAIN1\User
I have reports with 3 or 4 different domain users having access.
Craig
"JeffreyWowk" <JeffreyWowk@.discussions.microsoft.com> wrote in message
news:78D313D8-0C25-4BB9-8AB5-A4BB3E4438DE@.microsoft.com...
> How do I set it up so that people who are inside my local network, but
> outside my domain to get access to my reports.
> Any thoughts would be great
> Jeff

accesing cube from java

Hi,
I am new to Analysis services.
i need to generate the reports using the data in cubes by java..
can any one tell me how to access the data in cube using java...
is there any article for this....

Thanx in advance..
Ashok

Hi,

I am also new olap cubes and analysis services,

Please tell me if u got any idea about accessing olap cubes from java.

Hopfully Thank you.
Santhakumar S|||

Hi,

A possible way would be XMLA.

Here you can find the details:

http://www.xmla.org

Christian

accesing cube from java

Hi,
I am new to Analysis services.
i need to generate the reports using the data in cubes by java..
can any one tell me how to access the data in cube using java...
is there any article for this....

Thanx in advance..
AshokHi,

I am also new olap cubes and analysis services,

Please tell me if u got any idea about accessing olap cubes from java.

Hopfully Thank you.
Santhakumar S
|||

Hi,

A possible way would be XMLA.

Here you can find the details:

http://www.xmla.org

Christian

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Accelerating first call of Reports

Hi,
is there a possibility to accelerate the first call of a report?
It could take up to 1 minute on my Server. After I called a report the first
time, its going faster (~5 seconds).
Thanks and regards,
StefanThis is due to IIS, not Report Server specifically.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan" <stefan@.nospam.nospam> wrote in message
news:eIt4iTroHHA.1476@.TK2MSFTNGP03.phx.gbl...
> Hi,
> is there a possibility to accelerate the first call of a report?
> It could take up to 1 minute on my Server. After I called a report the
> first time, its going faster (~5 seconds).
> Thanks and regards,
> Stefan
>|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Bruce, hi Wei Lu,
thanks for your support.
Can you please give me an example, how to call a dummy report from a
batch-File.
Thanks and regards,
Stefan
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:eZ%23UFCsoHHA.4516@.TK2MSFTNGP05.phx.gbl...
> This is due to IIS, not Report Server specifically.
> Go to IIS Manager, under Applocation Pools node, right click
> "DefaultAppPool" in which the Reporting Server work process is running,
> select properties. On "Performace" tag, you will see, by default, the app
> pool will shut down if > being idle for 20 min. You can extend this time
> to 8x60min 480min, so that the app pool will not shut down for a regular
> working day. However, the first report reader of the day, will hit the
> delay. You may schedule a dummy report at beginning of a work day for
> this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stefan" <stefan@.nospam.nospam> wrote in message
> news:eIt4iTroHHA.1476@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> is there a possibility to accelerate the first call of a report?
>> It could take up to 1 minute on my Server. After I called a report the
>> first time, its going faster (~5 seconds).
>> Thanks and regards,
>> Stefan
>|||Hello Stefan,
I did not have a sample yet. I would like to suggest you create a
application to use the web services to call the reports.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
I run the following script in planned tasks and now everything runs fine.
Thanks,
Stefan
Option Explicit
Dim objIEA
Set objIEA = CreateObject("InternetExplorer.Application")
objIEA.Navigate
"http://localhost/reportserver?%2fReports2fMyDummyReport&rs:Command=Render"
objIEA.visible = true
While objIEA.Busy
Wend
objIEA.Quit
Set objIEA = Nothing
"Stefan" <stefan@.nospam.nospam> schrieb im Newsbeitrag
news:O%23d1KDopHHA.4632@.TK2MSFTNGP04.phx.gbl...
> Hi Bruce, hi Wei Lu,
> thanks for your support.
> Can you please give me an example, how to call a dummy report from a
> batch-File.
> Thanks and regards,
> Stefan
>
>

About the visual of SQL Server Reporting Services

Hi,

I would like to know if it is possible to change the appearance of SQL Server Reporting Services that we see when we are navigating in the reports by the browser. Like change the name "SQL Server Reporting Services" to the name of my company, change the default icon and the size of it, etc...

Thanks for the attention,

Gus

yes, navigate to your report manager and there is a section called site settings.