Crystal Reports

Hello!

I am trying to choose certain drivers and certain trailer combinations to determine the amount to pay the driver per stop. If a trailer is one type (number) they get $35, another type they get $40 per stop, and any other drivers only get $30 (regardless of trailer). Here is my current code - it is throwing an error asking for Then at the end. I don't use this every day so I'm not seeing what the issue is. I am a little rusty I guess.

if (({Dispatch2012.DriverNo} in ['1', '212', '214', '215', '66']) and if ({Dispatch2012.Trailer} in ['361', '362', '363', '9385']) then ({Dispatch2012.Stops} * 35))
else if (({Dispatch2012.DriverNo} in ['1', '212', '214', '215', '66']) then ({Dispatch2012.Stops} * 40))
else ({Dispatch2012.Stops} * 30)

Any ideas??

TIA!
Di

Crystal Reports

In my crystal report i added water mark image on the main report and rest of rows are in second subreport. My question is how can i fix no of rows in second subreport ?

Crystal Reports

I'm running into the below error when using the OLE DB (ADO) SQL Server Native Client 10. Server is running SQL Server 2008 R2. We are able to make a connection using Microsoft OLE DB Provider for SQL Server fine however the reports are putting out unreadable data. Thanks in advance.

Good Morning All;
We are creating a report which will show a distinct count of cartons which have specific total units. For example we have 5 unique cartons that have a total of 3 units, we have 10 unique cartons that have a total of 4 units and we have 6 unique cartons that have a total of 10 units. On the report we currently have each carton number and a sum showing the total units within each carton. We need to create a Grouping that would show something like this:
Week #43 Total Cartons 10 Each Carton Contains 5 Units
We cannot do a distinct count of cartons because there are various totals for each carton so we thought a distinct count of the Units within a carton or sum of the units in a carton would do what is needed but we cannot do a distinct count against the sum. We attempted to convert the sum to a text and then do a distinct count of the text but the text field is no available to select for a distinct count. Is there a way to do this distinct count?

Appreciate any assistance.

Rosemary

Crystal Reports

7 Comments

I have Crystal Reports 7 (mr2). Its circa 2000 but is functional and fast, and it is used to support another program that is circa mid-80s. I add this point because there really is not a modern alternative and I am stuck with the 80's program.

I eventually coerced Crystal to run on Windows 7(64), to get away from the Windows XP box it is running on. It appears to work but for one problem. When running a report as an AD domain user the report fails with: "PEStartPrintJob : Error detected by database DLL." But if I log off and back on as the local Administrator, the report completes successfully.

The other point I would mention but might be nothing is that the startup file: "Seagate Info Startup" which launches: Sentinel, APS, Agent, and Analysis Server also fails to launch those programs as an AD user. I can launch the program manually and then it runs. Again its different behaviour as local Admin. The file launches from the StartMenu startup folder without a manual nudge.

Been scratching my head for the last 12+ hours or so. I doubt anyone out there is still using this antique but on the off-chance someone is, what's the trick? why doesn't CR7 like domain users?

6 Comments

Our database lists loan officers by a number. I would like to write a crystal report and instead of having a number show up for each loan officer I would like to see their name instead

Example Bob Smith is loan officer 01

When I look at the report I see 01 for all the loans Bob sold

instead of seeing 01 come up I would like to see the name Bob Smith

Can you point me in the right direction

I've written my report exactly the way I want it except for one issue.
I only want to show the GROUP1 if it is equal to B3. Nothing that I do seems to work and not sure why?
I've tried "Section Expert" then "supress" and then {SARAATT.SARAATT_ATTS_CODE} <> "B3"
Also tried - GroupName ({SARAATT.SARAATT_ATTS_CODE}) <> "B3" and other things I can't remember :)

The field is a string.
cat3.docx

Crystal Reports

10 Comments

I created a crystal report based on a command. To speed up the query I have a date parameter in the command

. This is OK, however I am prompted again for the same date parameters again once report is launched

.

Is there any way I can stop the report requesting the exact same parameters twice?

Thanks

David

Crystal Reports

5 Comments

Free Tool: Site Down Detector

LVL 9

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

latest version of crystal report

Crystal Reports

Hi, I am creating a very simple Excel file for a user to populate with part numbers that I have attached to a Crystal report. We are on;ly using column A with no formulas or calculations. This is just a flat file for them to use to get data back just on the part numbers that they want to see. I have populated several cells for testing and found I have one rogue. When entering the data all of my entries justify to the left except this one number, it justifies to the right. This is no big deal except it tells me something must be different about this part number. If I go to the Crystal report that is using this file to look up the part numbers and I browse this data field I can see all the part numbers that I have entered except this one. This is an example of the list:

2722M69G01
4013770-389
5318216-01
5318217-01
5319098-01
7010102H03
704977-3
7083M57G02
7086M33G01
710181-2CSI
749059-1
763904
1725911

It is the last one in this list that is the trouble maker, 1725911. I have tried formatting the cells to number, text and general with the same frustrating results. Any help with this would be appreciated.

Thank you

6 Comments

LVL 4

Question by

Rodger

2017-06-15

Crystal Report Gauge

Good afternoon all,

