Crystal Reports Forum : Announcements

Crystal Report: Country>Province>City

Wed, 08 May 2019 21:50:16 GMT

After uploading to SAP parameters doesn't work. i.e. parameters not picking the list of country or city.

Edited by muhammadsajid - 08 May 2019 at 9:51pm

CardCode Token

Thu, 07 Mar 2019 06:05:31 GMT

I believe this information is available in the "How to Work with SAP Crystal Reports in SAP Business One" document that's available somewhere on http://help.sap.com. You probably have to have an S-ID in order to access it.

-Dell

CardCode Token

Mon, 04 Mar 2019 01:41:30 GMT

We use {?DocKey@} Token in PLD for SAP Marketing document.
What would be the token if we use default Business Partner Ledger,

1. Token for CardCode
2. Token for FromDocDate and toDocDate.

I want to view customer ledger from business partner master data. and want to preview the report directly without any parameter. current cardcode and date should be used for parameters automatically.

Can any expert guide me.

Crystal Report: Country>Province>City

Tue, 26 Feb 2019 11:19:57 GMT

What isn't working after you upload it?

-Dell

Crystal Report: Country>Province>City

Wed, 20 Feb 2019 21:30:28 GMT

I have develop Crystal Report with dynamic parameter selection
like Country > Province > City.
It work fine. But when Upload to SAP B1 it doesn't.

Can Any expert Guide the matter.

Edited by muhammadsajid - 08 May 2019 at 9:51pm

Dynamic Parameter Maximum Value

Thu, 22 Feb 2018 05:38:48 GMT

I have never considered using the Db command, that worked perfectly thank you.

Dynamic Parameter Maximum Value

Thu, 22 Feb 2018 04:18:00 GMT

For dynamic parameters I normally create a command to just bring back the values necessary, thus in your case only active employees. For me, it is usually a very simple SQL statement.

Dynamic Parameter Maximum Value

Wed, 21 Feb 2018 03:49:31 GMT

I have a report that pulls Employee Performance Records using a dynamic parameter updating on employeeid allowing the end users to select the employee or employees that they wish to review.

After 10+ years we have reached the maximum number of record capability for a dynamic parameter to display.

Is there a way to restrict the list of a dynamic parameter in Crystal Reports?

I see option two to be creating a new table that is more fine tuned for active employees but I am hoping to avoid some of that complexity.

If there is an approach I am not considering I would appreciate the feedback.

Thanks

Having a brain cramp - sorting months

Fri, 07 Jul 2017 02:27:24 GMT

I sorted my stored proc by datetime asc. I also have a text month (i.e. label format "Jan 2016") formula field for each datetime field on the record. In the line chart in the chart expert I use the formatted field but order that field in "original order". It kept the labels in the original datetime order so "jan 2017" came after "jan 2016... dec 2016"

Free book give away!

Thu, 24 Oct 2013 04:21:40 GMT

I am doing Crystal with Blackbaud DB and relations are not in the same order for each student. How extensive is the formula to get Father, Mother, Emergency Contact, Agency, or Consultant to go in the right field with their phone and Email?