Search results for query: *

Go here: https://origin.softwaredownloads.sap.com/public/site/index.html. Set Software Product = SAP Crystal Reports, version for Visual Studio then click on "GO". You want the 64-bit version of the "installer" .exe file. The other formats (.msi, etc.) are for the runtime for deploying your...

You cannot return a per-record or per-group result from a subreport. You can only return the final value of a calculation. -Dell

There is no easy way to do this and have it in the cross-tab itself. However, you can emulate this by doing the following: 1. Add a Group on VegetableType to your report. 2. Suppress the VegetableType group header section and the details section. 3. Create a second VegetableType group...

The entire .NET SDK is based on COM components. However, current licensing will NOT allow you to directly access those components. So, you have to go through the Crystal for VS .NET SDK at this point. The last version of Crystal that allowed direct use of the COM components was Crystal XI...

Somewhere along the way in a SQL Server update there were changes to the internal representation of BLOB fields. Crystal 8.5 will not be able to use these new-style BLOB fields. The only way to get to them will be to upgrade the app to use the latest version of either the Crystal for Visual...

What version of Visual Studio and the Crystal SDK are you using? -Dell Associate Director, Data & Analytics Protiviti www.protiviti.com

What version of SQL Server holds the data? Crystal version 8.5 went out of support over 20 years ago. It's not able to work with some of the newer data types that are available in SQL Server. It also might be a function of the version of the data driver you used. If you have a newer version...

Try using a formula like this: If IsNumeric({table.field}) then If len({table.field}) < 3 then right('00' + {table.field}, 3) else {table.field} else {table.field} -Dell Associate Director, Data & Analytics Protiviti www.protiviti.com

Try this: 1. Create a month group using something like this following formula: ToText(Month({MyTable.DateField}), "00") + "-" + ToText({MyTable.DateField}, "MMMM") 2. Use this formula as the column. It will sort correctly by month number instead of by month name. 3. If you want to show...

Another option would be to create a formula that will display the address, taking into account that Address2 may or may not have data. Something like this: Local StringVar newLine := chr(13) + chr(10); //Carriage return/Line feed = Windows "New Line". Local StringVar result :=...

1. You shouldn't actually have to create all of this yourself. In Visual Studio, if you use the form design functionality it will set it all up correctly for you and you won't have this problem. 2. If you really do need to add objects to a form in you code, you should look at the code that...

You need to declare the textboxes and button as variables that are global to the form. By declaring them in the method above, they become local to that method and cannot be accessed from outside of that method. -Dell Associate Director, Data & Analytics Protiviti www.protiviti.com

To add to what Skip wrote, options for Excel export from Crystal are limited to what you see in the software. There is no way to make a cells in a column be drop-downs. You can only export the data you have. -Dell Associate Director, Data & Analytics Protiviti www.protiviti.com

What version of Crystal are you using? -Dell Associate Director, Data & Analytics Protiviti www.protiviti.com

You may have to include up to 3 "dummy" blank sections to get the report to roll over to the back. The suppress formula for the dummy section that will show in the 4th place on the cardstock would be something like this: not OnLastRecord or (OnLastRecord and rownumber mod 4 < 4 You would...

If you don't have a lot of data, pmax9999's answer about using the Select Expert will work. However, the filter won't be pushed down to the database for processing. Instead, Crystal will pull ALL of the data into memory and filter it there. If you have thousands of records, this can...

Have you tried passing the checkin date and checkout date as subreport links? At that point they become parameters in the subreport that you can use in the filter. -Dell Associate Director, Data & Analytics Protiviti www.protiviti.com

You'll need to download the 32-bit Access driver and install it to get access to your spreadsheet. You can get it from here: https://www.microsoft.com/en-us/download/details.aspx?id=54920. The challenge is going to be whether your O365 is 32-bit or 64-bit (the software, not the computer!)...

I think what you probably want to do is use InStr in a loop to look for the "font-size:" tag and then replace whatever the value is with "8px" when you find it. The formula might look something like this: Local StringVar inString := {x_clinical_notes.note}; Local NumberVar i :=...

One of the things to remember with SQL Expressions is that they can only return a single value. In general, SQL Expressions are not meant for writing Select statements. They're more meant for pushing processing to the database when necessary. For example, I have used them for: - Calling a...