I have a simple question. I am trying to use a gauge on my report. The report is a detail item report for a patient with all the cost associated with the case. I think would like to see what the cost ration is so I take my total cost and divided them against the total charges, I have created a Formula Field for this and I am getting the data as expected of 0.17 for this one case. I want to place that value on the gauge to show how it falls in line. I want to show that value on the gauge, but when I try and add the data field I created it wants to summarize it using Sum, Count, Average. I do not need any of those as I have the value I want. How can I get that value on the gauge? I would also like to start the gauge color with green from 0 to 20 then change it to orange from 20 to 70 and then red for 70 to 100.

Thanks,
Rodger

Crystal Reports

Our company has thousands of different vendors in its ERP system. Many of them we no longer use. I'm trying to figure out the best way for me to create a report that will show me a distinct list of suppliers that we have used. Or a way to show the last time something was purchased or received from a vendor. I can use SQL, Crystal Reports or Excel to create this but would need the thought process of what to filter the report on. My goal is to review vendors where we have not had usage from say the past three years and eliminate them from our database.

I need to display part of a field on a report. An example of the field is:
SRC:Urine
Performed At: EDIWK, EDI Testing Lab
555 Anywhere Street, Anywhere, NC, 272150000
Testing, Pathologist, MD, Phone: 3365550001.

The only part I would like displayed is the text that starts with Performed at, suppressing anything that would be prior.

I am using the formula

Replace ({lab_results_obr_p.obr_comment},"^" ," " )

I hope this can be done.

Nancy

Crystal Reports

I need to execute a formula to replace character u with greek mu (for micro).. Currently the formula is checking a value in one field and return the value from other field. I need to take the returned value and replace the value u with greek mu (for micro symbol).

Right now I have
If {SampleReuslts.ComponetColumn} = 0 THEN {SampleResults.EnteredValue}

I need to add to Entered Value something along the lines REPLACE({SampleResults.EnteredValue,"u",???)

where the ??? is representation for greek mu

Crystal Reports

I am trying to add a barcode to a crystal report but i am having no luck so far.
I have tried using barcode39 and barcode128.
I have created a formula field, chosen basic syntax and pasted in the formula. I have then edited the data field to link to the field in my table, like so: "TABLE_NAME.FIELD_NAME"
I have been using this font 'Code39AzaleaRegular1' when using the formula for barcode39.

our crystal reports are working fine in development PC's in development environment (VS.NET). we are using ASP.NET and display reports in crystal reports viewer.

But when i make the setup of install the application on deployment PC i get the error

"Invalid Table Number"

Deployment PC has .net framework, sql server but no report is working but the same code is running fine in development environment. Please let me know how can i remove the above error and display reports in browser. Also i found that sql 2008 is installed in the system i am installing my application. and if i install sql server 2005 it gets works, so is there any help that why sql 2005 is needed to be installed?

Hi,

I have fields License Number, Award Date, Drug Action Classification, International Birth Date in a 2*2 grid and all fields can grow. I have another field 'Name of the Product' which is next column of 2*2 grid but the 2 rows are merged. When I set the property fo the field to 'Can Grow' = true, then this layout breaks and below field is overlapped. I also tried putting fields in different sections, but then the layout of 'Name of the Product' all breaks and I am not able to have a layout as per client requirement. Kindly suggest a work around this problem.

Thanks in advance.

Rahul

Free Tool: SSL Checker

LVL 9

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi, I am unable to uninstall CR 2013 from my machine. I keep getting an Assertion Failure. Is there a tool or another way to uninstall the program? Thanks.

Crystal Reports

6 Comments

Question by

pamela rizk

2017-06-12

asp web

How to get the list of parameter fields name from a crystal report starting with sp_lbl
in asp.net web application.

I am modifying an old report to add in a gross margin. I have created the formula (profit), the variable and the display variable. However, I am getting a running total in the group section and cannot figure out how to change it so it only totals the groups. There are other such formulas in the report so I followed suite but cannot reset the running total on the profittotal formula. Attached is the file. Thanks for any help!
_QH_ship_cust_cost_with_margin.rpt

Crystal Reports

is there a way to truncate the labels on horizontal axis? The labels represent YYYY-MM-DD ##. I want to hide the last 2 characters and keep only the YYYY-MM-DD.

Crystal Reports

I had this question after viewing 03 Feb 10 20 - Crystal Report Events in Asp.net.

I've posted the link above regarding an old post (7 years ago). I"m utilizing VB.NET and I'm trying to access the Toolbar control to attach an event. I want to override the CR Print button.

When I use the above example to try to access the Controls, I only can see 2 objects.

MyReportViewer.Controls(0) = {CrystalDecisions.Reporting.WebControls.ParameterList}

MyReportViewer.Controls(1) = {CrystalDecisions.Web.CrystalReportPageViewer}

I'm unable to see anything past (1). This is for a VB.NET website.

9 Comments

Hello Experts,
I am trying to refresh my report and i get the message "A string i required here" for the part in bold, i am not sure whats going on , any ideas would be appreciated.
Thank You.

{vwApptSchedAvail.Available_Date} in[b] date(2013,10,01) to date(2014,02,28)[/b] and
{vwApptSchedAvail.Activity_Type_Abbr} in ["SAME", "Same 20", "SAME15"] and
{vwApptSchedAvail.Sched_Loc_Abbr} in ["Catawba", "Bessemer", "Cherryvl", "Davidson", "Highland", "LincHHHC", "Main", "SCC", "States", "Third"]

Open in new window