Recent content by smain

I have two pie charts, each with identical values. The charts represent percent of total for each item. One chart is the system view, the other a specific district. I need to include a legend, but it looks odd having one on both charts. Any creative ideas?

Haikster - Thanks for the post. We minimized the ribbon and now the form works fine. Hopefully there will be a permanent fix for this type of problem.

Have you found a solution yet? We are experiencing the same problem, but only on the form view.

Thanks to both of you. Walid, the function works great.

I need to sort a varchar(10) field containing the following values... 1.7.1.3 12.15.1 1.5.3.2 1.1 1 5.1 5.10.3 5.1.3 into the following results... 1 1.1 1.5.3.2 1.7.1.3 5.1 5.1.3 5.10.3 12.15.1 The source table only has about 1,700 records, with 900+ uniqe values.

How can I clear logon credentials through IIS 5 (using basic authentication)? I've tried using an ActiveX control provided by Microsoft (Q195192) but ran into many problems. Any other suggestions?

Thank you. Your suggestion solved my problem. My initial syntax was "select cast(@x as float)," but when a value of 0.2 was passed, the result was 0.20000000000000001.

What is the best way to standardize a varchar(5) variable using the following rules - remove all trailing zeros to the right of the decimal point, remove any trailing decimal points, and remove all leading zeroes? Examples 5.00 = 5 0.20 = .2