Search results for query: *

Having a syntax error and can someone help? select imtpartid, imtCreatedDate from parttransactions where imtpartid = 'XYZ' and imtpartrevisionid = 'A' and (case imtsource when 9 then (imtCreatedDate = (select max(A.imtCreatedDate) from parttransactions A where A.imtpartid =...

Wondering how to sort a string field to put them in the order of sequence. the field follows following format. XXYY-ZZZZ where XX - last two digits of Year YY - two digits of month. ZZZZ - numeric sequence. Example data. (in this 900 sequence to bring in before 1000). 1409‑1154 1409‑1212...

We've an ERP application built on SQL 2008 Database. We've peculiar issue with our database in one aspect. We've configured to use Average cost as our inventory costing method. Sometimes part issue to job / sales order transactions take last receipt unit cost as against an average unit cost...

Wondering anyone could help me with this. I don't have any problem without condition but If I put If then Else condition then I'm getting syntax error. Simple value: App.GetYear(Date(),"GL") - no problem with this input. Conditional VAlue: (If App.GetPeriod(Date(),"GL")-1 = 0 Then...

Wondering whether anyone can help me understanding the page skip problem that I'm acing. I've a sub report in one of the detail sections. the report print everything fine except where there is no data concerning the table of the sub report. if there is no data then that section should suppress...

Attached example show Assembly A is linked to Part materials B and in turn to C and D. The reason only A – B – C – D are in importance are because they are either track serial number or track lot number on the part record. When the transaction get complete with job we would have recorded serial...

PartID: XYZ rev:1 Custom memo field data: - Hydraulically controlled hose reels - Hydraulic tank: 43 US Gal - Fuel tank: 22 US Gal - Single Point Lift with 7 1/2" x 3 1/2" ID Forklift Pockets - 2" x 2" reinforced square tubular frame - Floor pan with 2"...

I've a column in my data source with lot of duplications. I do have two columns put under group option. One need a maximum value and other need sum of all those maximum values. I can get first one by placing formula field as shown below, but don't know how to put the other one using the first...

I've a situation where I've a sub report defined by ttx with SQL script file. then I likned sub report with main report with a correct and relavent field. To some reason Crystal is not at all executing SQL script. I figured out this by defining some garbage in SQL script and expected errors...

I've a crystal report that need to show summary by division except one division which would need to be merged with one of the other divisions. The logic to share the merger is as follows. First 3 digits have Division code and the rest 8 digits have common account codes. When it comes to MAI...

I've interesting scenario where a summary is required by division except one division which need to shared with other division. An example data is shown below. MAI need to be split with other divisions whereever the numberic number matches with other parts of the codes. Hope this claries. Should...

Can anyone suggest what's wrong with this SQL code? Select imrpartid, imrpartrevisionid from partrevisions inner join ( Select imrpartid, imrpartrevisionid, count (*) as cnt from partrevisions where imreffectiveenddate is null group by partrevisions.imrpartid,partrevisions.imrpartrevisionid)...

I've a scenario where I need summary by account group. here are two tables that I need to connect. 1) journallines having fields glaccountid and amount 2) accountgroup having fields groupid, glaccountidm, glaccountidl and glaccountidoh (m-material, l-labour and oh-overhead) journallines can...

I've a scenario where I need summary by account group. here are two tables that I need to connect. 1) journallines having fields glaccountid and amount 2) accountgroup having fields groupid, glaccountidm, glaccountidl and glaccountidoh (m-material, l-labour and oh-overhead) journallines can have...

I used MS excel data source along with SQL data souruce. After I added excel data file, I'm unable to execute the crystal report. I'm getting error: Logon Failed. Error number - 2147189176. Any idea where this is failing? for your information, If I use only excel data file as source ina blank...

I wanted to print sub report information into multiple columns. for eaxmple: 1234-233 1323-234 1234-211 1223-122 3233-322 3443-232 I selcted on sub report details sections (section expert)format with multiple columns, then on layout tab, I defined width and height and selected printing...

I've below SQL join expression and would like to have one more additional calculted field involving two of the tables: SALESORDERLINES left outer join salesorders on omlsalesorderid = ompsalesorderid Left Outer JOIN (select smlsalesorderid, smlsalesorderlineid, max(smlshipmentid) as shipid...

A report is structured as Main report withing that thre is a sub report. One main report may have multiple subreports. A sub report has a sum field. If I were to get grand total of all those sum fields from sub reports, where and how should I define a shared variable? Hope I explaind my question...

I've used Record filter on one of the feild. I can see the result in Preview tab. However, when I run the report from application, I'm unable to get the output. I end up following error message. Failed to retrieve data from database. Details: (Dataabse Vendor code 208) Appreciate any response...

I'm using following code to to find out missing sequence in part transactiion ID from a table parttransactions anything above 6000000. To some reason when I execute this code I don't get any result but I get message says "Query has finished processing" . Any advice what I'm missing? declare...