Convert formula result string to number
My formula produces a string. I want to convert it to a number. Can’t use tonumber(@formula).
Answer Question
| February 15, 2013 7:38 PM
Crystal Reports 2008, Crystal Reports formulas
My formula produces a string. I want to convert it to a number. Can’t use tonumber(@formula).
Answer Question
| February 15, 2013 7:38 PM
Crystal Reports 2008, Crystal Reports formulas
Google Earth Activation
I have “Google Earth” downloaded and installed on my system BUT when I go to open it my computer takes on amind of its own and goes ape. First off the picture changes to black then comes back with a kind of “negative” (as in photography) look. Everything is blue in color, larger and lumpy [...]
Answer Question
| February 13, 2013 4:26 PM
Google Earth
I have “Google Earth” downloaded and installed on my system BUT when I go to open it my computer takes on amind of its own and goes ape. First off the picture changes to black then comes back with a kind of “negative” (as in photography) look. Everything is blue in color, larger and lumpy [...]
Answer Question
| February 13, 2013 4:26 PM
Google Earth
What strategies do you see your company using to make data analytics quicker?
The research company Gartner recently identified three trends business intelligence professionals should consider: Greater transparency, real-time tracking and automation. Which strategies do you see your company using to make data analytics quicker and more efficient?
Answer Question
| February 19, 2013 7:00 PM
Analytics, Business Intelligence
The research company Gartner recently identified three trends business intelligence professionals should consider: Greater transparency, real-time tracking and automation. Which strategies do you see your company using to make data analytics quicker and more efficient?
Answer Question
| February 19, 2013 7:00 PM
Analytics, Business Intelligence
Crystal Reports
I am trying to filter sales by the date of sale and having a whale of a time. I have a few years worth of sales data, but just want to see what was sold on a specific data Saturday for instance. Looking for any formula help for Crystal Reports.
Answer Question
| February 6, 2013 12:03 PM
Crystal Reports, Crystal Reports formulas
I am trying to filter sales by the date of sale and having a whale of a time. I have a few years worth of sales data, but just want to see what was sold on a specific data Saturday for instance. Looking for any formula help for Crystal Reports.
Answer Question
| February 6, 2013 12:03 PM
Crystal Reports, Crystal Reports formulas
Data transfer between databases
Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic [...]
Answer Question
| February 4, 2013 8:29 AM
Data transfer, Databases
Hi, I need to transfer data from one database to another, whenever a table in the first database get inserted with a value from UI. Can somebody explain me way to do this (Both databases are not identical). I have an idea like selecting required row data from first table and putting it in generic [...]
Answer Question
| February 4, 2013 8:29 AM
Data transfer, Databases
How to suppress page header when a specific section prints
I have a report that basically is a letter and only contains data for one record. The report contains multiple subreports which print records that are related to the single record in the main report. The last subreport is in Detail Section 11. This subreport is setup to start each record on a new page. [...]
Answer Question
| February 1, 2013 1:33 PM
Crystal Reports, VS 2010
I have a report that basically is a letter and only contains data for one record. The report contains multiple subreports which print records that are related to the single record in the main report. The last subreport is in Detail Section 11. This subreport is setup to start each record on a new page. [...]
Answer Question
| February 1, 2013 1:33 PM
Crystal Reports, VS 2010
Examples of AS/400 create alias in Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Reporting period
Need help to create 12-month running total by customer_id which include the following: 1. MonthlyTotal 2. Monthly Percentage, 3. Previous Month total, 3. YTD 4 . YTD Percentage Below is an example of what I am trying to accomplish. Within the example there are customer_id , 24 and 25. Each row of data represents one [...]
Answer Question
| January 28, 2013 12:52 PM
SAS, SAS 9.2
Need help to create 12-month running total by customer_id which include the following: 1. MonthlyTotal 2. Monthly Percentage, 3. Previous Month total, 3. YTD 4 . YTD Percentage Below is an example of what I am trying to accomplish. Within the example there are customer_id , 24 and 25. Each row of data represents one [...]
Answer Question
| January 28, 2013 12:52 PM
SAS, SAS 9.2
Statistics and Business Intelligence.
Hello everyone, I’m still a student and I’m very interested in the BI field. But I have an important question. I would like to know if it’s crucial to know well about statistics like the R programming language as I know it’s widely used by the person who works in data mining and data analytics. [...]
Answer Question
| January 23, 2013 8:21 PM
Business Intelligence, R language, statistics
Hello everyone, I’m still a student and I’m very interested in the BI field. But I have an important question. I would like to know if it’s crucial to know well about statistics like the R programming language as I know it’s widely used by the person who works in data mining and data analytics. [...]
Answer Question
| January 23, 2013 8:21 PM
Business Intelligence, R language, statistics
Statistics (R programming language) and Business Intelligence
Hello everyone, I’m still a student and I’m very interested in the BI field. But I have an important question. I would like to know if it’s crucial to know well about statistics like the R programming language as I know it’s widely used by the person who works in data mining and data analytics. [...]
Answer Question
| January 23, 2013 5:48 AM
Business Intelligence, R language, statistics
Hello everyone, I’m still a student and I’m very interested in the BI field. But I have an important question. I would like to know if it’s crucial to know well about statistics like the R programming language as I know it’s widely used by the person who works in data mining and data analytics. [...]
Answer Question
| January 23, 2013 5:48 AM
Business Intelligence, R language, statistics
Add text with pictures in a report
We have embedded pictures inside a memo field and want to add these pictures into a report. If possible, how can we implement this?
Answer Question
| January 21, 2013 7:33 AM
Crystal Report, Crystal Reports fields
We have embedded pictures inside a memo field and want to add these pictures into a report. If possible, how can we implement this?
Answer Question
| January 21, 2013 7:33 AM
Crystal Report, Crystal Reports fields
EDI incrmentation
How to increment the second element of the REF segment by one for each occurrence in an 813 mapping version 4010?
Answer Question
| January 21, 2013 7:20 PM
EDI, Gentran, Gentran Server
How to increment the second element of the REF segment by one for each occurrence in an 813 mapping version 4010?
Answer Question
| January 21, 2013 7:20 PM
EDI, Gentran, Gentran Server
The use of 19000KB of data
What is being viewed that uses over 19000 KB of data?
Answer Question
| January 16, 2013 9:00 PM
Data, Data usage
What is being viewed that uses over 19000 KB of data?
Answer Question
| January 16, 2013 9:00 PM
Data, Data usage
DXF issues
AutoCAD seems to be turning arcs into straight lines when I export and import a DXF file? I’m running a CNC drag knife machine and my part is being affected by this. Any ideas? It happens in old and new ACAD versions
Answer Question
| January 14, 2013 9:49 PM
AutoCAD, DXF files
AutoCAD seems to be turning arcs into straight lines when I export and import a DXF file? I’m running a CNC drag knife machine and my part is being affected by this. Any ideas? It happens in old and new ACAD versions
Answer Question
| January 14, 2013 9:49 PM
AutoCAD, DXF files
Crystal Reports Crash
When accessing a Crystal report from her laptop it crashes. She accesses from any other workstation on the network and it opens right up. She receives error code (-2147206463)
Answer Question
| January 11, 2013 7:41 PM
Crystal Report, Crystal Report error messages
When accessing a Crystal report from her laptop it crashes. She accesses from any other workstation on the network and it opens right up. She receives error code (-2147206463)
Answer Question
| January 11, 2013 7:41 PM
Crystal Report, Crystal Report error messages
Need to identify the next sequence of number in a character field in DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]
Answer Question
| December 18, 2012 7:34 AM
AS/400 V6r1m0, DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]
Answer Question
| December 18, 2012 7:34 AM
AS/400 V6r1m0, DB2
QR Code barcodes in .NET
How could I generate barcodes not in black and white, but still it could be scanned, it this possible?
Answer Question
| December 17, 2012 3:58 AM
.NET, Barcode
How could I generate barcodes not in black and white, but still it could be scanned, it this possible?
Answer Question
| December 17, 2012 3:58 AM
.NET, Barcode
pb exe runtime eror – does not connect to db2 database from client machine
I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on the [...]
Answer Question
| December 13, 2012 11:19 AM
DB2, pb9
I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on the [...]
Answer Question
| December 13, 2012 11:19 AM
DB2, pb9
Application of SAS programming
Please help me with my question, Is SAS Programming is applicable in Broking companies? and if yes can you tell me how and also the name of companies.
Answer Question
| December 12, 2012 8:29 AM
SAS, SAS Business Intelligence software
Please help me with my question, Is SAS Programming is applicable in Broking companies? and if yes can you tell me how and also the name of companies.
Answer Question
| December 12, 2012 8:29 AM
SAS, SAS Business Intelligence software
DOB ISNULL
I need help writing a formula to show 00/00/0000 when dob isnull else dob Thanks!
Answer Question
| December 11, 2012 7:54 PM
Crystal Report
I need help writing a formula to show 00/00/0000 when dob isnull else dob Thanks!
Answer Question
| December 11, 2012 7:54 PM
Crystal Report
