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 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 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.
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.
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 thought id post it and see what more experienced people think. With firefox now the browser of choice with people in the know their lack of VBScript support is causing me problems. If i want to say validate my forms i must now do it on the server-side (which is probably safer anyways). But things like pop-up warnings ??? or if i want to perform _OnLoad, _OnClick, _OnChange events , what do i do ?? or more to the point what are my options if any. What is the general opinion on using VBScript with ASP pages.
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.
The code for ShadowUploader works great for me when I have it on a page by itself. My problem arises when I try to add other buttons. The “Upload” button still works but the other buttons act like just another “Upload” button. What am I overlooking?
<% Option Explicit Response.Expires = -1000' Make browser not cache pg. Response.Buffer = True' Buffer content so Response.Redirect will work. %> <!-- #include file="~incl/ShadowUploader.asp" --> <!--#include file="~incl/~config.asp"--> <!--#include file="~incl/jpsutility.asp"--> <!--#include file="~incl/menu.asp"--> <!--#include file="~incl/misc.asp"-->
I have an ASP variable which is a certain number. I want to create a Select tag in a form, which will be populated up to this number. So, for example, if my number was 7, you would have a list of numbers between 0 and 7 to select.I'm not sure how to do loops, but I had an idea that the code would look something like this: Code:
<select name="select2" id="select">
<% for i=0 to i=varNumber Response.Write ("<option value='"& i &"'>"& i &"</option>") rsBooking.MoveNext %>
I was asked to incorporate colour options for items sold in my shopping cart such as pens.So if I am selling a pen that comes in 4 or 5 or more colours, then I have to create the number of types of collours for the pen. I am looking at creating a colour dropdowns for individual items , but I am not sure how I can do this in backend.I am using Access database and using ASP programming. This is the link which is an example of what I mentioned http://www.27905398.com/product_inf...9a4aed0a18fb81d .appreciate if anyone familliar with this function
My Current project requires the use of ASP.I've been able to pick it up fairly quickly, but I'm curious to know if there is a function similar to the php mssql_num_rows(). This simply returns the number of rows returns with your specified query. So far my search through this forum hasn't returned anything of the like.The closest I have seen would be to execute another sql statement to count the result first. Which seems to be alot of double work.
We are viewing the same page on my server in New York. I submit or send something in to an ASP, and it returns to me an updated page. How do I get it to reload showing changes for you in Florida who is just sitting watching the page not touching anything?
I have a frames page setup. When I send in info, I have this code to show changes for me by an automatic reload. it works for me:
where I can get a full list of ADO options for opening a recordset? I'm currently using adOpenForwardOnly but I want my recordset to be able to move backwards to the start of a recordset and several other functions.
i am using frontpage ,ASP, and some javascript. how do you create a START-> ALL PROGRAMS selection option. you place the mouse over the "all programs" and you got all selection related to "all programs"
i want to do the same thing with data from a database. how do i do this?
I am trying to help out my friend by creating a invoicing page in ASP for his business, basically consisting of 3 pages : (no sensitive info will be asked for.. )
1.info submission page -cust enters his info 2.info summary -cust info summarised plus quote calculated 3.invoice page -quote emailed for invoicing.
At present I have made the initial set up and it works fine. However, I am using CDONTS 1.2 to email the gathered cookies with the following code:
I have created a few web site apps that use e-commerce technologies using ASP and XML. These are typical sites, with shipping, tax, blah blah. Usually it's standard shipping and is just related to the weight of the entire order.
Now, I've been asked to add several shipping options (i.e. Overnight, One-Day, Standard). My question...I did some searching around first but without luck...are the sites that offer multiple shipping options tied in with another company such as UPS? Or is it just more data that I can deal with on my own?
I have 10 athletes i will be testing and displaying their information
so there will be two split screens the bottom screen where the user enters the data and the top screen where the data will be sorted to show the ranking of the athletes Code:
The default drop-down value is populated by a value already selected using Recordset.
The problem is on the Edit page, the user should have the ability to change the drop-down value, but because the default value is one that has previosuly been selected, it appears twice in the list.
Because I already have an "If, Else" statement to disable some fields, it is causing confusion when I try to enter further If/Else statements to narrow down the drop-down list. Code:
function Add() { // alter the action and submit the form document.topicform.action = location.href + "1" ; document.topicform.submit(); }
function Delete() { // alter the action and submit the form document.topicform.action = "deleteformbutton.asp"; document.topicform.submit(); }
As you can see I'm not really sure how I should go about processing the actual form. Each time the user decides to add another form button I want it to keep the value of the old button. Anyone got any ideas?