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

Crystal Reports ActiveX Designer Logon Failed When Select MS Access Database

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

Crystal Reports..

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

Crystal Reports .ocx Control

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

Access With Crystal Reports..

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

Access Or Crystal Reports

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

Viewing Crystal Reports Within MS Access

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

Crystal Reports Viewer Active X Control

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

Open Crystal Reports From An Access Form

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

General :: How To Make A Report Using Crystal Report Direct From MS Access Form

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

Accessing Reports In Another Database

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

Specific Reports From One Database

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

Edit Reports While Others Are In Database

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

Reports :: One Chart For Each Team In Database

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

General :: Database For Tracking Due Reports

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

Reports :: Adding Another Expression To Database

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

Reports :: How To Create A Report Using Data From MS SQL Database

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

Queries :: Reports Database By Date And Criteria?

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

Reports :: Show Currently Logged In User Into Database?

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

Reports :: How To Print Images Saved In Database Records

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

Reports :: Cmd Code For Close Form Or MA Access Database?

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

Reports :: Database For Managing Time Related Contracts

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

General :: Securing A Database / Can't Edit Forms / Reports / Queries

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

Reports :: Booking Database - Summarizing By Date Calculated Fields

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

Reports :: Members Database - Show Payments Of Yearly Subscriptions

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

How To Save Access Database So It Hide All Tables / Forms And Reports

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







Copyrights 2005-15 www.BigResource.com, All rights reserved