http://www.crystalreportsbook.com/forum This is an XML content feed of; Crystal Reports Forum : Writing Code : Last 10 Posts Fri, 11 Sep 2026 07:10:03 +0000 Mon, 20 Apr 2020 05:47:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 8.04 30 www.crystalreportsbook.com/forum/RSS_topic_feed.asp?FID=12 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22864&PID=74881#74881 Author: hilfy
Subject: .NET questions
Posted: 20 Apr 2020 at 5:47am

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]]> Mon, 20 Apr 2020 05:47:12 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22864&PID=74881#74881 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22864&PID=74874#74874 Author: hello
Subject: .NET questions
Posted: 12 Mar 2020 at 5:02am

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.]]> Thu, 12 Mar 2020 05:02:41 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22864&PID=74874#74874 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4616&PID=74413#74413 Author: hilfy
Subject: ReportDocument.SummaryInfo.Template
Posted: 11 Feb 2019 at 7:06am

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]]> Mon, 11 Feb 2019 07:06:00 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4616&PID=74413#74413 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4616&PID=74401#74401 Author: kevlray
Subject: ReportDocument.SummaryInfo.Template
Posted: 30 Jan 2019 at 5:24am

I would contact SAP help on that one.  They probably re-named the property to something else.]]> Wed, 30 Jan 2019 05:24:18 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4616&PID=74401#74401 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4616&PID=74397#74397 Author: andrej81
Subject: ReportDocument.SummaryInfo.Template
Posted: 29 Jan 2019 at 1:40pm

Any news on that? Thank You]]> Tue, 29 Jan 2019 13:40:33 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4616&PID=74397#74397 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74074#74074 Author: kevlray
Subject: Null Field
Posted: 19 Jun 2018 at 9:08am

Looks correct to me.  Don't forget about the "Default Values for Nulls"]]> Tue, 19 Jun 2018 09:08:39 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74074#74074 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74073#74073 Author: lbuffett
Subject: Null Field
Posted: 19 Jun 2018 at 7:08am

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]]> Tue, 19 Jun 2018 07:08:14 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74073#74073 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74070#74070 Author: kevlray
Subject: Null Field
Posted: 18 Jun 2018 at 4:14am

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.
]]> Mon, 18 Jun 2018 04:14:14 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74070#74070 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74068#74068 Author: lbuffett
Subject: Null Field
Posted: 16 Jun 2018 at 5:28pm

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   ]]> Sat, 16 Jun 2018 17:28:46 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22630&PID=74068#74068 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20750&PID=71700#71700 Author: jessicacyrus1
Subject: Formatting text as a date
Posted: 15 Jun 2016 at 1:28am

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.]]> Wed, 15 Jun 2016 01:28:26 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20750&PID=71700#71700