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.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
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 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
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 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.
Vb6 With Active Report - Cannot Call Other Report Data Field
Below is the coding:
Problem is this sentences: rptAmt2.Fields("Amt3").Value = 0
It cannot identifier rptAmt2 which another report data field.
Can anyone help me, thank you.
Dim rptAmt As New rptFinanceAmt
Dim rptAmt2 As New rptFinanceAmt2
If Fields("Amt3").Value = 0 And rptAmt2.Fields("Amt3").Value = 0 And rptAmt.Fields("Amt3").Value = 0 Then Fields("Amt3").Value = ""
ElseIf Fields("Amt3").Value = 0 And rptAmt2.txtAmt2 = Empty And rptAmt.txtAmt <> Empty Then Fields("Amt3").Value = 0
ElseIf Fields("Amt3").Value = 0 And rptAmt2.txtAmt2 <> Empty And rptAmt.txtAmt = Empty Then Fields("Amt3").Value = 0
ElseIf Fields("Amt3").Value = 0 And rptAmt2.txtAmt2 <> Empty And rptAmt.txtAmt <> Empty Thenb Fields("Amt3").Value = 0
End If
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
Help With Report - Easy One For People Familiar With Crystal Reports, Data Report Et Al
Till date, I have worked only with the Data Report
Utility that is dovetailed with the Data Environment
Designer, for the purpose of generating reports in my
applications. Shamefully, I am completely nescient of
Crystal Reports. I would want someone to kindly take
time to read my query and provide me a clue as to the
solution. The problem, I surmise, would be
interstingly simple for the creed of programmers who
are familiar with reporting softwares like Crystal
Reports.
I have a table in MS-Access 2000 and its called
'Holidays'. The Holidays table has the following
fields:
DATA Active REPORT In VB
I have two combo box with 5 different drop down request. I want to be able to select the two drop down request from the combo box and click the command button to retrieve the data depending on the request. It should bring up a report with the specified data. Any ideas on how to do this?
Active Data Report / Print Directly To The Printer
-Anybody can give me an idea how to use VB6.0 ActiveData Report work or sample using a custom paper size. pls.
-Can I print directly to the printer w/o using 3rd party / Active DataReport like DOS base?
-What font will look like and fast as DOS base print out?
THANKS IN ADVANCE
Refresh Data From Crystal Reports Report
I try to print a Crystal Reports report from a visual basic application. I do it with the command " Report1.PrintReport".
When I save the data with my report : the report is shown with the saved data.
When I do not save the data with the report, the report viewer from Crystal Repots is shown for about 10 seconds without a report and then the system executes the next statement of the visual basic application.
I use an ODBC-definition in the report to access the data in Oracle. In Crystal Reports I can refresh the data without any problem.
How do I have to define the connection in Visual Basic ? Now I have only defined the ReportFileName of the Crystal Reports Control in my visual basic application.
Can someone help me ?
How To Create A Cross - Tab Report In Data Reports
hi buddies
pls help me in creating a cross tab report using
data reports with VB 6.0
my requirement i have 3 cloumns in my table
1) emp code
2) month code
3) Amount for corresponding month
i want the report as ,.. which looks like
emp code | month code1|month code2| month code3....12
amount amount ........
thanks for helping
........
S.M. Syed Sherfudeen
Scientific/Technical Assistant-'B' ,
NIC, Madhya Pradesh State Unit,
Computer Centre 'C' Wing Basement
Vindhyachal Bhavan,
Bhopal - 460 004,
Madhya Pradesh.
Ph. 0755-551265 ext.112
Access Reports With Data Report Designer?
I have a MS Access Database as a backend to a Time Management program (VB 6 front-end) I'm working on, and I've created numerous reports. I read somewhere that you can create a new DataReport and set the DataMember and DataSource properties and it will retrieve the report. Has anyone done that successfully, and can you show me how?
Or... can I do this inside the VisData add-in?
I'm using ADO to interact with the Access 2000 database, and just recoded the VisData so that it recognizes Access 2000 format databases.
Thanks for any help!
jason
Difference Between Crystal Reports And Data Report
can u please refer me the difference between Datagrid and Crystal Reports.
Please give in which sorts of application will crystal reports be efficiently used?.
Please give in which sorts of application will Data reports be efficiently used?.
Crystal Reports - Read Displayed Data From The Report.
I am using crystal reports to display Reports in my program. I use VB Report Designer Component.
To display the report I use ADO recordset as the datasource.
Is there any way to read the data which is already displayed in the crystal reports. May be some kind of interface?
I created a Group Section and a Details section.
I have created a subreport(on demand subreport) in the group section, before the subreport is displayed i need to identify on which Group the user has clicked.
Private Sub CRViewer1_DrillOnSubreport(GroupNameList As Variant, ByVal SubreportName As String, ByVal Title As String, ByVal PageNumber As Long, ByVal Index As Long, UseDefault As Boolean)
'CRAdoRs is the datasource, ADO Recordset
CRAdoRs.Move Index, 1
'Read all the items from the recordset
'''''
'''''
End Sub
The above code works fine for the first page, on the second and subsequent pages the 'Index' starts again from 0 and i get the wronge values .
Any ideas read the data which is already displayed in the crystal reports?
Thanks.
'CRAdoRs is the datasource, ADO Recordset
Not Happy With Current Data Report Maker (Crystal Reports IX)
I'd like to make some data reports, mainly to print some info from an access database. After playing a bit with crystal reports 9 i've reched the conclusion that cr slows too much the visual studio for me, and gives me a lot of problems, and it isn't clear enough for a newcomer like me.
There are another problems in CR that are:
-If any field of the record that i want to print has a null value the full record is not printed (even the indirect fields that take info from that record)
-The preview screen does not refresh the new values of the database fast enough (i need to open the crreport viewer at least twice to get the preview screen updated)
My questions are: there is a easy solution for this problems and... there is another simpler data report maker, but not as simple as the one included in the Visual Studio which i can use to make data reports.
I only want to make lists from a table of a database, and include 1 or 2 fields that are a result of a sql query on that database. The reports doesnt have to be beautifull :P
Thanks in advance
Edited by - avi58 on 9/19/2007 1:20:00 PM
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!!!!!!!!!!!!!!
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.
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 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 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 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.....
Linking Sub Report With Main Report In Crystal Reports
Hi
I am new to segregrate crystal reports designer.while designing Rpts
how they link main report to subreport ,and can i add existing designer as a
sub report to other designer,please explain me in detail from basis as how
to link sub report to main report,Thanks in advance
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
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
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
Active Report
when using active reports, and u place fields on the detail sxn. the fields may contain more than one records and thus it will print according to the no of records. however sometimes i want to print only a fixed no of records say 4 and leave out the rest. how can i do this? nb am using the end user designer.
|
TRACKER
