I’m not an expert by any means but I write SQL queries fairly regularly. I am pulling data via Crystal Reports 2013 from SQL Server 2016 (not positive about the version). Just as an aside, CR permits parameters so that’s what {?DateStart} is. {?DateStart} and {?DateEnd} are regular dates, {?Servic…
Tag: crystal-reports
Calculated query with parameters in HANA/CrystalReports
I’m having trouble trying to explain my necessity, so I’ll describe the scenario. Scenario: Product A has a maximum production of 125KG at a time. The operator received a production order of 1027,5KG of product A. The operator have to calculate how many rounds he’ll have to manufacture and a…
Problem with connecting Crystal Reports to SQL Server
I have a problem I am a project worker vb.net 2015 with sql After I cleared the project and tried the project at the client An error appears when the reports are shown by the crystal Report whereas mserver = server mdb = the name of the database muser = username sql mpass = sql password They are retrieved fro…
Is it possible to use OR in a table link rather than AND
I have created a WorkFlowForm to allow logistical personal to combine multiple picknotes on one set of despatch paperwork. The WFF has all the header information and should pull through all the …
Convert char var to integer for use in join
I am trying to get a report to run through crystal using our postgres databse. My SQL looks like SELECT slcnote.note_date, slcnote.account, customer.name, slcnote.reference, …
DB2 Crystal Reports Declare/Set Variable
I am using Crystal Reports to pull data from DB2 10.5. I need to calculate a specific date and then use this calculated date as a filter. Here is an example of how I am currently achieving this. WITH …
SBO tables Relationship (AR INVOICE-INCOMING Payment)
am making a query that bring Incoming Payments details , that include payment means , details of payment means , and then some UDFS from the related A/R invoice(s) , in addition to some UDF from an object that relate to a UDF in the AR INVOICE , now every time am running my query it show no result. Am
Running Oracle SQL query over several dates
Within Crystal Reports, I’m using the following query (against an Oracle database) to generate data for a single field in a report: This works fine and returns a single integer value, based on the {?HB_As_At_Date} supplied (The {?} syntax is Crystal’s way of embedding parameter values into SQL). T…
ODBC error – SQL0104 – Token = was not vaild. Valid tokens: ( + – ? : DAY INF NAN RID ROW – Crystal report error in windows 7 machine
Our client have been using several crystal reports for many years in the windows XP machines and I am responsible for supporting these reports. It was working perfectly fine. Recently we have upgraded to windows 7 machine and one of the crystal report stopped functioning wherheas other crystal reports works c…