Recent content by ThomasBrown

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

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

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

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

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

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

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

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