Type: Posts; User: jggtz
Search took 0.05 seconds.
I remember I had the same problems several years ago (almost 12) and the solution I posted was the easiest and fastest
If your code is organized in procedures, you need to change only a few lines...
Your project is using Crystal Reports version 8.5 or lower and using the OCX control
In order to solve your problem to automatically export to pdf, you should upgrade to Crystal Reports...
That's the code where you select the report
Now post the code that's in the "insreports" procedure
You could use the REPLACE function
Dim MyStr As String
Dim MyNewStr As String
MyStr = "abcd?fghijkl?nopqr?tuvwxy?"
MyNewStr = Replace(MyStr, "?", "")
...and more features...
-4 types of view
Just see the ListView's Properties Page
Here's a working piece of code that send mail with attachments using Outlook
Dim oApp As Outlook.Application
Dim oEmail As Outlook.MailItem
Dim MMail As...
IMHO, Yours is better until now
That's why is important to say versions
To Turn off:
CrystalReportViewer.ToolPanelView = ToolPanelViewType.None
To Turn on:
CrystalReportViewer.ToolPanelView = ToolPanelViewType.GroupTree
CRV1.DisplayGroupTree = False
Check if the path of your data and/or development is not in a windows protected path
You could find the minimun date in main report (in this main report suppress printing)
Link that value to a subreport using recordselectionformula
You could do it reverse mode
It could be anything about office/excel libraries
But IMHO those are bugs resolved in newer version of Crystal Reports
You could add a formula field in your report and do the calculations there
I do it next way to change forecolor of listview cells
Dim LI As MSComctlLib.ListItem
Dim LIS As MSComctlLib.ListSubItem
'Add to ListView1 -1 row -2 columns -forecolor blue
Did you try post #6?
Because my english level is not as good as I want, I can't explain exactly what Windows 7 & 8 do about certain paths and keep old versions of files generating this kind of...
I would run the tests in a folder created by me... for example: C:\MyFolder
In this folder store the rpt files and call them from there
It sounds that you are using some kind of protected folder
Probably you are using a font that is not supported by pdf and that's the reason that it change to a supported one
Are you calling the reports from an application?
Because we can change the datasource using code
If this is your case then say language & version used and also Crystal Reports version
Study the attached VB6 project
it shows one way to solve your problem
(the rpt uses the Extreme.mdb file, probably you need to change to other if you don't have it)
The OP clearly posted
Believe it or not, but in many places around the world they are still teaching VB6 and DAO in XP boxes
When using DAO .RecordCount will give you the result only after a .MoveLast method
You should investigate about:
-How to Declare Numeric variables in VB6
-How to accept data from the user in VB6
-How to use arrays in VB6
-How to calculate percentages and averages in VB6
It looks like you are using DAO
1 Reference the DAO library
2 Change the lines where you declare and where you open Recordset
Public Sub modDeterminePrice()
CR10 is better than CR8.5
In design time is almost the same thing
In CR10 You can open rpt files designed by CR8.5 and save them in version 10 or in version 8.5
(...but once in version 10...
Sorry pal, Crystal Reports 8.5 does not has the "ConnectionProperty" property that I used for provide the password to mdb at running time
Try to get Crystal Reports Version 9 or 10 or 11
Please, say the Crystal Reports' version
The next is the code I use without problems
OPOSPrinter1.CharacterSet = PtrCsAscii
The easiest way is to save those images in a db table and then retrieve them
You downloaded the Service Pack, it means that it's expecting that you already had installed the CR2008
Then place your total in the Report Footer section instead of Page Footer section
I mean pass the connection information to Crystal Reports to laod the rpt
You need to provide the connection information in the code using the ConnectionInfo property
I use SOAP Toolkit 3.0 in all my projects that consume web-services
Still available here ---> http://www.microsoft.com/en-us/download/details.aspx?id=10747
Developing in XP, the projects work...
Then post the code where you are indenting the nodes
Maybe parts of the next code & comments could help...
VB.NET and CRYSTAL REPORTS
HOW TO CALL A RPT WITH SUBREPORTS AND PARAMETERS
And what about a small conversion procedure?
Open both mdb
Read the old mdb
Make the data conversion (change/add data)
Write to new mdb
Some printers only accept their own api
Others accept any reporting tool (Data Report, Crystal Reports, etc.)
So, the best way is to select a brand that is compatible with your Windows version...
You should convert to a newer version first
Create a new mdb file (version 2003 for example)
Open it and import your tables from the older one
Now you can set a password using Access
The closing "
Set rs = CN.Execute("SELECT * from Expenses WHERE ExpRemarks ='ABC'")
Click Here to Expand Forum to Full Width