Search results for query: *

Hi, Am using Crystal 10 and SQL Server. Each of my reports consist of 3 sub-reports. Problem at Hand How do I group YTD values and LYTD values line-by-line per month irrespective of the year? Current Report Structure: Group1 : ---> Shows overrall total Group2 : ---> shows sum of...

Hi Crystal Version: 10 Database: SQL Server. Am having a problem with my shared CurrencyVar Formulas. I have a main report, which summarises values from 7 subreports. The subreports pass data using shared CurrencyVar formulas. The sum of each group in the subreport is meant to be passed as...

Crystal Version: 10 Database: MsSQL server I have a main report which summarises values from 3 subreports(all subreports are in the report footer sections) Each of the subreports has a header in the Page Header section and this is displayed on each page (when i run the subreport alone) The...

Hi, Am using crystal 10 with SQL server 2000. My sequel view returns all the data i need for both current financial yr and Previous financial yr. (Date, AccountNo, AccountDesc, Amounts) The financial year spans Sept 2004 to August 2005, with reporting being sept 2004 to date Problem @ Hand...

Hi there, I need to make some financial statements (profit & loss + balance sheet); but am kinder stuck Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, AccountNo, AccountDesc, Amounts. (Data entry is done at...

Hi, I am kinder stuck with some crystal YTD formula, and now seeking help. Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a MS SQL server view to select the following data Date, Account No, Account Desc, Amounts Ps: Currently am using a record selection...

Hi there, I need to make some financial statements (profit & loss + balance sheet); but am kinder stuck Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, Account No, Account Desc, Amounts. The SQL view is able to...

Hi there, Am stuck with a major financial reports and need some technical assistance: Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, Account No, Account Desc, Amounts The SQL view is able to return both income...

Hi, Crystal Reports :11 (very similar to 10) Database: SQL Server am trying to load my reports from a Delphi App and when I run the form that's supposed to call my reports it gives the the following error: Error:104 Failed to obtain version information from CRPE32.DLL - getCrpeVersion Windows...

CRYSTAL VERSION: 8.5 DATABASE : SQL Server I have a report with 3 sub-reports and they are drill down reports. when i drill down on the report heading, it shows on a new preview page but without the report headings (only the drill-down data shows) (My report data-headings are currently in the...

Hi, Am rather new to Crystal and urgently need to do some data selection for financial reporting purposes. Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a Sequel view to select the following data Date, Account No, Account Desc, Amounts The SQL view is able...

Hi there, Am stuck with a major financial reports and need some technical assistance: Crystal version: 8.5 Database and connectivity: SQL Server Sample data: Am using a view to select the following data Account No, Account Desc, Amounts The SQL view is able to return both income amounts and...

How do i connect delphi with CR, without having to supply/ display the DB username & password explictly on the code (am using SQL server - windows authentication mode)? Am also using SQL server stored procedures - how do i supply the parameters of the SP on one form, execute (run the report)...

Am very very new to delphi and am currently trying to make a simple app. I need to have an autogenerated client identification number that will automatically increment on every new record.(more like an auto-generated index ) I have no idea how to do this. Also how do i code for my menu items...

How do i display numerical (esp. monetary figures)input as digit grouped input and still derive the actual value while posting to a database i.e ONE MILLION = 1,000,000 yet post to the db 1000000. Also how do i write a function that can clear out all input contents in a form (editboxes, list...

i have a simple SELECT stored procedure (MS SQL Server)that takes in one parameter and returns values from a DB table On executing the SP from the Database side, It works perfectly. I got to load the results from the SP into a list box on mysearch form (DELPHI). i want to load the listbox...

Hi, I am rather new to interbase and am using Interbase 7.1 and Delphi 7 (on windows 2003 server)-- stored procedures have JUST REFUSED to work for me... ! PS ASSIST... i have created a simple stored procedure (INSERT_DISTRICT) to insert values into a table (districts) and calling the same...

Hi, I am using Interbase 7.1 and Delphi 7 -- stored procedures have JUST REFUSED to work for me... ! PS ASSIST... i have created a simple stored procedure (INSERT_DISTRICT) to insert values into a table (districts) and calling the same from delphi code. In delphi am also using a data...

Hi, i am trying to call an interbase stored procedure from a delphi app but after execproc i cannot see the data in the database... the stored procedure is for inserting some values into several tables in the database. Urgently need HELP!!!