Veiw Report Made In Access 2k
How do I retrieve a report from Access 2k from ASP?
View RepliesHow do I retrieve a report from Access 2k from ASP?
View RepliesMy background images are not appearing on the page. I am unsure why. I can see them on my on pc, but nobody else with the same computer configurations can see these background images. We are using XP, so I thought there may be a problem caused from this.
View Replies View RelatedI have microsoft access 2007 installed and want to make the following:
The user can go to a website and there are a number of drop down lists which are from different tables in a database for example he might select P7-34043 as the project name in one drop down list then select his job in another drop down list
the user would then after filling out all the boxes press submit and the server would generate a report automatically in microsoft access with the values he selected
How would i go about doing this.
I hav created a report in access, when I click submit from fromnt page(HTML, ASP),
It hav to generate a report for the vales entered in the form to the report which I created in access. Is there is anyone to help me.
Can MS-Access Report be used with ASP
I Have posted this before but no answer.
I'm trying to recreate a report using ASP that was originally created in MS Access. I have no problems selecting all the records in the table but I need some formatting help. Here's an example of the report:
hospitalname doctorname phone
doctorname phone
doctorname phone
and here's what my output looks like:
hospitalname doctorname phone
hospitalname doctorname phone
hospitalname doctorname phone
Question #1
Can MS-Access Report be used with ASP?
Question #2
Do the client needs to have MS-Office Installed in order to see MS-Report?
Question #3
Do I need to Install MS_Office In ASP Hosting in order to View/Print My MS_Access Report?
I am currently working on a project that will migrate MS Access DB and Front End to web-base solution to reduce MS Access installation. Previously, users are using MS Access as frontend to produce customized report.
I am not sure if in a web based solution, using ASP, I can display the access report as-is or by converting to pdf (server side) and display on a webpage. I'm not sure if there are builtin solution on this or I need to have 3rd party to do so.
I know vb quite well now, but asp have only started in the last couple of days.
I realise that it is not possible to create a report in Access through asp (nor in vb) but i know it is possible to run the report. Therefore, has anybody know how to run reports through ASP?
I have found one web site that is seems useful, but i want to compare that code to anybody elses. If you have some code that does this then please post, as i need to get a better understanding.
I have wriiten some code that allows me to pass a value to a query in an Access database. This works fine. My question is how can I pass a value to a report in Access and display within my browser? .....
View Replies View RelatedHaving a permission problem I'm guessing but I have a ASPX page with a link to a Crystal Reports created PDF. On the local machine it access the pdf file without any problem. All other machines come up with the 'The page cannot be displayed' error.
I'm using form authentication and for testing purposes only the IIS6 application pool is using the identity 'Local System'. I've checked permission on all files and all are set correctly. Any other ideas anyone?
I am building an add user website.I have several asp scripts in this
website such as, query for username,create user, etc. Ideally I would like
to have users logon to the website,and have these scripts execute with
their individual security context Can anyone point me in the right
direction, mabe some samples somewhere
is there an sql command that allows me to select all rows where a specific field isn't called by other rows? To be more specific: I have this table for my categories. I want to be able to choose all the categories that don't have subcategories. The fields are
CaName
CaId
CaParent
So a category has a parent, so caParent = the CaId of it's parent. So is there a way to call all the categories that don't have children categories in my sql?
Is there a way I can see how many database calls were made from my script to the db server to check how well my SQL queries are formed?
I get the time taken to execute the queries, but in that time taken, I want to know how many calls were made to the DB server. Is it possible?
From client-side javascript, how can one extract dictionary cookies made by VBScript?
View Replies View RelatedI have a .asp page that has a text box and a list box. The user enters criteria into ONE of the boxes.
What i would like is that when the user makes a selection from the list box (sql populated) the text box is disabled, and when a user enters a character into the text box, the list box is disabled (not including spaces)
This is a bit cosmetic, but what is the best way of doing this? Some client side code presumably, Javascript? Code:
am using pws on win 98 and when i try to excute any asp page i got the following error
Response object error 'ASP 0156 : 80004005' The HTTP headers are already written to the client
browser. Any HTTP header modifications must be made before writing page content.
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 RelatedI am new to the world of ASP. Yes, I have created some asp
pages, for our organization. My Server configuration:
Windows NT 4 SP6, IIS Installed. Now, i want to link my
asp pages to one of my crystal report which i have
designed using CR9. I have searched all over for finding a
solution, but I could not. Please help me what are the
steps i should do to call my testreport.rpt through my
test.asp program.
I have used one tool called DebugDiag which analyses the Process and generates reports according. It tracks variaous activities like Memory leak, Process crash etc....
I ran the tool on Production server where are live application is running to find if there were any Memory leaks, process crash, hangs etc,....
The tool generated one report which I'm finding hard to analyse.
If anyone could help in anlysing the report that would of great help.
I'm not able to paste the report here. Please suggest as to how could I send the report so that you guys can go through it.
I have develop a crystal report in localhost.
But I dun't how to put in to the server.
we only need to Install the crystal report in the server?
and share the folder then it will able to run ??
I've got an ASP application on a server. It has some reports , but they're not that nice. They are usually just printing from the form, nothing fancy. I am looking at Crystal reports as an option. Do I have to have Crystal reports installed on the server for this to work? I am assuming I do.I was going to build it locally , then copy it to the server.
View Replies View Related