Search results for query: *

OK. Thanks all. I will try to use flexgrid.

Dear johnwm, Is it means that I can't do the same thing in datagrid? It is better if I can get the datagrid works rather than flexgrid.

Hello all. I wish to display my data in different colors in datagrid. Let say I have data: Name, Age, Address. If age is more than 20 then display the record in blue color. Otherwise display it in red color. Anyone please help on this. Thanks.

thanks all. i have tried using chris method and it works. thanks for all the tips.

Hi. I wish to insert some symbols into my Excel like smile face, a tick, etc. How can I do that?

Thanks IdoMillet. Now the program runs without any errors.

Hi. I wish to pass a string to a formula in Crystal Report 7 from my VB project. I have created a formula in crystal report named Description. In my vb, I have the below code, rpt.Formulas(1) = "Description='" & str & "'" where str is the string containing text and...

Yaap. I solved it already. I just changed the Network Libraries to Named Pipes in the DSN Client Configuration. Everything works smooth now. Thanks all.

Hi. I'm using Windows 98(client) to connect to my Microsoft SQL server in Windows NT platform(server). The client side doing well in data accessing from the server. So I assumed that there was no error on the connection. But when i try to retrive data ftom the SQL server, it failed. I have...

I have tried the below codes but it also didn't show the complete subreport. Report1.ReportFileName = App.Path & "\Main.rpt" Report1.SetTablePrivateData 0, 3, rsMain Report2.ReportFileName = App.Path & "\Sub.rpt" Report2.SetTablePrivateData 0, 3, rsSub Report1.Action = 1...

I have tried to put data from one table in the main report. I created one subreport by using data from another table and insert into main report. But the result didn't show the subreport details. I used the following codes in my VB program: Report.ReportFileName = App.Path &...

I wish to display data from 2 tables in the Details section. The sequence will be: 1. Show all data from table 1 first. 2. After that show all data from table 2. How can I do this??

hi. let say i have 3 tables. i want to select records from table1 which quantity is more than records' quantity either in table2 or table3. Ex. 3 tables have the same key columns: Code. if Code is in table2, then it will retrieve the data from table2. Else, it will retrieve data from table3. is...

how can i put the grand total in every page(page footer)? i tried to use above formulas but failed. the report only show me the running total.

thanks lb. i saw my problems. i forgot to place reset on the page header. thanks for your helps.

ok. now the query run properly. thanks all.

How can I display the subtotal on the page footer?? I have tried to drag it from the report footer but the system not allow me to do this.

Oops... I think I have done a mistake. This query only show the those Codes which inside T2. Those inside T1 but not in T2 not appear. So, do you have any ideas??

thanks plantj. now i can get the data already.

Hi. I have 3 tables in SQL: T1, T2, T3. I wish to display data from T1 where the quantity is more than quantity in T2 but not in T3. I used below query but it doesn't return any result. SELECT Code, Desc FROM T1 LEFT JOIN T2 ON T1.Code = T2.Code WHERE T1.Qty > T2.Qty AND T1.Code NOT IN...