How To Display MS Access Reports In A Webpage

Jan 21, 2011

I am working with a client who wants to make his current MS Access 2007 Reports available on demand in his web site. Currently, as I understand it, the managers of the company are being required to actually load MS Access and the active database to run the reports which exposes all of the data and linked tables to people who have no reason to modify them. So my client just wants them to be able to log into the admin section of the company website and request a report which he has already built in Access. I am trying to figure out how to get those reports to an ASP.NET application for the website to consume.

I have already spent a day looking at the Microsoft.Office.Interop library, and I don't think that that will cut it because I can actually get the HTML for the Report directly out of the application. All I can find is an option to save it to the hard disk which is inelegant and could easily cause problems with filename changes when I try to then load the document from ASP.

What I would like to see is a solution by which I can load the mdb or accdb file into the ASP application, access the Reports as a container and select the one I want by name, and then run it and collect the output in HTML to then simply echo to the webpage. Is there anything out there that can:

// Psuedo-code
Dim AccessFile As MSAccessFileOperator
Dim Reports As List(Of MSAccess.Reports)
Dim htmlResult As String
AccessFile = New MSAccessFileOperator("myDatabase.accdb")
Reports = AccessFile.Reports
htmlResult = Reports("MyReportName").toHTML

I haven't found such a method yet, and I am okay with the idea that maybe it isn't possible to do it that easily, but, at the end of the day, I need the HTML result of the Report to exist in memory as a String.

View 5 Replies


Similar Messages:

How To Use Same Crystal Reports Viewer To Display Reports Depending On An Option Selected

Dec 3, 2010

I have two reports but i want to use the same crystal report viewer to display both reports depending on an option selected. How can I achieve this?

CrystalReportViewer.setCrystalReportSource(CrystalReportSource3) or something like this i am just not sure about the code in c#

View 1 Replies

Crystal Reports :: Export / Print From Toolbar Just Displays Reportviewer Webpage Again

Jun 10, 2010

I'm having issues using the Print/Export functions from the CrystalReportViewer toolbar in Visual Studio 2005. In some cases, the print/export dialog window is simply replaced with the report page, instead of exporting/printing the data. Based on a dropdown box, the Report Document is loaded with a different report file:

If ddReport.SelectedValue = "Report-1" Then rptDoc1.Load(Server.MapPath("/Reports/Report1.rpt"))Else rptDoc1.Load(Server.MapPath("/Reports/Report2.rpt"))End If

View 1 Replies

SQL Reporting :: Printing .rdl Reports Using The ReportViewer Control From Webpage To Users Client

Oct 19, 2010

I have developed a set of ssrs .rdl reports and am trying to display them from the reportviewer control embeded in my asp web page. The problem is that when I select the print icon on the reportviewer control I am prompted to install ms sql server. What is the best way to print .rdl reports from the web page's embeded reportviewer control to the client's local network printer.

View 2 Replies

Not Able To Access Webpage / Not Connecting To DB?

Oct 6, 2010

I've a problem with my web application. I hosted a web site in IIS and initially its working good. After sometime ( i dont know the time diff exactly ), if i try to access my page its not working and after re-starting my application only its working. Let me explain about my project.

I've only 4 pages ( ex: main, a1,b1,c1 ) in my site. In main page i used IFrame to show other 3 pages by clicking the appropriate tab. Before this main page load, i'm connecting to DB (Oracle 10g) and i used "System.Data.OracleClient" class to communicate with oracle. Every time after retrieved data from DB i'll close the connection. Then i'll display the main page and assign other page url's to the tab.

Now the problem is after sometime if i access the main page, its not connecting to DB at all then i'll show some static message like "site is unavailable at this time". And i'm not using connection pooling concept. And also this problem is not occurring all time.

View 3 Replies

Access :: Query In MS Access. Display Output Table In Visual Studio 2008?

Mar 25, 2010

Can a query output made in MS ACCESS be accessed as a database in Visual Studio 2008?

