Search results for query: *

Everytime I want to edit data in my Pivot Table I get this message: "Cannot change this part of a PivotTable". How can I allow to edit data field values in a Pivot Table using VBA?

This code ThisWorkbook.Worksheets("Sheet1").Cells(1, 101).Formula = "=SUMIF(A1:A100,"">0"")" works. Thanks for help.

ThisWorkbook.Worksheets("Sheet1").Cells(1, 101).Formula = "=SUMIF(A1:A100;"">0"")" Returns the same error :(

I need to sum all positive values in column A on Sheet1.Typing =Sumif(A1:A100;">0") in Formula Bar gives an expected result. But the code Sub tst() ThisWorkbook.Worksheets("Sheet1").Cells(1, 101).Value = "=SUMIF(A1:A100;"">0"")" End Sub returns an "Application-defined or object-defined...

I'd like to ask user to pick some values from comboboxes to pass this values as parameters to stored procedures on SQL Server. The problem is that the values in comboboxes should be taken from SQL server database. Should I create a number of ADO Recordests and pass them to comboboxes before...

2 tjax111: Suppose I have found a solution. This problem occurs when an ATL.dll is missing. The correct version of ATL.dll can be found and registered on the client computer using one of these 3 methods: 1. Install Microsoft Internet Explorer 6 on the client computer. 2. Manually copy and...

I've made a setup package with Wise for Windows Installer to install all required runtime dll's. I've downloaded Crystal Reports merge modules and added them to the package. The installation works fine on Win2000, but on Win98 (suppose on Win95/Me as well) it cannot register some dll's showing...

That's what I need. Thanks for help!

I have an SQL database with two tables Organization (OrgID OrgName) and Sale (OrgID SaleDate). Tables are linked by OrgID. The report i've created in CR 9 shows organization and the number of sales for this organzation. Report has a paramter field {?MinSaleCount} and I want to show...

2 SQLBill: and what is your system datetime format? This error occurs when system datetime format differs from "dd.mm.yyyy hh:mm:ss

Hi all! I'm using CR9 and MS SQL Server. My report has two string parameter fields {?DateBegin} and {?DateEnd}. Parametrs are passed as strings with default format("dd.mm.yyyy hh:mm:ss"). When parameters are passed to a report I try to convert them to datetime (datetime function) and to pass to...

2pgtek: Thanks for advice, but i'd like to show if there is no data in report in VB application and not to show report at all.

I'm using CR9. Reports are viewed trough VB application. How could I know there is no data in report? If there is no data, i'd like to show some messagebox from VB application and not to print the report. Is it possible? Thanks for help.

I've created a report using CR9. Option "Save data with report" is off. User opens a report in VB application. Is it possible to set option "Save data with report" on at runtime?

Try to use response (or response to response) forms

I have a database mydb.nsf in LotusNotes 5. In this application I want to open a report. Report is made in CrystalReports and connects to mydb.nsf trough NOtesSQL. When I try to open report I see a message "This database is currently being used by someone else. In order to share a Notes...

I'm using CR9 and MS SQL SERVER (OLEDB). I have two tables Countries and Sales. Countries: ID | Name 1 USA 2 GB 3 France 4 WestSamoa ...... Sales: SaleId | Customer | CustomerCountryID 1 aaa 1 2 aaa 1 3 bbb 3...

Mike, Thanks for solution!

I've created some reports. They're launched from Lotus Notes database. Is it possible to pass an array of values from Lotus Script to one parameter field in report (and what type of parameter field it should be)? I've tried this script, but it doesn't work: Sub Postopen(Source As...

I've made some reports, they connect to MSSQL Server trough OLEDB/ADO. Reports are viewed from LotusNotes Application. Everything works fine , but when I try to connect to other database (with the same structure) on the same server or on other server report takes data from olddatabase. How can...