Search results for query: *

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.

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

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...

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 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 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.

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...

I have a vb program using crystal report. In my program, let say I have below data: A buy 2 Part1 from X. B buy 3 Part2 from Y. C buy 3 Part3 from Z. B buy 2 Part1 from X. C buy 1 Part2 from Y. B buy 1 Part3 from Z. A buy 2 Part4 from Z. The report will show something like this group by...

How to print a crystal report from datagrid in VB project?? Anyone pls help...

I have create an application using VB and Microsoft SQL. I want to transfer data from VB/SQL to Excel format. How can I format the Excel spreadsheet via VB? Please help me to solve this problem. Thanks.

i wish to shrink the section height in crystal report automatically. let say in Details section, the fields may be have many lines and also one line. the height will automatically fixed base on the length of the fields. so, what should i do?

I have registered a new SQL server in my Enterprise Manager. But the icon doesn't the status of the server (either start, pause or stop). I tried to transfer data from that server to my local server, but failed. Anyone please help me on this. Thanks.