I have a Parent and Child Table in MS Access with a one-to-many relationship. I created a query in Access that would produce a result table and I want the contents of this Query to be displayed in a Data Grid in Visual Studio 2008.

View 11 Replies

Access :: Random Order Display In Datalist And Gridview From Access Database

Jul 8, 2010

I have to display data (names) in a random order on the website. The data is stored in a MS Access database. The names must be displayed in a GridView and DataList in different places. I have created a query in MS Access "zorder: Rnd([MarinaAccommodation]![ID])" which works fine in MS Access giving me a different order each time.

The problem is that when I try run it on the website the order remains the same, it does not change each time the page is loaded.

View 4 Replies

Web Config - Local Access Only For Webpage?

Jul 22, 2010

Is it possible to configure web.config to authorize a page to be only read locally (similar in concept to the RemoteOnly feature for error messages).

View 1 Replies

C# - Access Webpage From .ashx WebHandler?

Jan 20, 2011

Is it possible, and if so how do you access the webpage from the webhandlers?

Basically, when i button is clicked i kick off some JavaScript, which then kicks off a C# webhandler which return data from the server. What i would like to do then is rather than feed it back to the JavaScript, id like to add a GridView directly to the webpage from the webhandler.

Equally, within the handler it would be incredible useful to be able to read values of dropdowns etc from the webpage.

View 1 Replies

Access :: Sum Rows And Return To Webpage?

Nov 30, 2010

I have an Access db on webserver. In my ASP webpage I need to return the sum of rows which match criteria.

I am not sure where the sum needs to happen. I tried sum in the sql statement, but got an error when it tried to put it in asp page.this is what I have

strSQL = "Select * from tblApplicantCreditors where ApplicantID = '" & strApplicantID & "'"

View 6 Replies

Denying Direct Access To A Webpage?

Mar 11, 2010

I have a webpage errors.aspx that needs to be protected from direct access. I want it to be accessed only when redirected to by another web page.

View 3 Replies

Publishing Access Database Reports To The Web

Mar 2, 2010

Client has a bunch of Access databases and associated reports.

He wants to make the reports available (live, not snapshots) via a secure extranet.

He's willing to recreate the reports using a proprietary GUI if necessary, but ideally would like a solution that exports his reports "as is" to the web.

Had a look at Caspio Bridge. It's pretty slick but doesn't appear to offer grouping and summing (key requirement) without a nasty Javascript hack - seems like a rather glaring omission to me!

I'm an ASP.NET developer so if there's coding involved, an ASP.NET based solution would be preferred.

View 4 Replies

C# - How To Access Webpage Hierarchy Inside A Application

Mar 8, 2010

Trying to figure out how to programmatically access the web pages in the application. Just something simple like a list of them would be awesome. I know I can create a list but I was wondering if there was something that could 'look' at the pages and add a new one to the list if you make a new page for the application.

Example with 7 pages:

Error
Default
Login
Content
Users
ContactUs
Admin

I am half awake so I may be a little unclear. Maybe puting it all in a single question will be easier.

How do you autogenerate a list of all webpages in your current application?

View 1 Replies

How To Stick User To Use Specific PC To Access Webpage

Jul 2, 2010

I'm building a website that just allow each person in my office to access the page from their own PC placed at the office only. It looks like I need to identify a client from within the codes on the ASP.net web server. How can I do this?

View 2 Replies

Configuration :: Access The Webpage Without The Port Number?

Sep 27, 2010

on my vistual studio 2010 I can see my project by [URL]

but I can access my project on either localhost or Ip address without the port number , how can I access the web page without the port number?

View 9 Replies

Access :: Filter Data On Webpage In Database?

Jul 21, 2010

I am wanting to build a asp.net page where the user is presented with drop down boxes.

The drop down boxes contain information from an access database.

The access database contains more than 5 tables.

For example, I am going to use a customer website database as an example:

Contained in the database is:

Server Name

Server Type (Shared web or Dedicated)

Customer name

Sites the customer has.

Funtionality:

