Multiple Page Report
i was wondering how to go about making a multiple page reports. i am really clue less.
View Repliesi was wondering how to go about making a multiple page reports. i am really clue less.
View RepliesI want my asp report to to be printed with page breaks. How do I do that ?
View Replies View RelatedHow can I get the the 1st group header to print at the top of each page on my report. More or less I want to use it as the page header but it contains data from SQL. The page header section does not allow you to place data fields in it.
View Replies View RelatedI have a form submit that must report back to the same page an error if a pair of radio buttons inside the form block are not checked. But data from the buttons must still be sent to another page.
I tried having the form send data back to the same page, then putting the data in session variables and redirecting to the page they have to go to. But apparently the session variables are having unpredictable effects on the very complex page I'm sending the data too.
I'm thinking about using Onsubmit = somefunction inside of the <form > . I've tried javascript but I haven't found the right code yet, and also I'd rather avoid the popup alert box, it is inconsistent with the rest of the website. Perhaps an ASP subprocedure could do the trick?
can the adobe FDF toolkit be used to dynamically create a several page report using data from a recordset in ASP? As far as i can see now, it is only useful for filling in form fields from user submitted data.
Another option we are exploring is using the activePDF tools to do this. Has anyone had any experience with these tools? any comments/opinions? Can it do what we asked above?
I have created a database request page (wahooo - new to asp and it works)
and everything is great. Now I'm creating a second page and want to know if
I'm able to make two different queries on one page. I want to be able to
create one query that uses a Request.QueryString from a URL and then use one
of the returned values from that query to create another query on the same
page. I hope that make sense. Here is the database connection code:
If you are going to be making multiple calls to the same database from a single page, should you connect/close, connect/close, connect/close....or just connect once at the beginning of the page and close at the end?
View Replies View Relatedi'm thinking about making a muti page survey and was looking for some input on the best way to go about it. example
i want 3 questions on the first page, the user answers then hits next the next questions load and so on. what would be the best way of programming this?
i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.
if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?
Im basically making a site that will have a homepage with links I will add everyday to graphics and movies on my server. When you click the link it will open a new page similiar to the homepage with the graphic/movie in the middle of hte page.
I know there's an easy way to do this so i can just have it call a database or something like that. Basically I want to just have to add a link to the home page describing what it is, then and add the link to the file to the database and have the coding do everything for me. I think this is asp.
Can someone clue me in. All the sites i've built up until now have hundreds of pages all consisting of the same thing and it's such a pain to keep duplicating code. I'm not looking to get too advanced. If I don't have to use an access database, i don't want to.
I've been building an ASP app that sits on top of a relational database (MS Access). The problem is that the data from some web forms need to be stored in different tables. Currently I am using multiple SQL Insert statements.
The problem with this approach is that it is possible that several inserts would succeed and then one would fail. This would ruin my database. Is there some way to synchronize the Insert commands or to "flush" the commands at the same time? I need the Insert statements to either all succeed or all fail.
I currently have designed a web page and inserted some ASP modules into it. But, if I insert more than one ASP module I receive an "Internal Server Error". If I delete the second ASP module the page works perfectly. So, my questions is this. Can you only insert one ASP module per web page? Where is the problem. Code:
View Replies View RelatedI m trying to use multiple option menu using redirect function in ASP.
I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:
We have a master page set up and it is tied to its css file through the standard method in the <head> tag. What I would like to do though is from another page inheriting the master page to add another link to a css file.
That way i can have the sites global file used to make the general apperance consistent, then make the internal content more flexible without destroying the current css file.
Is this a possible task? When i went into the main master page and tried to add a <asp:contentplaceholder id="additionCSS" runat="server" /> tag to the head. When this is done visual studio alerts me saying it doesn't recognize the tag 'asp'. Is there a way around this? We are only just rewriting the site to use master pages now so I'm still figuring it out.
I am trying to make a search page. Once a serach word or words is put in I need it to serach multiple product tables and output the description of any prioduct if the search word is present in the description.
However, If i put in 2 keywords like "paper sticker" I get no results. How do you search multiple keywords? Code:
I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst'
Does someone know where i am going wrong? Code:
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
i am new to asp and web designing, and was wondering how to reload a page so that a different set of images appear, depending on which submit button is pressed. Code:
View Replies View RelatedJust as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
Can anyone tell me how to link from ASP to Crystal Report like to create a report in CR when a user key in some requirement to pull out data from database(SQL Server)
I dont ASP, but I need to get the report.asp in this code top open in new window with the results desired. It works fine the way it is, but I just want the report to open in a new window. I would appreciate any help possible.
case "five"
OD=Request("OD")
pwt=request("pwt")
pg=request("pg")
cwt=request("cwt")
cpg=request("cboCPG")
strSQL="Select * from Query1 where PipeOD="& OD &" and tblpipe.wall_thickness = "& pwt &" and tblpipe.pipe_grade = '"& pg &"' and tblconnectors.wall_thickness = "& cwt &" and tblconnectors.pipe_grade = '"& cpg &"'"
response.redirect("report.asp?myquery="& strSQL &"")
I'm new to ASP & wish to use it to create SQL report based on the following query:
SELECT DISTINCTROW Users.LastName, Users.FirstName, Users.JobTitle, Courses.CourseName, Status.Status, Status.Date FROM Users INNER JOIN (Courses INNER JOIN Status ON Courses.CourseID = Status.CourseID) ON Users.LoginName = Status.LoginName WHERE (((Status.Option)="Required")) ORDER BY Users.LastName;
Do I need to break up the SQL query per row and write out the report? I was thinking I could create this query, retrieve the information & create an SQL report.
However, my SQL is very rusty so I don't remember how to make the command (the only nice thing about GUI interfaces, the client thinks I know how to make the report as I can print it from the db.).
I have made some reports with asp codes. the reports are working correctly. but I want to set the margins, header & footer dynamically using asp codes. is there anyway to do it?
when I print the report, I don't want the header & footer to be printed out. I know that we can set this by going to the printer settings...but then this application will be installed in our server and we can't expect every staff to change them when they want to print.
I have users typing in information into a text box. Sometimes this information can be lengthy and contain simple formatting such as spacess between lines and line numbering. For example:
1. List item number one
2. List item number two
I then have a report page that prints out this information. Unfortunately, the line spacing doesn't show up in the report. It's just all jumbled together. I'm just using <%= Notes %> to show the db field. Is there a way that I can show the formatting that was originally entered or do I need to use some kind of word processor like I am using to type this post?
how can i create a graphic report based on database information.
I have an asp page where i asked some questions to users on my intranet, and
i have that data on a database, so i want to make a graphical report (i.e. a
pie) where i can see the results.
Can i create a template in Word and just out in all
the information from database using ASP?
I have to do :
1.Collect the information from the ASP froms into database
2.The information what i collected should be inserted into
an word template.
i want to connect crystal report with asp .but i don't no how
plz tell me with example and web link where i can see?
is there any more option of reporting with asp other then crystal report?
all does any body know??how to run a crystal report in ASP..I found many sites but it is all on ASP.Net
View Replies View RelatedI am generating a report in HTML, that my users can look over AND if
they want to, store in their own Access dbase.
Thing is, I do not know how to "read" that whole html page into a var
and store same in a field in Access.
This may be in the wrong forum, but I'm going to give it a shot anyways. Here goes.
I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24.
I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour.
Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting.
What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph.
To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back.
If you want to look at what we have now visit URL.
How can i include crystal report in ASP?
View Replies View Related