How do you redirect crystal report to pull the information from the current company file you are in Sage?

I've spent two days on this and no one at work knows Crystal Reports. I'm new at the job and to CR. I've used SSRS in the past.

I hope someone can help me with this. I'll go step by step.

1. I have a main report and some some reports. The datasource for them is datatables. I see the datatables being populated but the subreports aren't. I changed a datasource for one of them and I wonder if that caused the issue.

2. This is the Main Report and has "Transactions" subreport

3. I changed the datasource to a new datatable for subreport Transactions

4. I see the Database Fields.

5. This is how I updated the Datasource for the subreport. The one marked X is the old one and I updated it to the new one..marked with circle.

6. I see 2 datasources but I'm using the first one

7. I checked the subreport and I see this. I don't think I need that checkbox to link to the main report. I tried it with and without the checkbox.

8. I see the data when I step thru the code


9. I don't see the data on the report

I've tried lots of things; Populated the old datatable, copied the new datatable to old one, set the datasource in the code, cleared the datasource in code, assigned it again. I also added a test subreport and that didn't get populated either.

Is my option to delete the …

I have a report that uses a table that stores multiple records for a field in another table....basically a many to one relationship.

Problem is that when I try to return the many fields in table 2 against each corresponding field in Table 1, crystal reports returns that record in Table 1 multiple times according to table 2 instead of returning all the related records in Table 2 to each related record in Table 1.

For example,
For every record in Table 2 with TradeID = 12345, those records should all be returned in the report to one row bc each row needs to represent the record TradeID from Table 1
 
Table 1 is joined to Table 2 using the field TradeID. Table 2 contains multiple records for each TradeID. TradeID and the data associated with it should only be brought back once in the report. Is there anyway to accomplish this without having to group the report on TradeID?  I have existing reports that I don't want to have to reconfigure with grouping.

If a parameter in Crystal Reports can be set to dynamic and the value is "editable" (which apparently means you can't type in the value when it is dynamic only pick the value from the list)  then what way if there is one can a user manually type in a value and have the value posted directly and pass it to the report.

If Filtering with the filter button is one way or if using STATIC Parameter the other way is there a third way to manually enter in a value to pass through to the report?

In past versions Crystal Reports had more flexible options....and it seems by now you would think that they could code a way to users to generate a manually entered value that would instantly query a list similar to the first 3-4 characters entered. SO as you type a value say "CLA" for CLARKE anything that starts with"CLA" would show up in a picklist. I am not a programmer so what do I know but  when running a report it really helps.

If anyone knows of the best way I can simplify a report for users so they can see the least amount of records. How would I stage the report or set up the SQL in an order that can hand off records in the least bulky amounts for them to access.

Ideally it would be perfect to set up a dynamic parameter with a custom entry window that pulls records immediately upon keystroke. If SAP is not thinking of this someone needs to get them on the phone. I have customers leaving the product because they found another tool that could....frustrating. When was the last…

Parameters how to limit the records returned from a Dynamic Parameter List? Is it possible. I have CR 2016 Sp5
 How do I access parameters dynamically while limiting the record list in a report. If my Crystal Report has a long list of employees say 1000 and I only need to show > 50 of them for users to pick from is there a way to limit the number of rows returned to list when the list is built dynamically retrieving all records. I know how to do it statically or with an import from an excel or text file but wondered if there is a better way to do this?

Preface:
As you can see from my image I am trying to simply update crystal reports I currently have service pack 5 version 14.2.5.2618 The current service pack is 7 and I need to get this license updated. The purchase was made last year August 2018 so I assume I should be able to get the Patch or service pack etc. without any kind of issue or need have purchase.
When I went to the Check Updates in the Crystal Reports Startup Tab I was surprised to see all the updates packages and patches.
I was surprised to go to the SAP portal and see how to do an update if that is the only way or correct way? Years ago it was very simple to click check updates and crystal just handled it for you now it looks like I'm faced with over 40 updates and service packs…..or am I?

From what I can tell this link shows me some things I can do.
https://help.sap.com/viewer/9fe2522cc23841d389160e24e801186f/2016.7/en-US/476062406e041014910aba7db0e91070.html
Looks like a Modify or Repair might work?

Do I need to just download the latest version and install it so I will have two side by side copies or do I have to go through 40 patches updates SP's etc?
Problem 1 is I just want updates not upgrades. Purchase was made Aug 2018 so I assume updates are possible not upgrades.
Problem 2 hard to get hold of the license Product key …

I have had very disappointing results with Microsoft Report Builder and SSRS.  Neither have even printed a simple results of a query.  Report Builder 3 was a sad experience. So I just downloaded Crystal Reports 2016 trial and DevExpress Reports trial.  I was told that the learning curve for DevX is extremely difficult, so I will delete that one.  I don't need complex reporting, just results of stored procs, some complex with as many as 7 tables in a series of joins.

What reporting software do you guys recommend?

Barry D

Hello,

I'm trying to make a line graph in Crystal where the line is accumulative and has a 3 year comparison.  I just can't get it to do it.  Can someone please help?  I've attached the Crystal report, and an example of what I'm trying to do.

EE.rpt

chart-example.pdf

Thank you!
Joel

If a field contains "Foreman"
then "Y"
Else "N"

I need to create an if and then formula for multiple fields.

For example

if field1 is null, then use field2 if not null, if field2 is null, then use field3 if it is not null, and so forth.

if isnull({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_6})
then if isnull({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_5})
then if isnull({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_4})
then if isnull ({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_3})
then if isnull ({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_2})
then {PRM_MASTER__EMPLOYEE.Termination_Date}