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 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?
What is the best option for report in classical asp.
View Replies View RelatedI 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.
i want to use crystal reports in asp application
how to do it
and can anybody tell me resources on this
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.
View Replies View RelatedI 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 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?
View Replies View RelatedAny 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...?
View Replies View RelatedI'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.
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?
I have just moved an ASP Classic website to a new hosting company that has a
number of .NET components available. The website works fine after the move
with one exception. We were creating PDFs using ASPPDF for ASP but now it
looks like only ABCPDF.NET is available.
My knowledge of ASP.NET is very limited at this time and I am planning on
converting the site to ASP.NET soon but I really need to get the PDF working
as soon as I can.
I am trying to add a Visual InterDev project to Visual Source Safe 6d.
Normally I just go up under Project | Source Control | Add to Source Control
and I can load the project to VSS but now when I try to add the project to
VSS I get the error:
"Cannot establish source control for the Web Application. The server does
not have a source control system installed on it, or the user name is not
recognized."
I am on a workstation which has VSS installed. VSS is also installed on the
web server istself. I atttached to the VSS database as "admin" and under
my own user name but I continue to get the same error.
What could be wrong? Perthaps I am using the wrong version of VSS. Is
version 6d compataible with Visual InterDev? Or do I need an earlier
version?
I am developing on WXP SP1 with VS.Net 2003 and VS6 installed. I cannot get
my localhost webserver to render any classic ASP pages. ASP.Net and standard
HTML works.
If I request an ASP page from localhost the browser hangs for several
minutes before just doing nothing. The status bar says the website is found
but nothing is ever downloaded.
I have verified the mappings in the IIS manager and I have re-registered the
ASP.DLL. I am now at a complete loss.
The following code works on IIS 5.0 on a Windows 2000 server.
Response.Clear Response.ContentType = "application/rtf" Response.AddHeader
"content-disposition", "inline;filename=letter.rtf" response.write l_strBuffer
But on IIS 6.0 running on Windows 2003 server we get an error.
"Internet Explorer cannot download <file name>.
Interner Explorer was not able to open this Internet site. The site is
either unavailable or cannot be found. Please try again later."
After increasing the AspBufferLimit attribute in the metabase.xml, we were able to resolve the issue.
Is there any other way to resolve this without modifying the metabase.xml?
Can you develop Classic ASP pages using VS.net?
View Replies View RelatedI want to rename the file which i just uploaded it on the server.I want the code that do this.
View Replies View RelatedI'm migrating a classic ASP site from IIS 6 to IIS 7 and I'm finding some minor problems that I'm assuming are IIS 7 config related. The problem I'm concerned with right now is that when I run the asp pages, they have lost all their image and CSS links. Functionality is fine (that is I can query the DB, update records, etc) but all graphic features have been lost. how to solve this issue?
View Replies View RelatedDoes anyone know for sure whether classic ASP (ASP3 ?) will run on Longhorn?
View Replies View RelatedI've been working in .NET for some time now and I don't remember specifically
how asp classes are cleaned up in classic asp. I've been put on a Classic
ASP project(ugh) and we're having some serious stability problems. Once we
reach a point of sustained CPU useage of over 80% IIS 6 restarts the w3wp.exe
process which of course terminates all sessions and resets the website.
I've
noticed that the previous developer has an include which creates a couple of
class objects in ASP. Not third party or "CreateObject" objects, but ASP
classes. This include is in A LOT of files and the classes not being
destroyed in any of them.
My question is could this be the problem? I seem to remember a problem with
ASP classes and not destroying them causing leaks of some sort. I need to
mention that the memory doesn't seem to be leaking but the CPU utilization
goes wacko as if ASP/IIS is corrupt. My environment is Windows 2k3 and IIS
6. The previous environment was Windows 2K and IIS5. Both environments had
the problem.
Before I go through these hundreds of files I was wondering if anyone
remember what the problem was with ASP classes not being destroyed.
I am using ASP, and I would like to read the country of origin from the HTTP header information of my visitors. I would use this to geotarget different ads to visitors from outside the US.
For other reasons, I don't want to use a solution like GeoIP - I want to do it through ASP code if possible. Has anybody had any experience with this?
I have a system written in classic asp and a lot of Javascript. Due to
its performance and security issue, we decided to re-write this big
module. I heard that C/C++ has a better support in performance and
security (relatively) but here comes my questions:
1. Can ASP talk to C/C++? Because from my experience I use C/C++
mainly for application console.
2. If I want to exclude most of the Javascript and use other
programming language instead, can ASP.NET do it? Is there any
compatibility issue between Classic ASP/ASP.NET/Javascript?
Does anybody out there consume a web service using classic ASP?If anyone has any useful resources for doing this, I'd love to see them. I haven't found much online at all. Long story but I'd rather not have to learn .net or switch to php for this one project
View Replies View RelatedI'm maintaining an ASP Classic file that has HTML withing
Response.Write methods such as
<%
Response.Write "<table><tr><td>"
Response.Write testVariable
Response.Write "</td></tr></table>"
%>
Would their be a performance hit if I were to write this instead?
<table><tr><td><%=testVariable%></td></tr></table>
I need some confirmation.
What do y'all see for the future of ASP in light of MS decision to replace
FrontPage with a new series of development tools? All of them mention ASP.NET,
but no mention of the ASP I love. Code: