I am looking for a way to create reports using ASP pages or some third party component. I am taking a look at crystal enterprise 8, but I am not sure about the licencing etc. I have used this to create a web report, but the 5 user licence seems to restrict you for just having 5 explorer windows open.
I.e. it doesn't seem to be 5 concurrent users and to have more would get very expensive. Has anyone done any reporting with ASP pages? Ideally, using barcharts, pie charts etc.etc.
I have recently developed a web application across my clients intranet. We used ASP with Interdev 6.0 and SQL server as the backend.
They have now come to me asking me to develop some reports that can be accessed via a drill down within the app. They don't have Crystal Reports so this is not an option. Can anyone suggest an alternative to using crystal reports to publish dynamic reports via the web and ASP?
I need suggestions to allow my users the ability to print reports from my ASP application that will be quick and easy setup. I need them to choose an option such as
Print all checks for the current week
and receive an output of 1 page per employee . Currently I have the page so someone can view 1 employee on the screen and manually print. But I am looking for some web based report delivery method that will be quick to implement so the user can preview the batch of reports and then print. Similiar to if you were running a report in access.
I have a need to develop a reporting application that has static and parameterized reports that I want my users to be able to access and retrieve through a web interface.
I'm trying to find out the standard/preferred way of displaying reports. My original thought process pointed me towards generating xml files for the static reports and having standard xsl files to display them.
How should I build the form-submitted report requests using asp? Should I generate xml from asp and have standard xsls for displaying them? Or should I iterate through the result recordsets and just build html with response.write?
Essentially I'm just looking for a high level summary of how ASP reporting applications should be developed, and I feel confident that I could go from there.
Can i make us of the sql reporting services in asp? If so then how do i make a call since what i know is that sql reporting services are available as web services?
is there a way to turn on error messages from the server without having access to the server? When I get an error on my webserver all I get is a page that says "HTTP 500 - Internal Server Error" without giving me any details about the snafu.
Has anyone constructed a SOAP request with Classic ASP and sent it to SQL Server Reporting Services to render a report formatted as PDF to a browser and dealt with the SOAP response?
I'm not talking about URL access, but accessing the SSRS web service directly with SOAP passing credentials, parameters, format, etc. There seems to be nothing out there for ASP 3.0 - it's ALL .NET.
i am working on a project and client just decided to use SQL Reporting Services 2000 for reporting but his application is developed in Classic ASP and SQL Server 2000.
how to view parametrized report in classic asp page and i want these paramters to be sent by URL not in report manually.
I am using ASP and I need the ability to make several dozen reports. I get the feeling that trying to produce somewhat attractive-looking reports in HTML and ASP code would not only be hair-splitting, but quite possibly could be impossible as well.
Does anyone know of any software/tool/package that would be compatible with ASP and allow me to retrieve reports from data that is stored in a database and called in the ASP page?
I am building a ASP financial reporting application. Here the user inputs quarterly financial information. The data obtained is being used for uploading a separate in-house application. The end-user should be in a postion to run reports on their own based on the quarterly information they furnish via the web applciation.
My question here is what is the best way to devleop reports in the asp applications so that users can view their own report online? Somebody suggested pure html reports. However, I believe there should be better ones which would be web based.
I'm having an issue with my Web application. It's deployed using Crystal Reports 8.0 Developer edition.
I have an RPT file with a relatively large number of formulas (30+). I did not create this RPT file and I loathe to change it as I am not very well versed in the field. I also did not create the ASP to generate reports, but inherited it too, so I am really speaking from what I have gathered at looking at the code.
The Report designer wanted a switch to determine if they should show a certain field as an average or a total. Instead of making this switch a parameter as I was expecting them to, they made it a formula, which stumped me for an hour or so. As the product shipped, this formula is set equal to false, which means the user always generates this field in Averages. If the formula is set to true then the field will be set to Totals.
Now the problem has arisen that there are a large number of formulas in the Report, and when you use Crystal 8.0 with ASP you must reference the formulas by their index number as opposed to by the formula name or id. I have no idea what this formula number would be. Code:
I am trying to setup an error reporting system for our Intranet. We have a Windows 2000 Server with SQL Server and we have an Exchange Server 5.5. I need to set it up so I can use CDO mail. I have used CDO before, but have never set it up to work. I built a small little page with some CDO code on it, but I get an error when I try to run it. How can I set this up to send mail from the webserver to people in our facility?
Reading te article about sql injections and sanitizing I found that one of great recommendations is to "Configure error reporting" to do not allow public to read the entire sql statement. How can I do this? Can I do this if I keep my websites on hosting company server?
Any one know if there is any way in asp to create a way to report information on any unclosed recordset instances or unclosed database connections etc...?
I'm looking fo a solution to generate automaticaly a PDF file.
My aim is to use a template define by a user and to insert dynamicly datas form SQL server in this document.
Can you tell me if it exist PDF template like .dot for word ? If such file exist is it possible to generate list of information like aacount report with datas coming for Database like Sql server.
I have a problem with running multiple sql statements using asp. Basically if there is an error with any of the statements inside the query a rollback is done. the sql and rollback work fine, But on the actual asp page no error is detected unless it occurs in the first statement in the query. heres an example
<% Sql= " BEGIN TRAN INSERT INTO Users VALUES ('BLAH', 'BLAH') INSERT INTO TESTING VALUES ('SOMETHING','SOMETHING') IF @@error <> 0 ROLLBACK TRAN ELSE COMMIT TRAN " If Err <> 0 Then
Response.Write "error"
Else Response.Write "<p>Data has been added!<p>" End If
%> in that example if theres an error inserting into Testing the page will display 'Data has been added' even though it hasnt.
Using IIS 5.0 and sometime some asp pages (absolutely randomly) showing as blank white pages. So far only one way of fixing it - restart whole server. Restarting IIS, or specific web server not helping, only whole server.
I enable server side and client side debugging, but no errors showing up...
In view source pages always look like this: ----------------------- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=windows-1251"></HEAD> <BODY></BODY></HTML> -----------------------
What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code?
is it possible to create pages using other pages. Here is an example... Can I make a page that has a menu on it, but the menu is actually a seperate page that I call with ASP?
We run a website with pages that are created using ASP. The website is used by different people from different networks. For some people, the pages are stuck. It looks like the were able to open the page, but it is not displayed on their browser. We think that it might be something to do with their proxy. Does anybody know how to solve this problem?
I had a 404 page set up in IIS 5.0 that would the the URL of the requested page from the query string. i recently upgraded to IIS 6.0 but it doesn't seem to put the requested URL in the query string as it did in IIS 5.0 and 3.0. Does anyone know how i can get the requested url property in IIS 6?
I have a bout 5 different pages of which each will contain a form requiring users to complete. These forms are all related as one project. It is necessary that if the user was to only complete the first form they could theoretically quit, come back later (time not dependant) and complete the remaining pages. Therefore I think the best way to do this is to write the values to the database upon each click of the next button. The only other issue with this is that the user will also be receiving a pdf file at the end of the full form submission with all their information inserted into this pdf and finalized. Now. I am aware of pdflib in which I need php but my choice was to do this in asp. What are my options here? Should I combine them, should I draw all the info from the db at the very end with php and then create the pdf, should I use sessions during the entire process
When asp.net pages are made in vs.net, loading on the local host displays the labels all in the top left corner of the screen. Also, all textboxes and image buttons are not even displayed at all. If pages are made on a remote server, they load perfetly fine, it is just the local host displaying them incorrectly. Is this a common problem?? I have iis 5.0 installed with windows 2000. i use the full version of vs.net to make asp.net pages.
I have a web site I've recently moved to a new provider.It has worked for years.On the new provider's servers ( Win2k Server .NET 1.1 ) my asp 3.0 pages often don't completely execute. Here is what happens: Most of the page starts displaying in the browser, then you see some HTML, then nothing. If you refresh a few times, the page finally completely loads. There is never an error reported during any of this.
I have installed IIS 5 on Windows 2000 Server and have applied all the neccessary updates and patches. I am unable to run any ASP pages on the local server. I am able to view the HTML pages though. I have checked everything but cannot seem to figure it out. I end up getting HTTP 500 for all the web pages.
I am trying to setup a demo server for an asp.net web site that is working on my real website. The demo is Win2K and I have installed .net framework and IIS, both successfully,I think. The problem is that when I try to access the demo site, the pages are not being served correctly - only lables are displayed, and not as configured. HTML pages display correclty. I tried to run aspnet_regiss, but get an unkown function error.
i can make a database, add entries to database, delete from database, but the only thing i want is "How to divide entries in Pages" like we can see in the guest-book etc Scripts. This is an Example: Quote:
Entries: 500 Pages: 1|2|3|4|5
how to divide the entries in pages, like 10 entries per page..?
I've got a site that's been up and running for a couple of years.I've added some new stuff and it looks fine on my computer. However other people are seeing the old stuff.
I've tried a manual refresh of both my browser and theirs but nothing, the URL's are identical . This is a real problem as i'm away for a month as of Friday and the site is needed for a project.
Our website is in html format. I want to change it to asp. I have already created my index page and have it on the server as index.asp. When I load the website it brings it up with no problem. On this index page I have links to all the pages on the website which are basically articles of varying lengths.
I want to use the query string (i.e. page.asp?pageid= or authorid=) ect. to load that article. Do I need to develop a database to store these articles in? If so can I include the formating code in the database field for the article itself. My fields in the database (ms access) would have for example article_id, author_id, article_txt, ect. How much can I place in a particular field (txt wise)?
I understand that the information passed in the query string after the ? searches the database for a match. Once it finds a match how do I display the article and have my formatting included, ect.? I hope this makes some sense.
We have moved a web site from a development server running Windows 2000 and IIS 5 to a Windows 2003 server running IIS 6.0 Now the asp pages do not work correctly. For example, request.form() no longer returns data from the calling form.
I have turned web services extensions on to allow active server pages. The pages do work to some extent, I can even setup a connection to a database and retrieve stored procedure parameters, but some elements do not work. What else do I have to do to make an IIS 6.0 server run asp from a previous version of IIS?
