Hello,
I am attempting to pull data from an Excel file. There is a column that has values that start with both alpha and numeric. The report only pulls the data that starts with alpha. I have tried formatting the cells in that column every which way but I can't get the report to return the values that are numeric. I have attached a file as an example of the Excel file I am working with. Any help with this would be appreciated.
Example_1.xls

Hi Experts:
So I'm not super with Crystal Reports... let's start there.

I have a memo field that is stored as XML.
I need to parse the XML and pull 3 variables for one for Checknumber, one for checkdate, and one for paid.

Here is part of the problem. Some data sets contain the 3 variables, some don't, some data sets are null (no data at all).
Here are 2 sample pieces of data.

<values>
  <v n="Billable">50</v>
  <v n="CheckDate">04/29/2019</v>
  <v n="CheckNumber">12</v>
  <v n="Paid">35</v>
  <v n="PaymentMethod">Check</v>
</values>


<values>
  <v n="Billable">3617.85</v>
  <v n="Paid">500</v>
  <v n="PaymentMethod">Cash</v>
</values>

Ultimately, the goal is to have a formula and to be able to search for the CheckDate, CheckNumber, or Amount.
At this point, I am not certain that even If I can isolate the variables, that the variable can be made into parameters for searching...

I have researched and attempted various string variables but without success.

I have two tables with the same fields, I need to append those table into one. Is there a way to do it in Crystal report?

Hi!

