Search results for query: *

Hi there, I am not sure if this is the correct forum, if not please guide me to the right one. I am new to using Visual Studio. I have created a website using Visual Studio 2008 using VB as the code. The website connected to a SQL Database and I was using an SqlDataSource to connect from...

Hi there, What I am trying to do I think is simple but have come acccross a bit of a block ... any help would be appreciated. I have column A which will have values between 1-70 Then I need to populate column B If the value in Column A is between 1 - 9 - then Column B must say 'None' If the...

Hi Everyone, I am not sure if this is the right forum but I will post it here and see. I have a VS2008 Gridview, above the Gridview I have a Dropdown Control which filters the data in the GridView for the selected Year. Attachted to this Gridview I have a Crystal report with similar data of...

Hi there, I need to do a count on Column B however I need the count to reset if Column A changes Column A Column B Count Formula result 1 2 1 1 3 2 1 5 3 2 2 1 2...

Hi, I have a simple question, I think. I have a pivot table which has a few rows and many columns. Each Column has a total. All I want to do is say, if the Column Total = 0 hide the column. Help on this would be much appreciated. Regards Thomas

Hi there, I am using CRXI and SQL I have a report that is group by an event type i.e National International Exhibition Government etc I have writen the report and it works fine. Then I go into the application, change the Event type from National to International as it was entered...

Hello, I have just loaded Crystal 11 on my PC and when opening a report and I select a field I don't get a highlighted box around the selected box. This makes things a little more tricky when trying to change the sizes of boxes and moving things around. I have loaded it on another PC and I...

Hello Guys and Girls, I have a Win2k box with 2 network cards. Card 1 Network settings IP 192.168.0.4 Subnet 255.255.255.0 Gateway 192.168.0.1 Card 2 Network Settings IP 169.254.188.97 Subnet 255.255.255.254 Gateway None Card 1 works 100% and I have no issues. Card 2 network...

Hello Folks, I am battling to get a formula right. Below is an example of my table Demographics Switzerland France Netherlands Population 7,489,370 60,656,178 16,407,491 Aged 15-64 5,092,909 39,537,181 11,118,809 Unemployment 3.40% 10.10% 6% Official Languages...

Hello Guys, I have a Coloumn with Rates in US$ and I need to show the price in Rands. so what I want to do is make a cell the exchange rate, then have a formula in a column. But when I drag the formula I cannot get the second half of the formula to stay constant on hte one cell. Basically...

Hello There, I have two worksheets in the same excel document. Worksheet 1: 1 4 2 8 3 2 4 5 5 3 Worksheet 2: 3 2 3 5 2 2 5 8 Now I need to join\sort\merge these two worksheets on a third...

Hi There, I don't know if this is the correct forum for this. I am looking for a little app. I don't know if there is such a thing around but I can't seem to find any. What it must do is if I log on as Administrator I want to be able to go to the User Profiles and put a timer on the normal...

Hello All I am having a small problem. I have na Exchange Server sitting at Head Office. I then have several other Exchange servers sitting at other sites around the country. These are all local to the site at which they are at, the mail boxes is not stored at Head Ofice at all. I need to...

Hello All I would like to know how to suppress a group header if the information in the Details of group footer have been supressed. i.e. I have orders, broken down into departments. if the line item has bene given free of charge it gets supressed. If all order prices are zero the group...

Hello All, I just have a quick question with regard to Default Parameter Settings. I am using Crystal 9 and I set up default parameter values for Sales Executives and a Sales Person leaves or a new one joins and I have to go and edit the Default Values manually. From what I have been toldis...

Hello All, I wanted to have a quick look at my SQL Server this morning to check why my Scheduled Backups weren't going through and when going into Enterprise Manager there are NO Databases. It shows "No Items" If I go into the Query Analyzer everything works fine and the software using the...

Hi, I need to group on a formula, basically my columns look like: EvtID FuncID Seq Lvl ParentID Desc 1234 110 1 1 0 Space & Charges 1234 120 1 1 0 Friday 2005\01\05 1234 122 3 1 0 Saturday 2005\01\06 1234...

Hi there folks, I am trying to change the width of my Border. If I right click on my Text Box, Format Objects and go to Border. I want a single line, my border colour has a formula to it which works fine, but when I try to print the report the border colour is very thin. Is there any way if...

Hello Folks, I am working in the Event Industry and am having a problem with one of the reports. This is what is happening: Start Date End Date Event Name Venue 1 June 2004 5 June 2004 Great Event Hall 1 1 June 2004 5 June 2004 Great Event Hall 2 1 June...

Hi there folks I have an application and I can export the client details to excel and in a row I have all the telephone numbers. They have no spaces: +27211234567 +27217896543 +27833698521 +27112587413 Now what I need to do is count the lenghth, if the length = 12 and starts with +27 then...