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 Replies
ADVERTISEMENT
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
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 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
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 5 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
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
Sep 2, 2013
I have been tasked with creating a database to log employee suggestions and then automatically present reports around the site. I have developed the database and it works OK and can output *.PDF reports, but I'm having problems with how to display these reports. My idea was to output the reports automatically as *.TIFF or *.JPG files and have them stored in a folder that the My Pictures screensaver uses. The reports (in fact, any site report stored in this folder) can then be shown on any screen dotted around the site when it goes into screensaver mode. However I can't find any way to output/convert to a picture file.
The other option is to create a webpage that rotates through the saved PDFs, but this isn't ideal as the PC users will have to load the webpage to display the reports.
View 4 Replies
View Related
Dec 28, 2014
I am trying to create a P&L statement in access. I know what I want to come out at the end. I am just starting to play with access and having trouble getting what I want to come out of it.
On the sales side I have a query that gathers all the revenue sources and calculates a total for each date. I then use a second query to just take out the data I want for the P&L report. I created a sub-report that displays the data I want. I use the grouping and grand total features to get the total into the report footer. So far so good.
On the expense side I created a form of a query to manage the one to many relationship to capture the data for expenses (one purchase with many line items). I created a query based of this query to get the relevant data for my expense sub-report. I created the sub-report and got everything looking and calculating the way I want it to. I use the same grouping and grand total features to display the data in the report footer. Still good.
I created a new main parent report with the two sub-reports (sales & expenses) on it and even was able to pull the totals from the sub-reports into the main (so currently the subtotals of the two sub-reports are displayed twice). Now when I try to use the textboxes I used to pull the sub-report totals into the main report to perform additional calculations (sales - expenses) I get #error. I have tried different things and gotten ?name.
Control source for the two textbox controls on the main that display correctly, but don't let me do any further calculations.
=[rptP&LExpensesOverview]![AccessTotalsAmount]
=[rptP&LSalesOverview]![AccessTotalsTotal Sales]
To do the subtraction I have tried using the references above, as well as just using the names of the unbound text boxes in the report that bring the totals into the main report.
As a work around, I tried to build one query with all the data from sales and expenses, but can't "filter" based on date and get the data I want in the query results because the two sets of data are not necessarily related. I either get a long list of records, or no records (I am currently only playing with about 5 days of data).
View 2 Replies
View Related
May 7, 2014
I've got a word mail merge document that is formatted exactly how I want it. I'm using an Access 2003 database to populate the word 2003 mail merge document.What I would like is to use a access report rather than a mail merge but correctly formatting everything is going to take me forever.
Is there any way I can use the word document I already have to enforce the formatting or must I spend hours positioning each line of text by eye and guessing where on my report it must go to match the word doc?
View 3 Replies
View Related
Jul 2, 2013
Is it perhaps possible to "copy" the format of an entire report and "dump" it on another? I have ample of forms and reports and I know how to use the Format Painter - but I need to alter the format of all the other physical reports.
View 5 Replies
View Related
Feb 12, 2007
Hi there..
We are migrating from Ms Access To VB.Net application and sql server as backend. We have lot of reports using MS Access. Can some one give some idea about how to get those reports from new system. Is there any way?
Thanks
Danny
View 2 Replies
View Related
Oct 28, 2004
Hi
I have a one page report in Access. I want to print upto a
100 copies of the report.What code/design setting/macro/
or anything do i use so that the first report has a 1 at the top,
the second has a 2 , the third a 3.... and so on.I have tried
creating set value event but nothing seems to work.
Any idea on how i can do this? Please help.
Looking forward to seeing your reply.
Kind regards, Kensolo.
View 4 Replies
View Related
Jul 26, 2005
Is there a way to allow an Access report to be longer than 21 inches in design view?
View 3 Replies
View Related
Nov 14, 2006
Okay, I am relatively new to MS Access and all of the wonderful tools and tricks that many of you may already know. So with that in mind I maybe asking a question that some of you may go GEEEZ where did this guy come from, Everybody knows that. So if that is the case I apologize in advance.
So here is my situation. I am creating a database to be used by my companies Quality Assurance Department for reporting nonconforming material. The company has a preset sheet that is used for this already that is a controlled document. Currently when an operator has bad material they must hand fill in the sheet. Okay here is the deal the form they use for this is in excel....UGH I know I hate it when people use Excel for text purposes. Is there anyway at all I can get that format of that document into access as a report so that when my record is created it will print it into this report......without me manually recreating this report in Access?? Cause WOW...I dunno if I personally could recreate it the way they have it.....PLEASE help me if you know of an easier solution....
Thanks
AO
View 1 Replies
View Related
Aug 16, 2007
Hi all,
You need to help me in this! I designed a billing database but now i need to create an agewise debtors report broken down to 30, 60, 90 and above 90 days. Anyone to advice me on this?
Cheers
View 1 Replies
View Related
May 24, 2005
Hello,
I need to replace certain values by an abreviation. Is it possible to use a function similar to the following (Excell) formula in a field in an Access Report?
Code:=IF(A1="XXX";"AAA";IF(A2="YYY";"BBB";IF(A3="ZZZ";"CCC";" ")))
If so, what syntax should I use, because this doesn't work in Access.
Thanks in advance!
View 1 Replies
View Related
Aug 19, 2004
Hello,
This is a bit of a stupid problem but I've been trying to get a report in Access that will display data in a certain format but have been having real difficultly getting the grouping right.
This is the SQL query that I've got which gets all the results
SELECT Student.Surname, Student.Forename, Student.Admission_No, Student.Year, Course.Course_Title, Student_Course.Grade, Student_Course.Points, Student_TotalPoints.Total_Points, Student_TotalPoints.Mean_Points, SchoolTotal.School_Total FROM ((SchoolTotal INNER JOIN Student ON SchoolTotal.Year=Student.Year) INNER JOIN (Course INNER JOIN Student_Course ON Course.Course_Id=Student_Course.Course_id) ON Student.Student_id=Student_Course.Student_id) INNER JOIN Student_TotalPoints ON Student_Course.Student_id=Student_TotalPoints.Stud ent_id;
See attachment for results this produces...
I would like to get these results to be displayed like this:
Name Admission No Year Course Grade Points
Dave Jones 1856 2004 Business D 60
RE C 80
-------------------------
Total Points 140
Mean Points 70
--------------------------
Becky Smith 1974 2004 Chemistry A 120
Physics B 100
---------------------------
Total Points 220
Mean Points 110
---------------------------
etc
I know I could do this for a webpage using ASP so there must be somewhere to get the report looking like this in Access....
Any help would be much appreciated...
Andy
View 1 Replies
View Related
Sep 9, 2013
I have a report generated by a query.
The query shows the total rent collected per property and the total expense per property. It then has a sum in it to work out the total profit - SUM(rent collected - expense paid.).
This works fine and the report works fine. But i want to add the totals in the bottom of the report.
So i have three unbound text boxes, one for each column. And the control source is
Sum([rentcollected])
Sum([expensepaid])
these two work fine, but then i have tried to work out the total profit but can't get this working. If i do Sum([profi]) this doesn't generate the real profit as it just totals the profit column which might have negatives.
If i put in sum([txtTotalRentCollected]-[txtTotalExpensePaid]) then when running the report it prompts for the values of the text boxes - these are the names of the text boxes the totals are calculated in.
View 1 Replies
View Related
Oct 26, 2007
Hello all...I'm having a problem when exporting some text from Access 2000/XP to Excel using the EXPORT function. The reason why report is used to export is b'cos I need certain layout & to be ported over to Excel.
Text like '00133484-001' or '00130898-001' will be changed to another number after EXPORT, can anyone help me in this ? How can I set these numbers so that they remain the same ?
View 3 Replies
View Related
Jun 30, 2014
I have limited users to not show the ribbon, but I need them to be able to print of reports or export them as pdf files how do I give them access only to do this ?
View 3 Replies
View Related
Aug 12, 2015
I have a function that capture a report activity ,open, close, updated by query, etc.... I have a report that has a inputbox on the open event that tell the user this date the report will display is from a previous update and ask if they want to run the query to update the data.
What I was hoping to do, is have this inputbox only fire if the date and time written when the last update occurs was 24 hours ago.
Can I capture the date and time that the function captures and writes to a table as a variable and you that date and time to detemine whether that inputbox fires?
View 7 Replies
View Related
Aug 8, 2011
I work for a landscape company and I am trying to create a customer specific report by linking only the services each client receives, leaving out the services they dont receive, we have over 50 different types of services we offer. I can get the expression to pull the correct information separately but I don't know how to build the expression together. Each expression is listed below.
=IIf([Call List- Cut Backs.2010 Season Status]="Automatic","Automatic Cut Backs",IIf([Call List- Cut Backs.2010 Season Status]="Call Every Year","Call Every Year Cut Backs"," "))
=IIf([Call List- Annuals.2010 Season Status]="Automatic","Automatic Annuals",IIf([Call List- Annuals.2010 Season Status]="Call Every Year","Call Every Year Annuals"," "))
View 1 Replies
View Related