Say user one wanted to view all records by the server name:

The user would select the relevent server name which is in a drop down box.

This will automatically filter the database results and in turn will display on the webpage all the customer sites associated with that 'server'

Next I want the user to be able to filter those results again, and say the user wanted to filter the sites by "server type", the user would then select the type in another drop down box and then the data will be refreshed to show the sites that are on that sever, and server type.

View 2 Replies

Unable To Access Published Webpage From Other Computers?

Jan 18, 2010

I have published ASP.NET web site, using IIS7 on Win7. I can access this web site on my localhost, but it is inaccessable from other computers via internet. I have tried to disable firewall and anti-virus program, but with no success.

Does anyone know what may be causing this problem?

It works fine if I publish it on winXP.

View 4 Replies

Access :: Update Database Via A Textbox On Webpage?

Oct 22, 2010

i am trying to update my database via a textbox on my web page.

so that when a number is entered into this textbox and the button is clicked, it goes and changes the previous value to the one u have just entered.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Try
' cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsAshMyDocumentsplatypus_holidays.mdb;") 'Connection String
cn.Open()
str = "update holidays set holidays_left=" & CInt(TextBox3.Text)
cmd = New OleDbCommand(str, cn)
icount = cmd.ExecuteNonQuery
TextBox4.Text = "The value was change to " & icount
Catch
TextBox4.Text = "The value was not Updated"
End Try
update_holiday_values()
cn.Close()
End Sub

View 1 Replies

Web Forms :: Can't Access A Webpage Published To A Server

Mar 10, 2010

I published my website with Visual Studio and used FTP to transfer the Default.aspx page in the root folder and the compiled file (Default.aspx.cdcab7d2.compiled) in the bin folder of an SQL server that supports ASP.NET (StartLogic). But, when I used a browser (Firefox) to access the Default.aspx web page, all that I got back was: This is a marker file generated by the precompilation tool, and should not be deleted!

What am I doing wrong? Why can't I get the page to be displayed properly?

View 4 Replies

MVC :: Program Cannot Display The Webpage?

Nov 29, 2010

I'm attempting to deploy my new MVC 2 app to a windows server 2003 box (IIS6). The app is on it's own web site, scripts and executable rights given, asp.net version set at 4.0.30319. ASP.NET MVC was installed via the web platform installer and server was since rebooted.

I've used this technique in the global.asax to put ".aspx" in the URLs:

[Code]....

No matter what i do I still get an error on Browse: "This Program cannot display the webpage." Times out in Firefox. This is constant if i do wildcard or .mvc mapping, suggesting it is an IIS problem.

Nothing in the event viewer that displays any info or any error.

Is there anything extra special that needs to be done to get IIS to recognize MVC?

View 12 Replies

How To Display Some Text On Webpage

Mar 21, 2011

to display some text on webpage what do we use? eval? or <%=function%> and when do we use eval.

View 1 Replies

Display The PDF Document In Webpage?

Mar 13, 2010

how can i add a sticky notes in my asp.net webpages.... i have a requirement where i need to display the PDF document in my webpage ... and i need to add the sticky notes to that pdf document... can any one guide me .... about how to start to achieve this....

View 5 Replies

How To Display A Webpage Every One Hour

Jan 1, 2013

I am developing an intranet web application. i am using asp.net,C# and MS sql. Now i want to make everyone hour to bring a grid view page with lists of names whose contractperiod is expiring soon. So how do I make an asp.net page to be pop up every hour.

View 2 Replies

Crystal Reports :: Access Data In VS 2008?

Jan 3, 2011

I have some background in writing reports for Win32 programs using VS 2008. I now have to write a report (which will actually be a billing statement) in ASP.Net. The data for the report will be on an MSSQL server either 2005 or 2010. My question is what is the best way to access that data. I assume there are different methods for doing this. My experience is pretty much confined to ADO net, but I am open to anything that may be better

View 1 Replies

SQL Reporting :: Public Access To SSRS Reports?

Sep 21, 2010

I'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved