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?

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

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

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

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

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?

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

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

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

In MSSQLServer i have a table of sales: customer dateofsale checknumber --------------------------------- Jon ....... 1 Jon ....... 2 Bill ....... 7 Bill ....... 8 Jon ....... 3 Jon ....... 22 Bill...

How can I show connection properties (ServerName,UserName) in the report. I'm using CR9, MSSQLServer, OLE DB

Sometimes I have only few records on the page. How can I print page footer after those records, not at the bottom of the page? Thanks for help!

I have a table of sales. The main report has two parameter fields ( date range and department name) and a subreport has one parameter (saleID). How can i pass to subreport all saleID's of all records selected in the main report.

I have two tables in MSSQLServer: Sales saleID Customer Pay currencyID SaleDate and Currency CurrencyID CurrencyName The report have to look like (PH) SaleDate| Customer| CurrencyName1| CurrencyName2| CurrencyName3| ... (Details) Date |Customer |AmountPayedinthisCurrency|...