.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Creation of report using MS Access

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
HI, I have created one report in SSRS 2008 ,in that i have a one link which will migrate to the new report,now i want to create this new report by using MS ACCESS Database ,will it be possible to do so.   Regards Amit

View Complete Post

More Related Resource Links

Access to report file denied. Another program may be using it.


Migrated from Windows 2000 ASP.NET 1.1 to Windows 2003, ASP.NET 2.0 and had this error. All the forums/MSDN/Blogs says to give Read/Write Access to C:\Windows\Temp folder. Why should we give Full Access to some folder in Production server?? In windows 2000, ASP.NET 2.0 development machine, no files are created when we run crystal reports from aspx pages. Then why in Windows 2003 servers, we need to give rights to temp folder?? It is a simple code


And the code is not storing anything on the disk. Then why should it store the GUID.rpt file in Temp file in Windows 2003 server?? Any alternative is there not to store anything on the disk when Crystal Reports are opened in aspx page??


[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

model report from two different data sources SQL server and access DB

Can we merge two model reports into one . One model report is from SQL server and another one from Access DB. How is that possible. Can you please give a idea how to do that. I need to display data from sql server as well as access DB using model report.  I need to get data from two different sources like sql and oracle or SQL and access db. So can combine tables from these data sources into the DSV or model. I need to use it in a report   Thanks Madhavi

SharePoint and SQL reporting services. Report of access?

Hello,Can a report be created with SharePoint and SQL reporting services that shows who has accessed the document and when?Thanks in advanceSebastian  

Displaying Image stored in rtf format in access database displaying it on crystal report

Hello, I'm working on a C# project combined with "Crystal Reports 10". When a user inserts something in a "TextField" in my C#-Program, it's saved  as RTF-code (Bolt,Pictures,Underlined,....) to a database.. So if they  reopen it in my "C#"-program they're able to see what they've entered  including their pictures .... But when I created a "Crystal Report"-file and combined it with the same  database used in my "C#"-program, it only show the formatted text and not  the pictures or images... Is there a way to show the "Picture" or "Image" they've inserted in RTF-code  ??? When I copy the code from the database in a simple Text-File and rename  it too "Test.rtf", it wil open correctly in word (with picture and  everything else)... So I hope there is a way to get the picture, Cz it's rather important  they've got a picture of the product they wanna print ...

SQL 2008 External access returns wrong address for Report Manager

Hello, I have problems with the external access for report server. My report server is running in a local server on port 80, which can be accessed through http://servername/reports I have set up external access to the report server through http://servername.domain.com:8081/reports , so I set up a redirection from public port 8081 to port 80 on the local server. When I write the address http://servername.domain.com:8081/reports in a browser, I get asked for user authentication(Windows domain user), which is accepted, but after that I get an error because the URL automatically changes to http://servername.domain.com/Reports/Pages/Folder.aspx (without the port 8081) If I write http://servername.domain.com:8081/Reports/Pages/Folder.aspx , it works. I can see the report manager home page and browse through my reports. But there are some links in the page that are built improperly, since they still point to the wrong URL (without port 8081). These are e.g. the Help link, the Report Builder link, the Details view link.  So I think there is something wrong with the response the report server sends, when I write ".../Reports" and returns ".../Reports/Pages/Folders.aspx" I haven't found any configuration file or property where this response is specified, neither where the report

Restrict folder access in Report Server

Hi There, I am creating folders each of our end users in Report Server, who upload their reports to their respective folder. I want to allow users to see and access only their folders and they should not be able to see others folders available on the Report Server, it is possible? If Yes, how do I do it? Thanks for your help. Regards, Suresh

Print a specific Access Report with selected GridView record

I have my code output a gridview with all the data with an option to select records. I'm trying to make a code which would allow me to select a record, and then print this record using a specific Report stored in MS Access. I've located the code to print the Report it self, but it prints ether all the records or a range. Any ideas? 

creation of Chart in report ssrs 2008

HI All, I have to create report based on the chart in ssrs 2008 in which i have to use different bar for different coulmn,Kindly suggest how to start the same.   Shraddha

Access Services report issue

Good afternoon. We have an issue where the canned reports in a Web Assets Database site throw the following error: Report viewer failed to set the report parameter defaults for this report. Select new default parameter values from the tool pane. The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) Actually all web databases (assets, projects, contacts) throw the same error for the canned reports however report services runs without issue on the server. The Web Assets database seems fine outside of the reports and when opened locally in access 2010 the reports run fine. We have one Sharepoint 2010 server with SQL 2008 r2 back end configured in sharepoint integration mode.  Thanks for any assistance you can offer. Cheers!   Cory  

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server


