Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ThomasBrown

    Changing SqlDataSource

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

    Populate one cell with words depending on the value of another cell

    Hi All, It came back to me and I have done it. The formula looks like this: =IF(D6<10,"None",IF(D6<20,"Poor",IF(D6<35,"Average",""))) Regards Thomas
  3. ThomasBrown

    Populate one cell with words depending on the value of another cell

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

    Passing Parameters from VS2008

    Hi MzKitty, Its not passing it form the viewer to teh report where I am having problems. The issue is passing from a dropdown field (created in Visual Studio on a webpage) and making this the parameter field within the report, if this makes sense. Any ideas? Thomas
  5. ThomasBrown

    Excel Count reset

    Awesome, thank you guys, this has sorted it out.
  6. ThomasBrown

    Passing Parameters from VS2008

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

    Excel Count reset

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

    Pivot Table filtering

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

    Report not updating right

    Hi, I have found what was wrong, but it is still not doing what it should do. It was indeed looking at an old testing database. What is odd and I don't know what is causing this is if I go to Database --> Set Database Location ... Create new DB Connection and Update on the database I'm using...
  10. ThomasBrown

    Report not updating right

    Hi synapsevampire I get the same result if I run it through the application or through Crystal itself. I am pointing to the right database as well. As I said, I run the report for the first time, its fine, change data through the application. run the report again through crystal, it doesn't...
  11. ThomasBrown

    Report not updating right

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

    Highlighting of any field box

    Thanks, htat has sorted out the problem, now at least I can work a little faster.
  13. ThomasBrown

    Highlighting of any field box

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

    Networking Problem

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

    Excel Formula

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

    Simple Formula - Brains gone fuzzy

    Thank you guys, all fixed up
  17. ThomasBrown

    Simple Formula - Brains gone fuzzy

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

    Excel - Data Merge \ Sort

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

    Timer on a User Profile - Stand Alone PC

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

    Outlook Web Access Issue

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

Part and Inventory Search

Back
Top