After two hours in a support call, I could not figure out how to do something that every tech support article in cyberspace outlines to do in Crystal Reports, when you have to summarize a formula.  (Crystal won't let you do so, conventionally.)

I tried the variables where you conduct "x:= while printing records" but to no avail.

If anyone out there has had a challenge with this, please tell me what you did to overcome it.

As best as I can tell you and as best as I can remember from the support call, there is a formula in Group Footer #1 - not in Details - and I need to have a subtotal for this appear in Group Footer #2.

I created several "variable" formulas, I put them in this header, that header, this footer, that footer, the Report Footer, the Report Header, etc.

I did everything to the letter, but I still could not get a simple subtotal to appear.

Please help.

Thanks!

John

This is actually a follow up question to  an earlier post

answered by Mike McCracken

I have reviewed the answered proffered by Mike McCracken but seem to have
issues because i am not filling my dataset from a list on the console
but from a method that reads data from a postgre database

I have tried to replicate McCraken solution with the same sample data that he used
and i was able to get it to run

Now i am trying replicate the  major segments  but i have problems  with each section

I got my old CrystalReports Designer loaded  from my Visual basic Application and exported
the .rpt   as  CrystalReport1 rpt

I am dealing here with only one table "Employee"

SECTION 1  (Creating the dataset)   Please see the code below

  private void btnCreateDataSource_Click(object sender, EventArgs e)
        {
            CreateDataSet();
            MessageBox.Show("The dataset is created and filled");
        }

        private void CreateDataSet()
        {
            //Creates a new dataset, 2 datatables and adds data to them
            _dsData = new DataSet("Employee");

            byte[] arrBytes;
            System.IO.MemoryStream ms;




            using (DataTable dt = new DataTable("Employee"))
            {
                dt.Columns.Add("Staff_no", typeof(string));
                dt.Columns.Add("Surname", typeof(string));
                dt.Columns.Add("Firname", typeof(string));
                dt.Columns.Add("midinit", typeof(string));
    

Select all Open in new window

…

I need a formula to look up the last cost date on a job then share the value on to a main report. However, I am unable to use the Share Numbervar because it's not a number but a date.

Maximum(MakeArray({field1}, {field 2}, {field 3}))

How to I split or separate a field in Crystal Reports to return 10 different fields with information.
The field captures answers to 9 survey questions and a comment field.
The field called "ANSWERS" returns the following information:

<pairs>
  <pair name="Q1" value="1" ></pair>
  <pair name="Q2" value="5" ></pair>
  <pair name="Q3" value="4" ></pair>
  <pair name="Q4" value="3" ></pair>
  <pair name="Q5" value="5" ></pair>
  <pair name="Q6" value="5" ></pair>
  <pair name="Q7" value="5" ></pair>
  <pair name="Q8" value="4" ></pair>
  <pair name="Q9" value="5" ></pair>
  <pair name="comments" value="ycjgvhkb,n.m,/" ></pair>
</pairs>

I want to separate to have each questions answer in it's own field

field Q1 should display 1
field Q2 should display 5
field Q3 should display 4
field Q4 should display 3
field Q5 should display 5
field Q6 should display 5
field Q7 should display 5
field Q8 should display 4
field Q9 should display 5
field "comments" should display ycjgvhkb,n.m,/

Any help would be appreciated!

I am converting my visual basic 6 application  to c#.
While in Visual basic 6  i wrote my reports with Crystal Report 11

Now i need to move these report to the crystal reports in my c# application which is
crystal report 13

I have all the forms and designer files ( including the ttx field definition file ) done under crystal report 11

QUESTIONS

1. Is there a path/tool  to migrate my old crystalreport11  file to crystalreport13  or do i have to rewrite all the reports again

2.  my app.config file in my c# application has the line:
<connectionStrings>
    <add name="Tournaments" connectionString="Host = 127.0.0.1; Database = Tournaments; Port = 5432; Username = postgres; Password = manager" />
  </connectionStrings>

How can i make my crystal report recognize this setting so that i do not have to be specifying connection string in
each report.
I just want to be able to get the designer, work on it and run .  it should recognize the app.config setting automatically

the same way my c#  forms behave

Thanks

Olukay

I am trying to integrate crysta reports into my c#  Application

I have visual studio 17 installed  and i have downloaded crystal reports  from SAP site and i am trying to follow

the instructions below:

EDIT: " To add Crystal Reports to Visual Studio you will first need to download the runtime from SAP. Most commom runtimes can be found here. Then you will have to add the CR to your toolbox in VS by choosing Tools -> choose Toolbox items. Make sure the .NET Frameworks Components tab is selected and scroll to the CrystalReport items. Check the items you want to add (CrystalReportViewer for sure) and click OK. After that the CR Viewer should be available to you in the Reporting section of your toolbox."

I just can not find where to add  Crystal Report Item ( in particular CrystalReportViewer  )

Below please find the screen where I am surpposed  to be adding CrystalReportViewer  from


It is  not Listed

How do i get CrystalReportViewer into my Visual Studio 17

Thanks

Olukay

Hello dear expert,

Since few days, I'm trying to connect my crystal report software to Solarwinds Log & Event manager reports DB but I still get the following error:
Failed to open the connection. Details: JDBC driver not found.
Even if the JDBC driver is present on the server.

Secondly:

I made a copy of one report and try to edit it with Crystal report. What happen?

1.  When I remove some columns or I edit existing content and run the edited report on LEM Report Manager, it works
2.  But When I add a new column and try to the same report and try to run it, it says "Logon failed. Error Code: -2147189176"

Is there any expert with both Crystal report and Solarwinds LEM knowledge?

Many thanks,

Christian K.

Using Crystal Reports ver 2106 sp 6
Report Header is suppressed.
There is a main report and one subreport in the Group Footer.

The report is used to print multiples of invoices with a Summary page.
The summary page prints after each printed invoice.
The Summary page holds specific information and different page orientation.

I need the Page Header to print on all pages of invoices but not when the Group Footer with the Subreport Summary page prints.
I have entered the code below.
This works to stop the Page Header listing on the Subreport Summary page and this is good.

Problem -The Page Header from the Main report prints only on the first invoice not the subsequent invoice pages.


In the report header add a formula
 WhilePrintingRecords;
 Global BooleanVar SuppressPageHeader := False;
 ""

 In the group header add a formula
 WhilePrintingRecords;
 Global BooleanVar SuppressPageHeader;
 SuppressPageHeader := False;
 ""

 In the group footer add a formula
 WhilePrintingRecords;
 Global BooleanVar SuppressPageHeader;
 SuppressPageHeader := True;
 ""

 Right click the page header in the left margin
 Click SECTION EXPERT
 Click the FORMULA BUTTON to the right of SUPPRESS
 WhilePrintingRecords;
 Global BooleanVar SuppressPageHeader;
 SuppressPageHeader

Greetings

Is there a way to pass to a Crystal Report the database connection? What we are hoping there is way to pass the the report via the VB.NET application the database to connect. This way whether we are publishing our application to a Test/Q&A server or to a production server, we do no need to edit the connection in each report prior to publishing.

I am a Crystal Reports novice.  I have an existing report that looks at a table of all employee paychecks.  It sums up the hours worked field by all employees on the last paycheck date (by referencing the maximum paycheck date), so that we can then calculate the number of full-time equivalents on that paycheck.  Management would like me to update this report to have the same FTE calculation over the previous three paycheck dates.  I tried using the running total field below.  The formula that is used under Evaluate is this:

{PR_Check_Exp_Distrib.Check_Date} in [(NthLargest (1, {PR_Check_Exp_Distrib.Check_Date})),  (NthLargest (2, {PR_Check_Exp_Distrib.Check_Date})), (NthLargest (3, {PR_Check_Exp_Distrib.Check_Date}))]

 
When I use this, it only gets the maximum check date.  Like I said, I'm a novice, if anyone can point me in the right direction, I'd really appreciate it.