-
runtime error “server has not yet been opened”
Runs in Crystal IDE but not when run from VB. Access DB. Have 8 other reports using same code which work.
-
Crystal Reports VII, viewing data while using select expert
Sorry if this duplicated, I thought I posted this but I can't find it anywhere here goes I created a report with crystal 7 and I using the select expert for a particular field/table. When I use the expert the drop drown menu does show me every thing in the table. Is there a limit to how many...
Last updated: -
can I use accdb with Crystal report 8.0?
can I use accdb with Crystal report 8.0? Please help.
Last updated: -
Crystal Reports grouping by date
Hi, I'm trying to group single dates (eg. 1 Jan 09, 9 Jan 09, 11 Jan 09, etc) by weekly interval (e.g. 1-7 Jan 09, 8-14 Jan 09, etc). Any suggestions please?
Last updated: -
I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...
Last updated: -
Select printer from CRViewer in VB 6.0 and Crystal Reports 8.0
i use Rpt.PrinterSetup Me.hWnd this, to set up printer setup. it prints blank page
Last updated: -
We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?
Last updated: -
More than one level nesting in crystal reports
Hi, **************** Using: Crystal reports XI release 2 Database - DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen B ->...
Last updated: -
I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential - IL - Waukegan...I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there is one name...
Last updated: -
Formula setup on the crystal report
I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?
Last updated: -
view data from ODBC to Crystal Reports
i am using Crystal Reports 10 to display data from ODBC. The error "Failed to open rowset. Details:HY000:
Last updated: -
VB 6, SQL Server 2000 & Crystal Reports
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Last updated: -
I use crystal report version 1o
I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is the field i need to display...
Last updated: -
Crystal reports, change recurrance pattern
Hi, I have some reports that automatically run through the Crystal Management Console. I need to turn off or remove recipients from some of these reports. I have gone into the Schedule tab for each report and changes the recurrance and recipients then updated the parameters. The problem is that my...
Last updated: -
I have created a paramteter for the user to select a date from a list of dates. I have also created two parameters for the user to select a begin and end date. For each date, i setup each date value as a formula using the DATEVALUE ({query.datefield}). I inserted the parameters on the report but...
Last updated: -
When I insert my third subreport into my main report I get a message "Performing this action will cause all open subreports to be closed" Why can't I insert my remaining sub report?
Last updated: -
Crystal reports formula – equal or less than 60 days
Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.
Last updated: -
iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001
Last updated: -
When trying to create a new connection to a different database receive the following message "Crystal Reports has encountered a problem and needs to close" then cystral closes.
-
CRYSTAL REPORTS QUESTION REQUIRING , GROUPING, SUMMARIZING AND SUPRESSING ?
Hi,I am grouping my report as per the columns.I need to sum values of indivual transactions as per the dates and display these summarised values against the items in the grouped columns. I do not want to display the date fields but I need the dates since I need the items , queried and summaised...
Last updated: