Help Explaining How XML And Possible A Database Are Used In Crystal Reports
Apr 6, 2008
Hi, I am Cesar Gonzalez, I am preparing a exam and I am struggle to get the right information for this topic.
There are several questions that I would like help with, if possible.
This is the list of Questions that I need to prepare.
a. Explanation of Crystal Reports (what Crystal Reports is trying to do? and how does it do it?)
b. Explanation of the role played by XML (and optionally any language written in XML)
c. A possible role for a database in the application.
d. why is XML used in Crystal Reports.
e. How does XML simplify storage on Crystal Reports?
f. How does XML simplify sharing on Crystal Reports?
g. What does XML replace?
h. What does the XML represent in the chosen application?
i. How is the XML processed?
j. Are there any disadvantages of using XML?
When a database is used alongside XML:
k. How are they related?
l. Is the XML stored and if so how is it stored?
m. How is the XML queried?
I Have this exam for the next 10-Apr-2008, So I would need this help before 9-Apr-2008 (Next Wednesday).
Any link/s to a website that could answer some or all the questions would be appreciate.
I would really appreciate if any of you could give a hand, althoug I know it is quite long question.
Thanks in advance,either you can answer or not.
PS: I dont know if you can send it to my email, but if so please fell free to send the answer to my email.
View Replies
ADVERTISEMENT
Jun 13, 2012
I am getting the following error when connecting Crystal reports with MS Access.
---------------------------
Crystal Reports ActiveX Designer.
---------------------------
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft JET Database Engine
Description: Unspecified error
---------------------------
OK
---------------------------
I have select following options in crystal report -> select OLEDB (ADO) , database name as filename.mdb , db type as Access.
View 1 Replies
View Related
Feb 4, 2006
I have MS ACCESS 2003 installed..I am trying to open crystal reports in access form. I am not sure how to program that..but to begin with I was trying to place the Crystal reports viewer control in the form..but I dont see Crystal Reports Viewer Control under active X controls...Is it something that needs to be installed separately?
An other member of my team has the same version of access installed but he can see Crystal reports viewer, under Active X controls?
help.
Thanks
View 3 Replies
View Related
Jun 30, 2005
I have created some Crystal Reports to open out of MS Access. Everything works great for me and all the users, except one.
The one user when they try to open the report gets nothing (no error, no lock-up, nothing). It is only on their machine (we have tested them logged into other machines and the report works just fine).
My guess is there is something wrong with the Crystal Viewer on their machine (in our case Crystal 8.5 ActiveX viewer control). I looked on their machine, and they have the same .ocx control as myself and the other users C:Winntsystem32Crystl32.ocx
I even went into their Access and Registered this ActiveX control (design view of a form) and still was not able to get the control to work. We were thinking about re-imaging this users machine, but this is the only error they currently have. I was wondering if anyone else had run into this error, and if so is there an easy fix?
Thank you for your time.
T.J. Bernard
View 2 Replies
View Related
May 10, 2006
Hope someone here can help me with this.
I am using access 2003 and Crystal reports XI.
I have created some reports using CRXI that access my access database.
I use the following code to open the standard reports. MyReportFile is the name of my rpt file. I have no problems here.
Set crxReport = crxApplication.OpenReport(MyReportFile, acViewDesign)
CRViewer1.ReportSource = crxReport
But when I use the following code to use the recordset as source for the report, everything works the same - opens the report with data from the recordset..
Problem is after I close the application, access window will not close. The only way I can close is by task manager. If the following code is not executed then I could close the access window. I get no error messages.
When I run the same application with Access runtime version I get the message "Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down.". But will not let me close the access window.
Any ideas will be appreciated.
Set crxReport = crxApplication.OpenReport(MyReportFile, acViewDesign)
crxReport.DiscardSavedData
crxReport.Database.SetDataSource SearchResults_rst
Set crxReport = crxApplication.OpenReport(MyReportFile, acViewDesign)
CRViewer1.ReportSource = crxReport
Thanks in advance.
View 6 Replies
View Related
Jan 21, 2008
I would appreciate any advice/opinions as to what advantages, if any, Crystal Reports has over Access.
I am used to developing complex queries and reports etc. in MS Access but a job I have applied for uses Crystal Reports of which I have no knowledge/experience. I've got an evaluation copy of CR and it looks relatively straightforward but if I could use Access I would!
Thanks
View 4 Replies
View Related
Nov 29, 2004
I am trying to view a Crystal Report within a Microsoft Access Project. I am recieving the following error " object does not support this property or method". I have registered the crystl32.ocx and the crviewer.dll. Any suggestions would be helpful.
Thanks
Jacqueline
View 3 Replies
View Related
Feb 26, 2006
Could anyone point me in the right direction re the Crystal Reports Active X viewer control and access forms. I loaded it onto a form in access 2000, but can't seem to find any meaningfull properties I can manipulate (especially the report source). I am thinking it works like any other active x control and I can manipulate properties through code, however, the main property I would think I need (source report) does not seem to exist. I have Crystal 10.0 loaded on my system.
View 1 Replies
View Related
Jan 31, 2008
Hi guys,
I was wondering if any of you would be able to help me out. I'm trying to get a button on an access form to open crystal reports and pass two parameters through to it from controls on the access form.
This is what I have at them moment:
Private Sub openRpt_Click()
Dim selForm As String
Dim CrystalReport1 As Crystal.crystalReport
Set CrystalReport1 = CreateObject("crystal.crystalreport")
CrystalReport1.Connect = "ODBC;UID=ID;PWD=PW;DSN=dsn;Database=dbname"
CrystalReport1.ReportFileName = "O:DatabasesCReportsSingle Project Up To Burn Rate.rpt"
'CrystalReport1.WindowTitle = "Single Project Up To Burn Rate"
'CrystalReport1.WindowMaxButton = False
'CrystalReport1.WindowMinButton = False
'CrystalReport1.WindowState = crptMaximized
selForm = 'selection formula
CrystalReport1.SelectionFormula = selForm
CrystalReport1.ParameterFields(0) = "PeriodStart(" & Me.yearCode & ");true"
CrystalReport1.ParameterFields(1) = "ProjectNo(" & Me.projectNumber & ");true"
CrystalReport1.Destination = crptToWindow
CrystalReport1.Action = 1
End Sub
With this I'm currently getting a "Method 'Action' of object 'CrystalCtrl' failed" on the line CrystalReport1.Action = 1
My Ideal solution would open Crystal Reports in its own window, but if thats not possible opening in the access form would do.
currently running:
Access 2003
Windows Server 2003
Crystal Reports XI
Thanks
View 1 Replies
View Related
Jun 3, 2014
I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "
how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error
Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work
View 2 Replies
View Related
May 5, 2005
From an Access Project database would like to run reports setup in another database, which contains some custom reports. I would like to go directly to the report preview not just open the second database. Can someone help me with how I would be able to accomplish this? I have tried using a macro but have not been successful.
Thank you,
Valerie
View 2 Replies
View Related
Jan 24, 2006
A specific report (not all fields in database) where all records have the same field (subset of database)? How?
View 1 Replies
View Related
Sep 15, 2011
I am used to old Access 97 where I could edit a report while others are in it. I created an Access 2007 db and it does not let me edit unless I have exclusive rights to the file. Is there a way to turn that functionality on?(editing reports/queries/ while others are in the database. ?
View 6 Replies
View Related
Nov 11, 2013
What I'm doing wrong with the chart in the attached DB? I need just one chart for each team but I'm getting 5 times as many charts as I want.
I'm using Access 2010 on Windows 7 & Vista
View 3 Replies
View Related
Jul 9, 2014
Our office needs a way to track reports that are due to us, so I'm trying to build an Access database to do that. What happens is this...
We put out a weekly tasking document (called an AFCTO) every Friday that tasks our outside agencies (units) to do various things. Each task in the AFCTO directs a single unit to do a specific thing. Units may be tasked multiple times in the AFCTO (one-to-many relationship), but each task only applies to one unit.
Some tasks require the units to send us reports on the status of that task, while other tasks don't. The reports that are due can occur at different frequencies. For instance, some tasks require our units to send us reports weekly on Thursdays; other tasks may require reports to be sent to us monthly on the 1st; other tasks may require daily reporting.
Now, with all that said, we need a way to see what's due to us each day. What I would like is a report that displays what's due for this week, similar to this:
So far I have a very rough mockup of what the form should look like (fmAFCTOTasks in the attached db):
The user can type in the AFCTO Task Number of the task, the start and end datetime group, the unit assigned to that task, the task desc, what type of report is due, what triggers the report, and the frequency at which the report is due. Reports can have one of two triggers...
1) event driven (something happens that requires a report to be due), or
2) date driven (report is due on certain date or day(s)).
Obviously if a report is event-driven, then there will be no frequency or date/day associated with it. How to structure the tables and the form.
View 1 Replies
View Related
Jul 21, 2013
in my daily roll call report i have 2 groups..."on program" and "graduates" these 2 groups are creating in the query...as u see in the 2nd pic... the expression as followed
Expr1: IIf([Date Graduated]<Date(),Date(),[Date Graduated])
next you can see in my 3rd pic the report and the expression that gives the 2 groups there names...it is as followed
=IIf(IsNull([Date Out]),IIf(IsNull([Date Graduated]),"On Program","Graduates"),"Recent Departures")
i will clarify that i took out the names in the roll call but both groups are sorted by the date they came in going down the list..now i need to add another group "Staff Members" to my roll call.every way i have tried altering the query expression or the report expression result in a blank roll call.
View 14 Replies
View Related
Dec 28, 2013
I have a database in MS SQL. The users connect to database via MS ACCES ADP applications.
Some tables (like a TV Station or Names of employees) in the database have fields that serve as the flags. If the flag has a value of one, then such a record is used in the query to create a report.
Because there are multiple users of the database, frequently happens that flags overlap. One user sets the flag to one, and second sets the flag to zero. Therefore, it often happens that the received report incorrect.
View 2 Replies
View Related
Jun 24, 2014
I have a report database that provides my company with clients that took our training modules and notify us of which clients completed our trainings.The clients can complete training in 3 States and "Passed" means they are good to go.
I download an excel report daily and import it to Access on a daily basis. Problem is the Report is over 8,000 rows long and basically I just need the clients that completed training within past 48 hours. The excel report provides a date of completion.
code that only pulls those clients that "Passed" within the last 48 Hours. Here is my SQL Statement I use on the RecordSource.
SELECT report.SPS, report.FirstName, report.region, report.id, report.AZ_Cert, report.AZStatus, report.CA_CERT, report.CAStatus, report.OR_CERT, report.ORStatus, report.Completed FROM report WHERE (((report.Completed)=False));
The completed checkbox removes the record from the cert queue. How can I do this more efficiently? I think I have it right.
Private Sub Completed_Click()
Const cstrPrompt As String = _
"Are you sure you want to complete this record? Yes/No"
If MsgBox(cstrPrompt, vbQuestion + vbYesNo) = vbYes Then
If Me.Dirty Then
Me.Dirty = False ' save the record
Forms!frmRecertView.subfrmRecert.Requery
End If
End If
End Sub
View 6 Replies
View Related
Jan 23, 2015
How do I run a report that will show me who is currently logged into my database that is saved on the server.
View 1 Replies
View Related
Apr 14, 2014
I have created a database which has 2 images for record embedded, the method I have use for this is to link the address were the image is in order to avoid that the database gets slow, the images are displayed on the form but I cant find the way how to embed such images in a report neither how to print them with a button used for such purpose.
View 3 Replies
View Related
May 29, 2015
I am using a database name as school. having a form name as form01.with cmd button close which close the form. I want to close form with ms Access database. So when user click close button application database will be closed.
View 1 Replies
View Related
Jan 24, 2014
I have a database for managing time related contracts.
I need to be able to run parameter queries but if I query the data by start date then and contracts which are current but started before the first date entered in the query (this is the same for end dates) are not shown.
View 2 Replies
View Related
Jan 21, 2014
I'm trying to secure my database so users can't edit tables, forms, reports, queries, etc.I'm splitting the database, making an ACCDE for users:
1. I inserted code to disable the bypass key.
2. I inserted code to hide the Quick Access Toolbar (QAT) in the On_Load sub of the form that opens with the DB.
3. Deselect Navigation Pane, Allow Full Menus and Allow Default Shortcut Menus are deselected
4. Then, I use the immediate window to show the QAT, I then create an ACCDE.
How do I link this ACCDE with the original ACCDB? Am I supposed to delete tables from the front end and link the forms/reports to the back end DB?
View 7 Replies
View Related
May 31, 2014
I have created a simple booking DB, i am try to summarize the booking by centre and date so that when a user checks if there is availability the will be able to see how many have booked an activity and how many spaces are left, i have created a new field that calculates the spare places
Spaces: IIf([Totalbookings]=[MaxPeople]"Full"[MaxPeople]-[TotalBookings])
I have also added a link to the main file - [URL] .....
View 5 Replies
View Related
Jun 27, 2013
I have a members DB that apart from full details also show payments of yearly subscriptions. I am trying to print a report that shows a list of all the lapsed members. sounds like a simple simple report, BUT...I have a table that includes male and female members on one club number, idealy man and wife, but if for some reason the part company one may not pay the others subs those making the other a lapsed member. is there anyway i can print one part without the other?
E.g. this is haw it prints now
Male Name Paid Female Name Paid
J Smith No M Smith Yes
and this is what i am after
Male Name Paid Female Name Paid
M Smith Yes
View 1 Replies
View Related
Mar 8, 2012
I have created a small database, and created a Main Menu (form), the main menu starts as soon as someone start my database, i have linked up all my forms & reports into this main menu. now i want to hide left panel bar that shows all the table, quires, forms & reports files (so nobody can access tables, quires, etc from that panel).
View 1 Replies
View Related