MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Course Of The Month
7 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Crystal Reports
34K
Solutions
5
Articles & Videos
14K
Contributors
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
Share tech news, updates, or what's on your mind.
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
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
6 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?
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?
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
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
Also tried - GroupName ({SARAATT.SARAATT_ATTS_COD
The field is a string.
cat3.docx
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
Also tried - GroupName ({SARAATT.SARAATT_ATTS_COD
The field is a string.
cat3.docx
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
. 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
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
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
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
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
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_co
I hope this can be done.
Nancy
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_co
I hope this can be done.
Nancy
Enroll in June's Course of the Month
June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.
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.ComponetCol
I need to add to Entered Value something along the lines REPLACE({SampleResults.Ent
where the ??? is representation for greek mu
Right now I have
If {SampleReuslts.ComponetCol
I need to add to Entered Value something along the lines REPLACE({SampleResults.Ent
where the ??? is representation for greek mu
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.
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?
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
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
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.
How to get the list of parameter fields name from a crystal report starting with sp_lbl
in asp.net web application.
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
_QH_ship_cust_cost_with_margin.rpt
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.
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)
MyReportViewer.Controls(1)
I'm unable to see anything past (1). This is for a VB.NET website.
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)
MyReportViewer.Controls(1)
I'm unable to see anything past (1). This is for a VB.NET website.
Free Tool: Site Down Detector
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.
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.
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"]
Hello,
I'm having trouble getting something to group. Please see the note I made at the bottom of page two of the PDF. I also attached the rpt file as well.
grouping.rpt
grouping.pdf
Thanks,
Joel
I'm having trouble getting something to group. Please see the note I made at the bottom of page two of the PDF. I also attached the rpt file as well.
grouping.rpt
grouping.pdf
Thanks,
Joel
I have a report that has 3 sub reports, (old report which has declared values and adds them up on the main report)
I would like to get a combination of the cross tab(s) information summed into one cross tab if possible
so for example headings/Example
Cost Center Description Period A Period B Period C YTD
12345 Text A 10 25 15 50
The period costs would be a comination of Labour Parts and Purchases from the sub report cross tabs
Have attached the report for information
Is it possible?
Gordon
test-Work-Order-Costs-V3.rpt
I would like to get a combination of the cross tab(s) information summed into one cross tab if possible
so for example headings/Example
Cost Center Description Period A Period B Period C YTD
12345 Text A 10 25 15 50
The period costs would be a comination of Labour Parts and Purchases from the sub report cross tabs
Have attached the report for information
Is it possible?
Gordon
test-Work-Order-Costs-V3.rpt
Hello,
I'm creating a Job Bag for production where I need to calculate the number of sheets to be printed by the digital machines. I'm struggling when the Job contains several parts within the job. It seems to be adding all the part values instead of just the single part with several versions. (yes, it can become very complicated!!!)
So the following works for single part - single version jobs:
IF {rep_v_Impress_jobBag_Prin
IF ISNULL({rep_v_Impress_jobB
{rep_v_Impress_jobBag_Prin
ELSE (SUM ({rep_v_Impress_jobBag_Pri
ELSE 0
See attached more detail....
Any help would be appreciated.
PS: I only started creating Crystal Reports and followed only the basic course, so still new to all of this!!
Thanks,
GVD
Crytal-Job-Bag-issue.docx
I'm creating a Job Bag for production where I need to calculate the number of sheets to be printed by the digital machines. I'm struggling when the Job contains several parts within the job. It seems to be adding all the part values instead of just the single part with several versions. (yes, it can become very complicated!!!)
So the following works for single part - single version jobs:
IF {rep_v_Impress_jobBag_Prin
IF ISNULL({rep_v_Impress_jobB
{rep_v_Impress_jobBag_Prin
ELSE (SUM ({rep_v_Impress_jobBag_Pri
ELSE 0
See attached more detail....
Any help would be appreciated.
PS: I only started creating Crystal Reports and followed only the basic course, so still new to all of this!!
Thanks,
GVD
Crytal-Job-Bag-issue.docx
Hi. I created an ODBC connection on my crystal reports server, which is also a SQL-Express server, to a database on a different SQL server on my network. The connection tested successful in DSN config. I created a new report in Crystal Reports though and my new connection wasn't visible in the ODBC connection type. Both servers are running SQL 2012. What am I missing? Should I use OLE DB connection instead of ODBC? I do have roughly 10 or 12 other local ODBC connections setup on my crystal server for reporting purposes if that makes any difference. Crystal version is developer edition 11.5. thanks
I have 50+ Views in SQL server and while connecting to the same server via Crystal Reports, I can only see top 12 Views (the top 12 that names start with letter "A").
How can I see all Views?
How can I see all Views?
Crystal Reports
34K
Solutions
5
Articles & Videos
14K
Contributors
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
Top Experts In
Crystal Reports
