]]>Reportinggunapriyanhttp://www.vbforums.com/showthread.php?869047-Bind-multiple-tables-values-in-Data-ReportCannot change data location of report at runtime in cryatal reports 4.6http://www.vbforums.com/showthread.php?868965-Cannot-change-data-location-of-report-at-runtime-in-cryatal-reports-4-6&goto=newpost
Thu, 06 Dec 2018 08:28:06 GMT administrative tools -> 32 bit odbc data source".
The report I then created works fine from vb6 on my local machine but I need to be able to change it for use elsewhere, but the two methods I tried above aren't working.
The only solution I can think of is to (1) create a temporary mdb database and designing the report to work with that and (2) on every machine creating an mdb in the same relative location before running the report.
However I'd like to know if there is a better way.
I realise that this is a very old version of crystal reports and I'd be happy to buy a newer version. What's the latest version that works with VB6?
Or would it be better to buy the newest version and use interop with .net?
I've only just started using crystal reports and I'm a bit clueless about it.
Thank you for any help you can provide.]]>Hi
I'm using VB6 and the version of crystal reports that comes with it, version 4.6.
At runtime, setting the connection property of the crystal reports control has no effect, it doesn't even give an error.
At runtime, setting the datasource of the crystal reports control to an ado recordset gives the runtime error 13 (type mismatch).

The data is in a postgres database.
As part of creating the report in crystal reports I needed to supply an ODBC data source, so I created one on my machine via the "control panel -> administrative tools -> 32 bit odbc data source".
The report I then created works fine from vb6 on my local machine but I need to be able to change it for use elsewhere, but the two methods I tried above aren't working.
The only solution I can think of is to (1) create a temporary mdb database and designing the report to work with that and (2) on every machine creating an mdb in the same relative location before running the report.
However I'd like to know if there is a better way.

I realise that this is a very old version of crystal reports and I'd be happy to buy a newer version. What's the latest version that works with VB6?
Or would it be better to buy the newest version and use interop with .net?

I've only just started using crystal reports and I'm a bit clueless about it.
Thank you for any help you can provide.
]]>Reportingvbradhttp://www.vbforums.com/showthread.php?868965-Cannot-change-data-location-of-report-at-runtime-in-cryatal-reports-4-6VB6 Cristal Report Minimizehttp://www.vbforums.com/showthread.php?868597-VB6-Cristal-Report-Minimize&goto=newpost
Tue, 27 Nov 2018 11:08:42 GMTI have vb6 dll application with crystal report.
When I call that report, it shows , when click minimize, it hides.
Application stop, and I cant find window with report.
ThanksI have vb6 dll application with crystal report.
When I call that report, it shows , when click minimize, it hides.
Application stop, and I cant find window with report.

Thanks
]]>Reportingigoracchttp://www.vbforums.com/showthread.php?868597-VB6-Cristal-Report-MinimizeVB6 Crystal Reports XI (11) picture is cropped instead of scaling to fit the controlhttp://www.vbforums.com/showthread.php?868425-VB6-Crystal-Reports-XI-(11)-picture-is-cropped-instead-of-scaling-to-fit-the-control&goto=newpost
Tue, 20 Nov 2018 19:57:57 GMTThe report has a OleObject to display picture. The control original size is set to 1.97 inch x 1.97 inch. The picture it points to has a dimension as 640x480 with 72 dpi. The picture is loaded with code like this:
Code:
---------
Dim fso As New FileSystemObject
If fso.FileExists(PicturePath) Then
Set Picture1.FormattedPicture = LoadPicture(PicturePath)
End If
---------
Based on online posts, it looks to me crystal report by default will auto scale the picture to fit the control. However, in my case, it auto cropped the picture to fit it. The configuration in the picture tab seem only change the cropped size. I cannot find a way to switch it to scaling instead.
Is there a way to make it to scale the picture?
Thank you.The report has a OleObject to display picture. The control original size is set to 1.97 inch x 1.97 inch. The picture it points to has a dimension as 640x480 with 72 dpi. The picture is loaded with code like this:

Code:

Dim fso As New FileSystemObject
If fso.FileExists(PicturePath) Then
Set Picture1.FormattedPicture = LoadPicture(PicturePath)
End If

Based on online posts, it looks to me crystal report by default will auto scale the picture to fit the control. However, in my case, it auto cropped the picture to fit it. The configuration in the picture tab seem only change the cropped size. I cannot find a way to switch it to scaling instead.

Is there a way to make it to scale the picture?

Thank you.
]]>Reportingsweechttp://www.vbforums.com/showthread.php?868425-VB6-Crystal-Reports-XI-(11)-picture-is-cropped-instead-of-scaling-to-fit-the-controlExcel Plan on a Pagehttp://www.vbforums.com/showthread.php?868383-Excel-Plan-on-a-Page&goto=newpost
Mon, 19 Nov 2018 16:35:07 GMTHello All
This is my first post here, I am wanting to create project timeline and hence want to use raw data to produce a auto swim lane graph with project names on the left and months at the top.
For each project there at 20 milestones that need to be plotted across the months in little triangles with their milestone names.The triangles will need to be a colour RED, AMBER, GREEN based on the data.
The data will be in Excel
Todays date will need a dotted line down the page.
Can anyone help?Hello All

This is my first post here, I am wanting to create project timeline and hence want to use raw data to produce a auto swim lane graph with project names on the left and months at the top.

For each project there at 20 milestones that need to be plotted across the months in little triangles with their milestone names.The triangles will need to be a colour RED, AMBER, GREEN based on the data.

The data will be in Excel
Todays date will need a dotted line down the page.