Crystal Reports Forum : Writing Code

.NET questions

Mon, 20 Apr 2020 05:47:12 GMT

I haven't done this in Power Shell, however, I hope I can point you in the right direction.

1. I would replace "HasRecords" with "Refresh" to run the report.

2. To get to the parameters for the subreport, you actually have to walk through the sections of the report in code to find the subreports and pull the parameters from individual subreports just like you're doing for the main report. In fact, I'm surprised your report is even running because I don't see where you're setting the credentials for the database connections, which you also have to do for each subreport as well as the main report.

-Dell

.NET questions

Thu, 12 Mar 2020 05:02:41 GMT

Hello:

I was hoping there where a few .NET gurus here that could help me understand some basic programming using the CRYSTALDECISIONS.SHARED and CRYSTALDECISIONS.ENGINE assemblies.

First off, here is my Powershell code to load a report, set parameters, and then displays the parameters for viewing on the screen.

[reflection.assembly]::LoadWithPartialName('CrystalDecisions.Shared')
[reflection.assembly]::LoadWithPartialName('CrystalDecisions.CrystalReports.Engine')

$report = New-Object CrystalDecisions.CrystalReports.Engine.ReportDocument
$report.Load("C:\TEMPLATE.rpt")

#hard code prompted values here
$customer = '065447'
$location = 1000
$locationsToExclude = 0
$range = New-Object CrystalDecisions.Shared.ParameterRangeValue
$range.StartValue = 1
$range.EndValue = 999

#main report parameter mapping
$report.SetParameterValue("Parent",$customer)
$report.SetParameterValue("Location",$location)
$report.SetParameterValue("@LocationsToExclude",$locationsToExclude)
$report.SetParameterValue("LocationRange",$range)

#sub reports parameter mapping
$report.SetParameterValue("Pm-SHIPMENT.PRO",'FB_Pointer.PRO')

$report.HasRecords

#$parameterField = New-Object CrystalDecisions.Shared.ParameterField

foreach ($parameterField in $report.DataDefinition.ParameterFields)
{
        write-output "The current value of:"
        $parameterField.Name
        write-output "In report:"
        $parameterField.ReportName
        write-output "is:"
        $parameterField.CurrentValues.Value
        write-output "Of kind:"
        $parameterField.DiscreteOrRangeKind
        write-output "-------------------"
}

QUESTION 1
What exactly does HASRECORDS do? If I leave out that line, the report has no data and is blank. Is HASRECORDS basically an 'execute' command?

QUESTION 2
The FOREACH loop at the end simply shows parameter values for each parameter, but the parameters on the sub report never show anything. How do I access the values of the sub reports?

Thanks for any input.

ReportDocument.SummaryInfo.Template

Mon, 11 Feb 2019 07:06:00 GMT

Or it may not be available. I would go to https://answers.sap.com/tags/01200314690800000341 on the SAP Community to try to get an answer. Questions in the SAP Crystal Reports tag are read by some of the support folks from SAP and they would probably be able to answer this for you.

-Dell

ReportDocument.SummaryInfo.Template

Wed, 30 Jan 2019 05:24:18 GMT

I would contact SAP help on that one. They probably re-named the property to something else.

ReportDocument.SummaryInfo.Template

Tue, 29 Jan 2019 13:40:33 GMT

Any news on that? Thank You

Null Field

Tue, 19 Jun 2018 09:08:39 GMT

Looks correct to me. Don't forget about the "Default Values for Nulls"

Null Field

Tue, 19 Jun 2018 07:08:14 GMT

Thank you, that is what I am looking for.

What if I wanted to report on 2 blank fields, would it be an if statement or would I just put it in the select expert such as:

ISNULL({Treatme2.AppUser}) and
ISNULL({Treatme2.AppDate})

Treatme2 is the table.
AppUser is the field.

Edited by lbuffett - 19 Jun 2018 at 7:09am

Null Field

Mon, 18 Jun 2018 04:14:14 GMT

In the select expert, go to the formula editor and do a isnull check on the acceptance date (i.e., isnull({somedate}). Also make sure the "Default Values for Nulls" is selected in the Formula Workshop.

Null Field

Sat, 16 Jun 2018 17:28:46 GMT

Hello

I am trying to figure out how to come up with code (within crystal 2016) that will only show students where the acceptance date is null. Hopefully, this will show me all students that are incomplete.

Anyone know or have an idea how to do it? I can find all kinds of SQL statements; however, I am not sure how to do it in crystal.

Les

Formatting text as a date

Wed, 15 Jun 2016 01:28:26 GMT

Thank you for posting the answer it will be help full to me and many others also. because I also Don't have Idea about it.