Active Reports
does anybody know of a way to insert xml nodes into a richedit control so as to form sentences?
patient
surname
forename
the sentence shuld be like ' dear mr <surname> <forename>
where <surname> and <forename> are directly inserted from the treeview showing xml data.
its giving me a dialog box that if i type doesnt display the data i the node but rather displays what i have typed.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Data Reports Active Reports Or Crystal Reports
Hi all
I am really stuck here and i need help urgently
I have to call three tables in a row to print a single invoice entry
noe the problem is if the do it by calling single tables then there is a problem that it is nopt going to print the last order which is filled.Is there is any way it can be done through using sql command or something.
Secondly if i use max order in sql then i would not be in a position to print order after searching for it
Thanx
Invoking Active Reports(data Reports) From ASP
Hi,
I want to invoke the Active Reports(Data Reports) from my ASP Page.The
Active Reports are created in VB.Also I want to print the Reports from
my ASP Page.If anybody already done this job,Can you help me with the
Sample Code?The reports are working in VB Client.
The reports should stored in the IIS Web server M/c.I need to execute
reports from my ASP page and also I need to print the report output.
Thanks,
Palani.
Active Reports
I use Active Reports and I need help.
I use an array which I use to populate a field. In some instances the field is multiple lines. I have a horizontal line below this field. I want to be able to test to see if the field is multiple lines and if it is I want to increase the size of the field by 100.
Here is my problem:
When the field is multiple lines there is no space between the bottom of the text and the horizontal line. When the field is a single line there is space between the text and horizontal line. In both instances I want there to be space between the text and horizontal line.
I have tried fixing this numerous ways and I can't get it to work. Here is what I think will work. I want to test to see if it is multiple lines and if it is increase the field.height by 100. Here is the code that I think will work.
Code:
If Description.Height > 270 Then
Description.Height = Description.Height + 100
End If
If this will work where do I put this code? I have tried it in detail_format but it won't work.
Active Reports
Hi there,
I'm dynamically generating various controls in an active report using VB6 & would like to create rectangles around these so that a grid of sorts is visible. Does anyone have any ideas as to how to go about doing this? I've had a look at the Active Reports help & couldn't find much. I tried using the border style properties but had no success. Any help would be much appreciated
Michael.
Active Reports - HELP!
I am in need of some help. I am designing an active report with many subreports. It has worked fine until yesterday. I use SQL to get data on a specific school that a user will select. The problem is that I am using a data control, and in the heading I am displaying the school name, number and district. I have made no changes to the code OR report, but the school number is coming up at run time with an error - undefined variable.
sql = " Select ysaf2.sn, impact, enroll, code_descrip, service_provided, kyssa_funded, sdfsca_funded "
sql = sql & " From ysaf1, ysaf2 "
sql = sql & " where ysaf2.sn = '" & sn & "' and ysaf1.sn = ysaf2.sn "
sql = sql & " order by code_descrip "
I have tried everything!! I already checked and I do have the data control in the report detail section. In the sn field, I have the datafield and datasource fields filled in correctly.
HELP!!!!!!!!!!!!!!
Help : Active Reports
hello
New member and need help in active reports
I want to amend the attachment
Thanks in advance
Active Reports
Please help me
I don't know how to create a report in VB 6.0
i am a newbie in vb 6
plz
thx
Active Reports
Have anyone ever used Data Dynamics' Active Reports to create PDF documents dynamically? I want to create a document containing a logo (jpg image) on the first page and some text on the second page. Can anyone help me?
How To Use Active Reports ?
I am working at clients place. And there is requirement of Active Report 1.0J in the current project. I have it installed on my PC but I don`t know how to use it. I have selected Data Dynamics Active Reports from Program ~ References, but how to create a report file and use it ? Please waiting for your kind help.
Thanks & Regards
Mahesh
Active Reports ???
I am working at clients place. And there is requirement of Active Report 1.0J in the current project. I have it installed on my PC but I don`t know how to use it. I have selected Data Dynamics Active Reports from Program ~ References, but how to create a report file and use it ? Please waiting for your kind help.
Thanks & Regards
Mahesh
Active Reports && VB
My problem is that only the first record is shown on the data report.
I use an ADO Data Control to access a SQL Server database.
From a VB form I create open the sql stmt along with an ado connection, command and recordset then assign the recordset to the one on the report. I then assign the datafields and show the report. The text fields on the report already have their datasource set to the ado control (adoHourlyCalls).
Code:
rstHourly.Open cmdHourly
rstHourly.MoveFirst
rptHourlyCalls.adoHourlyCalls.Recordset = rstHourly
rptHourlyCalls.hdrDate.DataField = "TheLSO"
rptHourlyCalls.txtDate.DataField = "TheLSO"
rptHourlyCalls.txtInterval.DataField = "TheHour"
rptHourlyCalls.txtLSO.DataField = "TheDate"
rptHourlyCalls.txtCollect.DataField = "CollectCalls"
rptHourlyCalls.txtPrepaid.DataField = "PrepaidCalls"
rptHourlyCalls.txtTotal.DataField = "TotalCalls"
rptHourlyCalls.Show
When I view the report it only shows the first record.
How can I get it to show all the records?
Thanks in advance.
Active Reports
i need to use the richedit control in the End user designer to consrtuct sentensec which have fields from XML file in them. one uses the replace field method . however if the user deletes a field then an error occours and the report cannot run. what i need is the how to trap the events of the richedit to ensure the user does not delete fields, or get the cursor position on the richedit and check if a field exists
Active Reports
i need help here. am using ActiveReports2 to prepare a Brochure. this has the first half of the page shoul be right side up while the other half should be upside down. the only control with text rotation is label but u cannot bind it to a datafield which i need to do. anybody who has an idea on how i can do this?
NB am using AR2 from VB6,
if not do u know of a site that can give me clues. dont refer me to Dtadynamics site. it doesnt ofer much.
Active Reports Problem
Hey all, i have a problem with viewing my active reports after i have installed it onto my computer with the Inno Setup program. I get no errors what so ever but it will not display my database information within the pages, only the default text i layed out for it. (no data displays). I will include my install script for u all to see if i missed a DLL or OCX file for it, causing it not to display any data...
Code:
; Script generated by the Inno Setup Script Wizard.
; SEE THE DOCUMENTATION FOR DETAILS ON CREATING INNO SETUP SCRIPT FILES!
[Setup]
AppName=Indra K. Shah, M.D. RPL
AppVerName=IKSMDRPL Version 1.9
AppPublisher=Cyber D! Studio, Inc.
AppPublisherURL=http://www.cyberdstudio.com
AppSupportURL=http://www.cyberdstudio.com
AppUpdatesURL=http://www.cyberdstudio.com
DefaultDirName={pf}IKSMDRPL
DisableDirPage=yes
DefaultGroupName=IKSMDRPL
DisableProgramGroupPage=yes
[Tasks]
Name: "desktopicon"; Description: "Create a &desktop icon"; GroupDescription: "Additional icons:"
Name: "quicklaunchicon"; Description: "Create a &Quick Launch icon"; GroupDescription: "Additional icons:"; Flags: unchecked
[Files]
; begin VB system files
; (Note: Scroll to the right to see the full lines!)
Source: "c:dllsstdole2.tlb"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regtypelib
Source: "c:dllsmsvbvm60.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsoleaut32.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsolepro32.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsasycfilt.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile
Source: "c:dllscomcat.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsTABCTL32.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsCOMDLG32.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsMSDATGRD.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsMSDATLST.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsMSDATREP.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsCOMCT332.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsARVIEW2.OCX"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsMSCOMCT2.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsDBLIST32.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsCOMCT232.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsMSCOMCTL.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsMSADODC.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsDBGRID32.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile regserver
Source: "c:dllsRICHTX32.ocx"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsRICHED32.DLL"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall
Source: "c:dllsMSSTDFMT.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsMSBIND.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsARPRO2.dll"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regserver
Source: "c:dllsMSADO25.tlb"; DestDir: "{sys}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile regtypelib
Source: "c:dllsmdac_typ.exe"; DestDir: "{app}"; CopyMode: alwaysskipifsameorolder
; end VB system files
; start PROGRAM FILE
Source: "c:dllsIKSMDRPL.exe"; DestDir: "{app}"; CopyMode: alwaysskipifsameorolder; Flags: restartreplace uninsneveruninstall sharedfile
;end PROGRAM FILE
[Run]
Filename: "{app}mdac_typ.exe"
[Icons]
Name: "{group}Indra K. Shah, M.D. Records Program Lab"; Filename: "{app}IKSMDRPL.exe"
Name: "{group}Uninstall Indra K. Shah, M.D. RPL"; Filename: "{uninstallexe}"
Name: "{userdesktop}Indra K. Shah, M.D. RPL"; Filename: "{app}IKSMDRPL.exe"; Tasks: desktopicon
Name: "{userappdata}MicrosoftInternet ExplorerQuick LaunchIndra K. Shah, M.D. RPL"; Filename: "{app}IKSMDRPL.exe"; Tasks: quicklaunchicon
thanks,
David
SQLite And Active Reports
I just added SQLite to an application I am developing and am quite pleased with it. Just requires a dll to run. You can even find a GUI SQLite Query Analyzer that is sufficient for testing queries. I also use Active Reports and cannot seem to get AR to recognize the SQLite database... tried ADO and DAO. To get around it I dumped the SQLite data to an array and ran the AR that way, but it seems like you should be able to run the report straight from the db like you can with access. Information was limited on the AR site.
Does anyone have an example of how to connect to SQLite from AR? Please and thankyou!
Active Reports Help Needed.
I'm using Active Report and have 100 records that I need to print on
separate pages. I set the PageHeader for header info to be printed on each
page, e.g. Customer Name and Address. I set nothing in the GroupHeader.
The data is being put into the Detail section, Customer orders, etc. When
the report generates, everything comes in fine except for the first page.
On the first page, the PageHeader and PageFooter prints correctly but the
data in the Detail section starts halfway in the Detail section, it also
prints a dotted line across before printing the data in this section. On
subsequent pages, the data prints at the top of the Detail section.
Below are several things I've tried:
1. Changing the NewPage to ddNPNone, ddNPBefore, ddNPAfter, &
ddNPBeforeAfter doesn't resolve this.
2. I was setting the PageSettings.TopMargin & .LeftMargin so I took them
out and it doesn't print anything in the Detail section for the first page.
It prints the PageHeader and PageFooter only. Then it prints the data for
the first record on the second page corretly (no dotted line and starts on
the top of the Detail section) and prints correctly on subsequent pages.
However, since I did not set the top or bottom margin, it gives me the
default 1 inch margin top and bottom which is not what I wanted.
Any suggestion out there? Thanks.
Reports Using Active Reports
I have several reports that I use, using Active Reports, I am trying to make the pages Landscape, but I dont know where to make this change. I know the dataType is prtOrientation and I should set that value to 2, but I dont know where to make this change.
Murray
Active Reports 2 - Report Designer
Has anyone used the new Active Reports run-time designer and/or Viewer?
The error I am getting is:
Method 'SaveToObject' of object 'IARDesigner' failed
I am getting an error when the "Preview" tab is clicked - I don't know why...........the code should be correct...
Dim rpt As DDActiveReports2.ActiveReport
Public CNN As ADODB.Connection
Private Sub Form_Load()
'Set active Tab to the designer
SSTab1.Tab = 0
Set rpt = New ActiveReport
'Activate all the toolbars for the designer
ard.ToolbarsVisible = ddTBToolBox + ddTBAlignment + ddTBExplorer + _
ddTBFields + ddTBFormat + ddTBMenu + ddTBPropertyToolbox + ddTBStandard
ard.ToolbarsAccessible = ddTBToolBox + ddTBAlignment + ddTBExplorer + _
ddTBFields + ddTBFormat + ddTBMenu + ddTBPropertyToolbox + ddTBStandard
End Sub
Private Sub SSTab1_Click(PreviousTab As Integer)
Select Case PreviousTab
Case Is = 0
prepPreview
Case Is = 1
prepDesigner
End Select
End Sub
Private Sub prepPreview()
On Error GoTo errHndl
'Must be used to write the designer's layout
'to the report so it can be previewed.
ard.SaveToObject rpt
rpt.Restart
'Run the new report
rpt.Run False
'Add the report to the veiwer
Set arv.ReportSource = rpt
Exit Sub
errHndl:
MsgBox "Error Previewing the Report: " & Err.Number & " " & Err.Description
End Sub
Private Sub prepDesigner()
On Error GoTo errHndl
If Not arv.ReportSource Is Nothing Then
arv.ReportSource.Cancel
Set arv.ReportSource = Nothing
End If
Exit Sub
errHndl:
MsgBox "Error in Design Preview: " & Err.Number & " " & Err.Description
End Sub
Active Reports And Text Formatting
i want to prepare a report that has 2 parts on one page. one that u read downward and once u rotate text thro 180 mdegree u ca read rthe other part downward. to do this i have a text box whose text i want to invert thro 180 degree. how can i invert text within the designer?
Data Report Using Active Reports
hi, has anyone used Active Reports by Data Dynamics? I an using the evaluation version which does not have much properties but I think it is quite similar to the Data Report.
my question is this, i was able to show the headers using a recordset however the details only show the last record.
here's my code:
'for the header
activereport1.text1.text = rs.fields("name").value
'for the details
with .rs
do until .eof
with activereport
.text2.text = rs.field("email1").value
end with
.move next
loop
end with
as i've said, the detail part only shows the last record. someone please help.
also, can someone explain the section property in a data report.
any help will be much applreciated.
Active Reports Using Data Dynamics
Hi,
Can anyone please help me in working with Dynamic reports using Data Dynamic Active Reports.
I am having a problem calling a sub report in Dynamic reports (Run time Designer) using Active Reports.
I would also like to know if i can execute 2 queries in the details section of the report. Any samples or code fragments are also welcome!
Thanks,
Malini
Crystal Report Or Active Reports?
Hi all,
do any of you have experience with both CR and AR?
If so, could you please let me in on your experience with the two?
pros and cons
Thanks
peet
Active Reports Print Settings
I am having a problem with the data dynamics active report, when I develop a new report for my application when I send it to the printer from my PC everything is fine, but when the users send the report to the printer they fund that the report can come off the end of the page has anyone come across this problem this problem before?? Any ideas on how to fix it.
Active Reports And Text Formatting
i want to prepare a report that has 2 parts on one page. one that u read downward and once u rotate text thro 180 mdegree u ca read rthe other part downward. to do this i have a text box whose text i want to invert thro 180 degree. how can i invert text within the designer?
Active Report - Several Reports In The Same Viewer ??
Hi,
I have a application which has a printing option allowing the user to print from 1 to 3 copies.
Copy 1: Client
Copy 2: Vendor
Copy 3: Archive
The 3 options are Checkboxes on my WinForm.
If the user checks all 3 options, I want to print the report (invoice) 3 times. They have slight differences but they all use the same dataset.
I don't want to have 3 viewer to popup. I really would like to have the 3 invoices(reports) within the same viewer.
I tried putting 3 sub-report in a main report. Each sub-report being an invoice, but since they use the same dataset, it doesn't work properly.
Does anyony have a solution for me? or a way to send 3 reports to the same viewer.
Thanks for helping.
Active Reports-Sub Reports->how To Use Sub Reports
hi friends
i am new to active reports.
i want to make use of sub reports
i mean if i have following tables
In a one report i want to view its sub contests
example
Contract details as a Master
and its labor details and salary details as childrens
if u know any links let me know
plz reply
help me oue
Incorporate Active X Control Into Crystal Reports?
Does anyone know if Crystal would allow us to incorporate
an ActiveX control into the program?
I'm trying to get a Linear Barcode to print in Crystal...
Does anyone know how to do this?
Any help or suggestion is greatly appreciated.....
Creating Reports Using Data Dynamics Active Report
Hi,
I'm doing a projectwork with VB6. It requires to create several reports. I already created reports using Data Dynamics Active Report, which is now integrated part of VB. I used Properties Window to set various properties (like: connection string, record source, field member etc.). Now I don't want to use Properties Window anymore. I want to create the report using the codes only (in data dynamics active reports). I tried, but I failed to do this. Can anybody help me?
N.B. I wish to create reports which will enable me to extract data from database.
Thanking you all.
About Active Form Name In Active Project
i'm using visual basic 6, in usercontrol section...
my objective is these:
when i put my control in form, in a project, can i see the name of that form?
these code must be implanted in a property page....
i try these code:
Code:
Private Sub PropertyPage_Initialize()
Dim i As Integer
For i = 0 To Forms.Count - 1
lstAddCollisionObject.AddItem Forms(i).Name
Next i
End Sub
but the problem is that i don't recive any name, and i just wanted the form name of the form that theres is my control.
then i can see the controls name in these form...
thanks
Active Window, That Isnt Active.? Look
ok say i have 2 programs open, my program and another one
they are running sidebye side. and the other program HAS to be active to work (it simulates mouseclicks)
my program will not be the active window but is it possible to still type in it.. i wanting MY program to be a multiuser chat program and im able to chat in it while the other program is running
Difference B/w Active-X Ctrl And Active-X Dll
Hi all,
I want the Difference b/w Active-X ctrl and Active-X Dll in terms of the Interface usage/vtTable(ie.Internal Differences and Internal Workings)...I know that it is an InProcess Components.
Thanx
Murali
What Do Active X EXEs Have That Active X DLLs Don't?
Hello - quick question on differences between VB Active X DLLs and VB Active X EXEs please.
My C++ client can show a form from a VB Active X EXE, but not from an Active X DLL with exactly the same code as the EXE. Any ideas why? The statement to Load the form is successful in the Active X DLL, its just giving a negative HRESULT on the form.show
Active X DLL does work ok if VB running in the background though.
Any info would be very much appreciated.
Thanks,
Mairi
In Crystal Reports, How To Display Financial Reports (P & L, Balance Sheet Etc.) In Columnar Format
Dear All,
I am developing a Financial application using VB6, MS-Access & Crystal Reports 8.5. I am facing problems in certain reports. Some of the reports like Profit & Loss and Balance Sheet require the output to be printed in columnar format.
I have tried giving subreports for each section, i.e.; Assets & Liabilities, but then, the output is not coming in order as per the groups. The problem is even more where there are sub-sections in the right side column & left side column for example in Profit & Loss, where there are sub-sections for Gross Profit/Loss and Net Profit/Loss. In such cases, how to bring the total amount fields at the same horizontal level.
I hope someone can help me how to do the above.
Thanks in advance.
Best Regards
Mahesh
Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I have several reports that were designed in Crystal Reports that have the DB location changed during runtime. When I move my database, or choose another copy of the DB that has a lot of records in it, my reports don't fire. I need to be able to Verify the database during runtime. I'm usiung VB6.0 and CrystalReports8.5 I've tried using Crystal's "Verify On Every Print" function, but I haven't had any luck. Here is the code I am using.
MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport
Also, does anyone know if changing the DataFiles location during runtime also effects the subreports. I don't think it does, but any input would be appreciative.
Need To Understand Data Reports - Heard That Crystal Reports Were Slow
I have two questions:
1.) I was going to take a step forward to learn how to use crystal reports but I heard that on a website they are viciously slow. Is that true or is there a way around that with coding?
2.) I have been using Access reports through Visual Basic 6.0 with the following code - thanks for the tremondous help of everyone on this website:
Code:
appAccess.OpenCurrentDatabase SERVER & "disp-1_be.mdb"
appAccess.DoCmd.Maximize
appAccess.DoCmd.OpenReport "oalog", acPreview
appAccess.Visible = True
The reports work great UNTIL I came accross a situation where the report is based off of the data entry of the user. oalog is a monthly report and in the query it automatically pulls the current month with the following query:
Code:
SELECT oalogallmonths.ctsbranch, Count(oalogallmonths.Amount) AS [Total Of Amount], oalogallmonths.GivebyName, oalogallmonths.United, oalogallmonths.Mayflower, oalogallmonths.Other, oalogallmonths.Tord, oalogallmonths.CURRENTDATE, oalogallmonths.Amount, oalogallmonths.Month1, oalogallmonths.ORDER
FROM months, oalogallmonths
WHERE (((months.monthID)=[oalogallmonths].[Amount]))
GROUP BY oalogallmonths.ctsbranch, oalogallmonths.GivebyName, oalogallmonths.United, oalogallmonths.Mayflower, oalogallmonths.Other, oalogallmonths.Tord, oalogallmonths.CURRENTDATE, oalogallmonths.Amount, oalogallmonths.Month1, oalogallmonths.ORDER
HAVING (((oalogallmonths.Amount)=11;
If you notice the records are pulled HAVING the 11th month in there.
If I want the user to ENTER the month I know that I must change the last line to:
Code:
HAVING (((oalogallmonths.Amount)=[ENTER MONTH]));
But a user might type January or 12/2003, etc...
so I made a combobox named ListMonth of the 12 months.
Then I made the change from:
Code:
HAVING (((oalogallmonths.Amount)=11;
to
Code:
HAVING (((oalogallmonths.Amount)=ListMonth.ListIndex + 1));
The only problem is that I keep getting a message box asking for ListMonth.ListIndex + 1.
My question is in the above code that defines appAccess.DoCmd.OpenReport "oalog"...
is there a way to change the RecordSource of the report to pull from my own query instead of the Access Query?
Thanks,
Stephen
Crystal Reports - Upgraded To 8.5, Now Reports Written In 8.0 Wont't Work!!!
My reports are crashing when I run them on a machine with CR8.5, but they work fine on cr8.0. They crash inside the .DiscardSavedData Routine.
Does anyone know why or what I can do...
I call the report.Printout routine and right after I call the
.DiscardSavedData. The report is still printing out in debug mode.
Please help. Is my syntax wrong. The help file says I can only use Printout and DislcardSavedData in "formatting idle" mode. I don't know what this this???? The .PrintOut routine works but not the discardsaveddata.
Thanks,
Any help is appreciated.
M
How To Use Crystal Reports To Make The Dynamic Reports?(I Can't Use The Design Expert To D
How to use Crystal Reports to make the dynamic reports?(I can't use the design expert to design the report,because the data source with different fields is unknown in design time.)
Hello all!
I use the dynamic generating MS Access table as the Data Source of Crystal Report.
How to use the Crystal Reports to display the data of the dynamic generating MS Access table?
Thanks All!
China
Edited by - dehuiworkroom@hotmail.com on 12/17/2003 9:37:59 PM
Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I've created a Report Viewer that displays Crystal Reports 8.5 reports. I have the DB location in Crystal Reports changed during runtime, but I can't get the location to change in the subreports at runtime as well. Also, by using my method of calling the reports, I can't get VB to pass any parameters to the Main report. Below is the code that I am using. I'm using VB 6.0 and CR 8.5
Dim MyNewKey
MyNewKey = Who.Text
' On Error GoTo KeepGoing
MyLocation = GetStringValue("HKEY_LOCAL_MACHINESoftwareAptCom", "AptCom DB Path")
strReportFile = "c:aptcom
eports eninfo.rpt"
Set CRReport = New CRAXDRT.Report
Set CrxApp = CreateObject("crystalruntime.application")
Set CRReport = CrxApp.OpenReport(strReportFile)
' Set CRReport.ParameterFields(0) = "ThisKey;" & MyNewKey & ";true"
' KeepGoing:
For Each dbTable In CRReport.Database.Tables
dbTable.SetLogOnInfo "", MyLocation, "", ""
dbTable.Location = MyLocation
dbTable.SetDataSource MyLocation
Next dbTable
CRReport.Database.Verify
CRReport.SQLQueryString = strSQL
frmReportViewer.Show
frmReportViewer.CRViewer1.ReportSource = CRReport
frmReportViewer.CRViewer1.ViewReport
Set CRReport = Nothing
Set CrxApp = Nothing
Set CRReport = Nothing
>>>>
I've tried using this method:
MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport
But, I can't get Crystal Reports to verify the database during runtime. The first way verifies the DB, but won't change the DB location of the subreports or pass parameters to the reports.
Any help would be appriciative.
Active X Exe Calling Active X Exe - Help
Can anyone show me example code of 1 active x exe raising an event in another active x exe ? without the use of a timer or any form controls whatsoever. Just class to class....
The only examples I can find use standard exe's etc and forms. I need 2 Ax exe talking to each other.
Access Reports Vs Visual Basic Data Reports?
I need some help.
For the longest time - I've been using Access Reports that are printed on carbon copy bill of ladings and the like, etc. These reports print only the data that is based on one query. That one query is based on three text boxes on a form. The query searches whatever the user typed in those 3 text boxes and pulls all the records that match. If the user does not type anything in those 3 text boxes they automatically default to '*' in each of the text.
I want to do the same thing in Visual Basic. But I have a better idea for a search. I am using a DataGrid to list everything in a query and basically the user just highlights the row that he wants to choose. Then up top on the menu he clicks on whatever report he wants to print based on the record he/or she highlights. I know I've got to use DataGrid.Columns(0) as a criteria for a search and so I've finish what kind of SQL statement I'm going to use. As regards output, I'm unsure of what to use. I did try to pull up the actual Access Report I used before but that did not work because it would not recognize the DataGrid.Columns(0) command in the query.
I'm new to the Visual Basic Data Report - I don't see any tutorials anywhere.
I understand Crystal Reports are the old way of doing this but don't have a means to try that out.
At this point - in my development - I'm thinking I'd probably make a form that would have the same output with the text boxes tied to the datasource (recordsource would be the query) and then i'd print the form data only. But not sure how to do this either? Please help.
Thanks,
Stephen
Crystal Reports- I Need Help Running Reports With A Shared Database.
I am trying to figure out how to use a shared database in crystal reports. I have it set up for my application were I use: App.Path +
"databaseWMdbase.mdb" But in crystal reports it makes you use a drive name. I am trying to use the UNC but when I run it on the computer without the physical database it tells me Database not found... is there a way to set the Location of the database in the form load like you do with ADO? Any help or Ideas would be great.
I Hate Reports. Trash Crystal Reports, Access Instead?
I am creating an app which requires a copius amount of complicated reports. These reports would be an absolute breeze to do in access, simply create a query that does all the work then base the report on that. Instead of wasting time with Crystal Reports, I'd love to be able to create an access query and then run an access report based on that query from within my VB app. Now I have code that allows me to run an access report, but it seems to require that access is open on the users machine at that time. Is there any way I can achieve what I need without opening access each time ?
Crystal Reports Using ActiveX Viewer For URL Linked Reports
Hi,
We have a IIS service that broadcasts a virtual directory of reports so that they can be viewed using the crystal reports ActiveX viewer through an IE browser.
I am now trying to replicate this setup on another server, the IIS service is setup and URL's created for our reports. When they are selected the browser defaults to the Crystal Enterprise logon screen. Where do i change the settings so that the ActiveX viewer is used in the browser to view the report?
Many thanks,
Al
Retrieving Images In Crystal Reports And Data Reports
I am saving the image path in the database and retrieving it for display but the problem is when I want to print the image for that particular record when I am only saving the image path in the database.
If I embed the image in the database it increases the size of the database but can be used in the reports in a bounded image control.
If somebody can help me retrieve the image in a data report/crystal report by using the image path in the database that did be great.
Thanks,
Kamran
Grouping Records In Data Reports / Crystal Reports
Hi
I want to group records in my Data Report based on 2 particular fields. Just see the example below.
Below is the Table Structure and its values
UnitID Part Quantity
1 xx 5
1 xy 10
2 xx 5
2 xy 10
Now I want to result to show the summation of quantities based on the part only.
so the result should be
Part Quantity
xx 10
xy 20
It would be fine if someone can tell me how to do this in Crystal report/ VB data reports
Thanks
Kumaran
Creating Active-X Control That Work With Another Active-X Control
Hello Ppls,
I've created an Active-X control say parent.ocx that work with the form's events and controls in that form. I am getting the form's things as follows.
Dim withevents frm_parent as form
set frm_parent=usercontrol.parent
The above things get work only when the OCX placed on a form.
Now when I am creating another usercontrol say child.ocx, I want to place that parent.ocx ino this new usercontrol. So I used the following code in parent.ocx
dim withevents USERCTL_Parent as usercontrol
set USERCTL_Parent =usercontrol.parent
But here when I place the child.ocx into another form, the parent.ocx is not getting the "UserControl" Object for those above line of code. It is getting the object as child. It is right thing.
Is there any solution to get the usercontrol's event and controls in thet usercontrol. If any one comes to know or knows the solution please mail me to the following id
vijayavel_vp@rediffmail.com
and also post your code here in this forum
|
TRACKER
