Recent content by kuekue

Ok. Thank you Ian. i got the idea i create complex report then i forgot this solution. ;) Many Many Thanks. :)

i use 'visible records' in detail / section expert / paging , that has in crystal report version 2008 then i save it and open in crystal report 10. this function still work. but it function on version 2008. i save again in version 10, this function still come to and worked. but i cannot know...

i use 'visible records' in detail / section expert / paging , that has in crystal report version 2008 then i save it and open in crystal report 10. this function still work. but it function on version 2008. i save again in version 10, this function still come to and worked. but i cannot know...

no one answer me. OK. i can solve this. 1. i query with SQL for average. 2. i create view to merge average value. 3. i use crystal report to generate cross-tab and graph. Thanks.

Oh, i mistake picture in second link. Link

Hello everyone, i need to show cross tab with 2 average, data like this Link the point is, i need something like 'cross tab' to show data and chart then it 3 rows : ED_P_Max, Average all (ED_P_Point), Average only Ed_P_User_target (ED_P_Point) and column is : ED_P_Seq then when i create...

i think this -- If ({@Total Testers } <> 0 and {@Total Sales} <> 0) then ({@Total Testers}/{@Total Sales} * 100) else 0

and i search from internet someone advise to connect by SQL native client, you should to try it.

i found look like this problem too, my co-worker tell me set config to TCP/IP, co-worker check not have problem with windowsXP but windows7 have it. i check in config ODBC in windows XP it 'TCP/IP' (in client configuration of SQL Server Driver) and can choose windows authentication, but in...

i think your code it duplicate, why you check 'day' if today is 12 oct and birthdate is 12 apr it 'true' but when check 'month' it 'false' i think your code it hard to read and understand, if i do not misunderstand you, i adjust your code to.. ////////////////////// if Month...

I want to know keyboard shortcut on crystal report, for faster than click. exp. Alt+C : in formula for check syntax in formula. i want decrease size font (or increase), insert summary and else. Thanks.

try to put this formula in 'formula - suppress' ((table.value = "value1") OR (table.other ="value2"))

if you use windows authentications, you just connect to server by click start/run and enter a 'ip address' or 'computer name' and connect by some user had add a member of group SQL Server. my english not strong. try it.

i have not testing, but when i read it, i have a idea. create formula for check 'null' of year : if(isnull(year(currentyear))) then 0 else 1 : then grouping by this formula. try it and tell me again.

this problem i can resolve by calculate by my program and keep in temp database and then filter by Crystal Report.