http://p2p.wrox.com General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book. en Sat, 21 Nov 2009 15:20:12 GMT vBulletin 60 http://p2p.wrox.com/images/misc/rss.jpg http://p2p.wrox.com http://p2p.wrox.com/crystal-reports/77094-need-help-start-vbulletin.html Thu, 19 Nov 2009 15:03:18 GMT Good Morning, I have been trying a few different ways to get the job done, but it never works. mission: i need to run a cr .rpt, offer parameter... Good Morning,

I have been trying a few different ways to get the job done, but it never works.

mission: i need to run a cr .rpt, offer parameter values, and then export a pdf to a file.

here is what is have already, but this is giving me errors abound.

if someone could steer me in the right direction, that would be great!!

there is urgency to this project! but then again, isn't every project?

i have the luxury of using vb express, so i cannot simply add a CR into my project.

Public crConn As ADODB.Connection
Public crRS As ADODB.Recordset
Public crApp As CRAXDDRT.Application
Public crRpt As CRAXDDRT.Report
Public crSQL As String
Public crDBTable As CRAXDDRT.DatabaseTable


Test.crViewer.DisplayBorder = False
Test.crViewer.DisplayTabs = False
Test.crViewer.EnableDrillDown = True
Test.crViewer.EnableRefreshButton = True

crConn = New ADODB.Connection
crConn.CursorLocation = ADODB.CursorLocationEnum.adUseClient
crConn.ConnectionString = "DSN="MyDSN";UID="username";Pwd=;"
conn.Open() ~~errors here cannot connect to DSN

rs = New ADODB.Recordset

crSQL = "SELECT STATEMENT W/ PARAMETERS"

rs.Open(crSQL, crConn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)
crApp = New CRAXDDRT.Application
crRpt = crApp.OpenReport("C:\Crystal\report.rpt")


crRpt.DiscardSavedData()
crRpt.Database.SetDataSource(crRS)
Test.crViewer.ReportSource = crRpt
Test.crViewer.ViewReport()

crRpt.ExportOptions.DiskFileName = "C:\Crystal\Output.pdf"
crRpt.ExportOptions.DestinationType = CRExportDestinationType.crEDTDiskFile
crRpt.ExportOptions.FormatType = CRExportFormatType.crEFTPortableDocFormat
crRpt.Export(False)

crRS.Close()
crRS = Nothing

crConn.Close()
crConn = Nothing
crApp = Nothing
crRpt = Nothing ]]> Crystal Reports sabre28 http://p2p.wrox.com/crystal-reports/77094-need-help-start-vbulletin.html http://p2p.wrox.com/crystal-reports/76869-complex-grouping.html Mon, 02 Nov 2009 19:46:44 GMT Hello All, I am facing a scenario where I have to do a complex grouping. The following is the scenario... 1. Group list of people by their... Hello All,
I am facing a scenario where I have to do a complex grouping. The following is the scenario...

1. Group list of people by their birthday.
2. Then Group them by FirstName.(Also list all the people with the same Firstname in Italics, even if their birthday does not fall under this group. Also do not repeat those records under their birthday group).

Eg:-


Name BirthDay
------------ -----------
Jan 2009
Jake
====
Jake Taylor Jan 10
Jake Chandler Feb 23
Kelly
====
Kelly George Jan 11

Feb 2009

Amanda
=====
Amanda Swann Feb 08
Wolf
====

Wolf Blitzer Feb 11



in this example Jake Chandler's birth day falls in Feb, but he had to go in Jan because of the Name grouping...

Any input is appreciated.

Thanks,
Jay
]]> Crystal Reports Jayahar http://p2p.wrox.com/crystal-reports/76869-complex-grouping.html http://p2p.wrox.com/crystal-reports/76764-crystal-report-multiple-tables.html Mon, 26 Oct 2009 14:31:20 GMT Hi friends,

I have a crystal report with an underlying dataset consisting of 2 tables namely 'reports' and 'organizations' .These tables have no links.

I retrieve the reportname column value from the 'reports' table and place it in the report header section. And I list the organizations in the details section.

When there are records available in the details section, reportname is showing correctly.

But the problem is, when there are no records in the details section, reportname is not displaying in the report header section.

Can anyone suggest how to resolve this issue ?

Thanks in Advance
Panna ]]> Crystal Reports pannasn http://p2p.wrox.com/crystal-reports/76764-crystal-report-multiple-tables.html