I have been asked to produce reports which will be triggered and generated automatically via scheduled tasks against data in SQL SERVER.
The reports will be generated as CSV's to provide compatibility with Excel.
The reports will then e-mailed as attatchments to an agreed list of recipients.
This all has to be done with the use of ASP and SQL Server.
Can anyone advise on how the prolem should be approached?
I am working on a system which requires data to be entered for candidates. It stores the whole data about the candidates in database(MS Accesss). The system will be used on client-side.Now what Iam required to do is generate reports as required by the user.but i have heard about reporting tools which can be used with ASP to generate reports.
The reports can be in Excel format or word format.Please suggest me which one should i use and how to use it?I am very naive to anything like this. Where can i find more info about it?
I want to generate HTML based reports with ASP. But the problem which i m having is to controll the Paging operation while printing the reports.
Unlike the Professional reports softwares as Crystal Reports and Also the Data Reports of visual basic (which are controlling the Paging automatically), a mannually generated HTML based reports need some logic to perform paging operation while printing.
As the subject of this topic suggestions I am trying to find a way to
use ASP, SQL Server, Com+ and Crystal Reports 8.5 to Create Dynamic PDF
Reports Over The Web, but the only article I found that decribes this
process is located on ASPToday.com which is no longer an active
website. When I try and suscribe to the site I just get a message
saying to email, and when I email I don't recieve a response. Code:
I want to create a webpage with asp. on that website, clients can get data from the
database with SQL.
I can already view the report in the crystal reports viewer on my asp page, but i want to
design the report at that time. is that possible? i have read something about RDC, but is there another way to do it. i don`t have VB experience and tolls to use RDC.
I am not an expert in ASP but i am trying to generate a page in which i am able to generate an ID for any one viewing that page or entering the data.
View Replies View RelatedI wanted to know that is there someway in ASP that I can generate images on-the-fly without using ne 3rd party component?? Like its possible in CGI-Perl to generate ne type of image on-the-fly, is there a way 2 that in ASP? OK, if the 3rd party components r the only way, then r there ne free ones available?
View Replies View RelatedDoes anyone know how to generate a variable NAME?
I’m thinking of something along the ground of:
<%
myvar=�hello�
(“stuff�&myvar) = request.form(myothervar)
%>
I need to generate some reports with graphical charts (line, pie, bar and polar). I want to generate those charts which represent database values. Hope I have to use a 3rd party control for this.
View Replies View RelatedIve got a table in an access database and I want to generate my own autonumber
based on the number of records in the table. Code:
I've been surfing the web and this forum for methods to upload images through a form in a browser. I've come up with a few results, e.g. Dundas free upload component.
Besides that I've got the free product from ServerObjects.com to check the ImageSize and found some other non-component method to check the Image dimensions at: LearnASP.com.
Users should be enabled to upload a thumb for their profile. Since I can't expect each user to be a computer literate they might upload an image which is a bit too big. Are their free methods with ASP to reduce those images in size? I'm simply using ASP here with IIS. For now I can only give them an error stating that their image is too big.
A second matter might be a photogallery where there's bigger images and thumbnails. Right now I'm using Irfanview/Ifranview to quickly make thumbs for each regular image. Like with the example above it would be ideal if this can be automized as well, since users should be enabled to put up some small photogallery as well.
I know there's some fancy expensive methods to achieve this, but usually they offer loads more and all I need is something to crop or resize (resizing is best).
I'm looking for a code or a component that will enable me to generate images on the fly, through my ASP code.
For example:
Retrieve some textual data from a database and make an image out of it.
OR
Combine text and an existing image into one new image.
OR
Read an HTML file that contains text and image and generate an image from it.
I've found programs that do it (like ABC Amber Text2Image Converter), but I fail to make it work through a code and not through a software console.
How can I generate screenshots (.jpg) from a .flv file using asp?
View Replies View RelatedI'm generating excel spreadsheets online with many manufacturers. One
particular manufacturer has 5000 more records than the next highest. When I
query for that manuf the table does not form. Just plain text. It doesn't
time out. Just doesn't form properly.
Is there a cache or setting I need to increase to get this much data?
Does anyone know of any freely usable code that helps automate the
process of generating RTF files from ASP (particularly generating the
code needed for tables)?
Basically I have a site where the administrator adds new students to a college system. This code just adds a new student to the database. When they are added a username is generated by taking the first letter of the forename and the first from the surname and joining them to the date.
(ie, James Brown would generate JB2005) Obviously some people will have the same initials so i'm trying to get all the records from the student table in my database that has the first two letters as the student I'm trying to add and adding the value of the count of that recordset before the date of the new students initials. (ie, if Jane Bennett was added the username would be JB12005 because there is already a user with the initials JB in the database)
At the moment if i add a new member to the database, the fields are populated but the count of the recordset is not added so I end up with duplicate usernames. I'm not sure if the recordset is even being filled or whether the recordcount is not working. Code:
im currently trying to generate a list of links to files held within my database.The file itself is a pdf
Im currently using this code :
Code:
response.write "<A HREF='" & RS("file") & "'>" & RS("linkname") & "</A>"
and its giving me the error:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/irtwebsite/welcome.asp, line 27
I have a question about generating reportDates upon import succeed of text files to Access. In the tables that needs to be imported daily has a field name called reportDate.
I have done in such a way that an ASP page will call the Import Macro from Access & execute it. There is no data for reportDate in the text files because I want it to be updated by the codes itself(auto-generate).
I adventured into Access, double-clicked on one of the tables & then View it in Design View. I entered Now()-1 in the Default Value caption. And then, I try my Import code & went back to check on my tables to see if data has been imported into or not. I also check my reportDate & realized that Access enters the date as 1 day before.
When the user creates a new page, rather than go through every other page in the site and add a new link to the left hand navigation I want to use an include file and search the folder for all .asp and .htm files and display them in the navi as a link. If that makes sense?
I've been playing around with FileSystemObject, but am struggling to get the desired results. Rather than display the full name of the file in the navi, I want to remove the file extension and the path, and maybe convert the leading letter to a capital so it looks like a regular nav.
I am using dreamweaver MX to connect to a microsoft database with the typical data stored such as name, address etc. I gt this information to displlay via recordsets and thats all good.
BUt im having trouble exporting the data from the database inot an XML document. I know I can do it on Acces itself but i want to be able to generate it using ASP. How do I do this?
I have a question on search engines.
My ASP page can currently just display selected table & selected field names prior to the selection of tables.
My ASP page has:
- 2 drop down list
- 2 submit button
Currently, both of my drop down lists can work.
1st DDL: Displays the table names
2nd DDL: Displays the respective field names prior to the selection of table from 1st DDL.
The scenario is like this; When User selects the tablename & clicks 1st submit button, the 2nd DDL will generate the field names. User selects the field name he/she wants to view from 2nd DDL & clicks the 2nd submit button.
I know its quite lame to do it this way but I'm still a novice in ASP. So hoping to get ideas from you people on how can I re-decorate my search engine into a useful tool for the User in the future.
how I can generate xl bar charts from ASP page. For example, just a click, take the input (recordset), put in a chart and open up/open a xl sheet, show the chart through excel application.
I tried with user defined class, but this isn't working with excel.
How do you go about generating a number based on the current date and time? I want to generate a number to be used as a confirmation number to an email. My site does
not connect to a database or anything just pure asp with an email form.
I would like to do is to generate statistics from my access db.
Within the db there are fields for each of the 11 plaers in the team each week, i.e. p1, p2, p3 ...... in each one will be a name, i.e Bill Bloggs but the name could appear in any one of the 11 fields.
What I would like to do is count the number of occurances of bill bloggs in the 11 fields and return it on my site as a table, i.e.;
name - times played
bill bloggs - 6
I have a project coming up soon where pdf files are stored in our oracle database. They want me to pull the pdf form out of the database and present it to the user on the screen. I've done a little searching on google, but haven't been able to find anything that helps. Can someone tell me if this is possible and if so, give a little example?
View Replies View RelatedOn our website, a user can order products from us. When they "submit" the
order, the website designer has written some ASP code to auto send an email
to our Exchagne 2000 server. Due to the contents of the email, we need to
secure it... How can we send a "secured" email from ASp script or would
this not be a function of ASp at all but the server the email is being sent
from? There must be something in the ASP code to indicate the email needs to
be secured?
I have an array of records, would like to put them into X no of tables depending on the number of records. The max X is 3. For eg, i have 15 records in the array
I would to have record 0,3,6,9,12,15 in table 1,record 1,4,7,10,13 in table 2, record 2,5,8,11,14 in table 3.
I tried to use 3 for loop, it did the job but is there a better way to do.?
Does anyone know if it is possible to write GIFs and JPEGs on-the-fly from within ASP?
I would like to be able to create an image with a graphical background and apply text over the top, saving the whole thing as single image.
I've seen various components out there written in Java and C++ but if it's possible to write it myself I'd like to give it a bash.
May I know how I can create a set of word documents using ASP? Is there any sample code available on the web for such document generation system?
View Replies View RelatedI'm facing a challange where I have some XML data in
either a flat file or an SQL database. I also have an XSD
file representing the structure of what used to be one-
many Excel sheets.
My task is to generate an Excel like sheet in as ASP.NET
webpage where users can edit the XML data stored in an SQL
database.
I'm using Visual Studio 2003 and C# to build this ASP.NET
application.
I know it's a long shot, but if anyone has experience in
building similar applications I would love to hear how you
have approached it.
Here's a quick query for any ASP/MS Office gurus out there!
When attempting to use the following code:
Set WordApp = CreateObject("word.application")
I get the following error message:
ActiveX component can't create object: 'word.application'
Could this be because MS Office is not installed on my server? Or is there another reason for this error message?
how to create a client side FTP script that will download a file from FTP server ?
Script should be temporary, and it is created and run when a user clicks on the link in the asp page... Location and name of the file are stored in SQL database on the Database server...
I'm setting up an ASP blog and part of my site's design involves setting off each entry's date in all caps (e.g. MONDAY, JULY 17, 2006). There isn't a way to type out each date manually so I want to know if there is a way to write out each blog's date in all caps using ASP.
View Replies View Related