Crystal | Crystal is minimalistic PHP database toolkit

I am trying to write a SQL query that adds a certain amount of empty columns, based on the number of rows in a related table (t1) for a Crystal Report. These columns should have the header of the name of the dataset.

So it should look something like this:

However I would need to change the script each time a new row gets added (e.g. opening a store - not very often, but it does happen).

I thought about using the pivot function, but I believe the number of rows must be defined - plus, there is no calculation / aggregation happening.

Does anybody have an idea on how to solve this?

I'm new to crystal reports I'm trying to change the selected tables based on user input in SAP crystal reports but when I enter a value it shows an error message, this is the code :

I've tried various ideas and I always come back to 2 main results that are wrong. I don't know where I'm going wrong.

Working with react leaflet and a water api. I create an array of objects from the data obtained from the API, console log shows I have all the correct data, particularly at line 109 it does output the correct information. Yet, on lines 254 and 255, using obj2[1] just gives me 'TypeError: Cannot read property 'name' of undefined.' Switching the index at those two lines back to 0 makes it compiles and run, but that's obviously not the right data. What is going on here?

I have got an application that needs to print reports at a distant location connected via the internet. Since there is no network printer we have to send reports generated through email and wait for someone to print them.

I was thinking if I can use windows service to automate the task

I've got the following options

1. get data from SQL Server base on filters transferred from distance location to generate crystal report and print it to the default printer.

2. get the report in pdf format from distance location & print it to the default printer

is any one of the options possible.

I'm asking for some help here since I've not created a windows service up till now for anything

Your guidance is highly applicated

Thanks a lot

Amit Saraf

I am using CIImage to add a number of different filter types to an image. All filters are working fine with their default values, plus the CIPixellate and CICrystallize filters are working with kCIInputScaleKey and kCIInputRadiusKey values added respectfully. Howsever I am having trouble adding values for the CILineOverlay filter. I would like to feed it a specific value for inputEdgeIntensity. The Core Image Filter Reference docs state:

inputEdgeIntensity: An NSNumber object whose attribute type is CIAttributeTypeScalar and whose display name is Edge Intensity.

Default value: 1.00

But I can't find an example anywhere of how to add this value using swift. Using this code does not work:

I require the use of F# 4.5 running on the .NET Framework (not .NET Core). I would like this environment running in a docker container as it'll run periodically on our Jenkins build server. I thought that I could use the existing .NET Framework SDK Image but it only has F# for .NET Core/.NET 5.

So I attempted to install F# into the running container (should that work, I would add it to the image itself) but I am not having any luck. Here was my attempt...

1. Create a project folder

2. Download vs_BuildTools.exe to project

3. Create a Dockerfile using the .NET Framework SDK 4.8 image

   ...

I want to print current username using Crystal-lang, does anyone know how to help me?

I want to define a generic memoizing wrapper in Crystal. I have the following crystal code: