Search results for query: *

Hi All, Sorry the SUMIF I am trying to get to work would Count units that only have an owner type of Company. ie. SUMIF('Owner Type',"Company",'Units Count')

Hi All, I am trying to get a SUMIF formula to work in as a pivot table calculated field on the right side of the units working column, but it does not seem to be working correctly: Pivot Table Territory Units Count Units Working ------------------------------------------- Central...

Hi All, We are currently developing in application in C# using Visual Studio 2005. It is a web-based application and uses a few .css stylesheets. One (of five) developers cannot see the .css images when he runs his browser. All other developers (using different machines) see everything...

Hi All, I am currently developing an application in Visual Studios 2005 that uses reports constructed in CR XI release 2. For some reason the reports seem to hang(completely stop loading) during the load() method. Here is my code: private void ConfigurePPCReport() {...

Hi All, I have a numeric field in my report ("CurrentQuantity"), is there a way to check if the field is empty? Also, Is there a way to suppress the first row in the details section? Thanks,

Hi All, I am using Crystal Reports 11 and need to retrieve a previous group summary. I have the first group "Parts" and a second group "Invoices". I need to present the Amounts for the current invoice and the previous invoice so they can be compared: Previous Amount...

Does anyone know of a way to solve this problem? Can I provide any more information to better assist you? Thanks, Kyle

Hi, I am using CrystalReportsViewer and yes, I am serving the RPT to the website. I am currently binding the report to the source on page_load. Previously I was setting the source with CrystalReportSource and the image seemed to display without any problems, but due to the nature of the...

Hi All, I am currently using Visual Studios 2005 and Crystal Reports XI. I have an image as my report header (company logo) and it display fine during development but as soon as I run the website the image is no longer displayed on the report. Please let me know if I can post any code or...

Thank you Jason! I changed the code to add the current values as suggested above. As well, I introduced a report document to bind the report to everytime i configure the report. This forces the report to refresh. Thanks again.

Hi All, I am currently passing parameters (all blank strings right now except Offices to a Crystal Reports Viewer. The Crystal Reports Viewer will not refresh or even recognize that anything has changed. I am currently using VS 2005 and here is my code: using System; using System.Data; using...

Hi All, I have been recieving a null pointer exception (SOAP Exception) from a web service I am calling that returns a complete dataset. Here is the web service: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Linq; using System.Web; using...

Hi All, I have encountered another tough task. I must create a report that has three base columns and then two columns for every contractor. Example of what i need to do: Contractor 1 Contractor 2 Part Spec Description Price Amount Price Amount 1 v...

Thanks guys, I used the running total approach and it worked great.

Hi All, I am currently completing a Crystal Report in Crystal Reports 11. The report displays many different items which are grouped in sections. What i need is to display the detail line number, but to reset it after each section. Let me know if you require any more details. thanks, Tony

Hello All, We have setup a custom role provider that uses a web service to access our db and retrieve roles. However, we are recieving a 401.2 error when multiple users are on the site. Could this be caused by an incorrect role provider?

Hi all, I am using this code to pull in data from multiple excel spreadsheets, I am fairly new to SQL and have never pulled data from excel files before. The code here works (may not be efficient or secure, but in this case it does not need to be) but I have pull in the row number from the...

Ok, I am now using: EXEC master..xp_cmdshell 'DIR C:\current\*.xls /b' but now it is returning one null row. Also, this code is going to be in an SQL stored procedure where i want to capture all of the file names in that folder. Thanks again.

Hi Everyone, I am using the cmdshell tool to try to pull in the filenames of all excel files in a directory. My code is as follows: Declare @Files Table ([File] varchar(250) null) INSERT @Files ([File]) EXEC master..xp_cmdshell 'DIR C:\current\*.xls' For some reason it also brings in...

Hi, Is there anyway to code around it in a web based application? Thanks,