I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

Access Denied on Page Creation


I'm getting a weird little thing on one of my sub-sites that I am looking to see if anyone has insight into.  I have a parent site collection (1) that has a child sub-site (2).  The child sub-site then has it's own sub-site (3).  On 3 I have users that have full control.  This is the only site they have full control on.  When they use the site actions drop down to go to create page.  They get access denied.  If they go to View All Site Content and click on create they do not get the access denied error.

What I found is that if I go to the parent site 1 that you can only create pages from site actions if you are a site collection administrator.  These users do not need to be site administrators on the parent site.

Does anyone know if there is a setitng somewhere that needs to be changed?  I can't find anything.

Exporting access report to excel use SQL


I am new to access can anyone tell how to Export access report to excel use SQL or VBA

Thanks Ron



Report Access over HTTP and HTTPS


We have a strange issue with our sharepoint server in that when accessing the sharepoint site through http reports work, when accessing through https, reports dont work.  I am not a sharepoint expert by any means but have been tasked with fixing the problem.  here is what  I have observed:

Scenario 1

When accessing sharepoint via http://FQDN_of_Site I am taken to the login page to login.  Once authenticated, the client portal (non-secure, http) is displayed and I have the option to run several reports.  Clicking the report link displays the report as expected.

Scenario 2

When accessing sharepoint via https://FQDN_of_Site I an taken to the login page to login.  Once authenticated, the client portal (secure, https) is dispalyed and I have the option to run several reports.  Clicking the report link results in the following error:

The item 'https://FQDN_of_Site/Reports/Report_Name.rdl' cannot be found. (rsItemNotFound)

The server does have a vaild SSL cert.

There are three serveres being used.  One server for SQL, One Server for Sharepoint, One Server for Reports

As a recap:

http://FQDN_of_Site/Client_Name/ReportList.aspx works
https://FQDN_of_Site/Client_Name/ReportList.aspx does not work

Any hel

Trouble installing SSRS 2008 R2, XP Pro SP3, can't access Web Service or Report Manager URLs


I found a great thread by Uday titled "SQL 2008 Reporting Services Win XP SP2" and worked through it, but I am still stumped.

I am using port 8080 cause this was default.  I tried changeing to 80, but it didn't help, so changed back.  IIS is using port 80 and is currently stopped.

I see both databases in SQL Server and can query while logged in as Account that is used for the service account.  SSRS is running. 

URL reservations look good in the rsreportserver.config file.  In Native mode.

While in RS Config Manger I can test database connection and it is good.  When I click the webservice URL or the Report Manger URL in the Config Manager I get errors "Web site can not be found" and "Website can not display page"  I just upgraded to IE 8.  Can't figure out what to do next.

When I use httpcfg.exe I see a URL for http://+:8080/ReportServer/   and http://+:80/Reports/.  This could be the problem.  How can I chages seconfd to port 8080?

Any help would be appreciated.



Report Server Project DataSet creation problem


I am getting an error while trying to create a dataset in SSRS.


"An error occurred while loading the query designer 'OLEDB-MD'. Only text based query designer will be loaded."


The "Query Designer" command is getting disabled.


FYI: I was able to create successful connection while created the shared DataSource to the AS db, which I used to create my dataset.


Please guide me in getting through this error..


Thanks in advance


How to generate a report through access for sharepoint 2010


Hi to all,

           I am working on sharepoint 2010 ,My task is  how can generate the report  for sharepoint  2010 through access 2010 as we all knew that it is very easy to generate the report  in access  and access has  know web computability

             I created the list  containing   student information  and want to generate the report for the list i want to connect for access for the generation of reports which helps me to view information what i need.





Mohammad Siddiqali
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend