Crystal Reports Questions


Crystal Reports database
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]

Answer Question   |  October 28, 2011  8:48 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming
asked by:
10 pts.

crystal report ver.10
how to pass the value from subreport as positive number?

Answer Question   |  May 22, 2009  6:36 PM
Crystal Reports, Crystal Reports 10, Crystal Reports Subreports
asked by:
35 pts.

Importing to Excel one record appear on more than one line..
I am using crystal reports to make an excel file. I have different information for several people that needs to be put on this file. Each persons information needs to appear on one row instead of multiple rows. How do I manipulate crystal reports to show this information correctly?

Answer Question   |  May 20, 2009  12:36 PM
Crystal Reports, Crystal Reports Export, Microsoft Excel
asked by:
5 pts.

Export Crystal Report with sub report and it exports sub to a seperate row
When I export a report to excel all columns export correctly except the sub report it makes it a new row.

Answer Question   |  March 21, 2012  1:48 PM
Crystal Reports, Crystal Reports Export, Crystal Reports Subreport
asked by:
5 pts.

Crystal Reports in Web application with SQL Server 2005 Express
i want to create crystal report in asp.net 2.0 web application with sql server 2005 express edition. now the name of my database which i have created its name is Database.mdf. now whenever i expert database i can find my server name but in the dropdownlist of database i can`t find my database name. there [...]

Answer Question   |  May 18, 2009  4:56 AM
ASP.NET 2.0, Crystal Reports, SQL Server 2005, SQL Server 2005 connectivity, SQL Server 2005 Express, Web applications, Web development
asked by:
10 pts.

Crystal Reports Calculations & Formulas
I want to do the following in a Crystal Report and I’m not sure where to start. Raw Data Points: Admit Date/Time Patient Seq Number (Same number follows then through all hospitals in our system) Patient ID (a new number assigned at each new visit) Facility ID Department The report needs to give a list [...]

Answer Question   |  January 27, 2010  3:26 PM
Business Objects, Crystal Reports, Crystal Reports XI
asked by:
5 pts.

How to automatically refresh Crystal Reports 8.5 after new value?
how to refresh crystal report automatically after inserting value into table

Answer Question   |  May 15, 2009  6:31 AM
Crystal Reports, Crystal Reports 8.5
asked by:
5 pts.

Problem with Crystal Enterprise
I have a report that I run in Crystal Reports 10, then want to export the report in excel format and save to a location on a different pc. I also have Crystal Enterprise 10 installed – when I use the Schedule Manager to export the file to the other destination I get this error: [...]

Answer Question   |  May 14, 2009  8:54 PM
Crystal Enterprise Server, Crystal Reports, Crystal Reports 9
asked by:
5 pts.

create event
how do I create an event in CE XI R2?

Answer Question   |  May 14, 2009  4:55 PM
Crystal Reports, Crystal Reports XI, Crystal Reports XI R2
asked by:
20 pts.

How to remove tmp files in Crystal Reports 8.5
Hi, I develop an application in vb6 + crystal report 8.5. whenever i run a report application generate tmp file with 0k. how can i remove these files. Regards.

Answer Question   |  June 11, 2009  11:42 AM
Crystal Report 8.5, Crystal Reports, Temporary files, VB 6, Visual Basic 6
asked by:
5 pts.

Selecting BDay month to match Current month
I am trying to pull a report selecting only records with a Birthday month matching the current month, regardless of year (i.e. all May birthdays). How do I do this?

Answer Question   |  January 30, 2011  5:07 PM
Crystal Reports
asked by:
10 pts.

inventory help
when querying my database, my report will only show the inventory between a time frame sold. How can i get crystal reports to show me the entire category with the amount sold in a time frame? Not just what was sold in that time frame.

Answer Question   |  May 13, 2009  2:25 PM
Crystal Reports, Crystal Reports Inventory
asked by:
5 pts.

Crystal Reports days field
how to display 1-(31,30),1-29 days of current month in crystal report using vb.net in ascending order

Answer Question   |  May 13, 2009  1:46 AM
Crystal Reports, VB.NET, Visual Basic .NET
asked by:
5 pts.

Most current effective date
I am using a table that has multiple effective dates for employees. How do I write a formula in crystal to obtain the most current effective for each person?

Answer Question   |  May 11, 2009  2:55 PM
Crystal Reports, Crystal Reports formulas
asked by:
5 pts.

How to migrate Crystal Reports 9.0 to Crystal Reports 2008?
How to migrate Crystal Reports 9.0 to Crystal Reports 2008 ? also while converting CR 2008. all database scema are not displayed.

Answer Question   |  May 6, 2009  4:08 AM
Crystal Reports, Crystal Reports 2008, Crystal Reports 9, Crystal Reports migration
asked by:
5 pts.

Object Library Error
I keep getting this error when exporting Crystal Reports Ver. 10.0 to MS Excel 2003: Object Library invalid or contains references to object definitions that could not be found. Can this be fixed?

Answer Question   |  May 15, 2009  3:50 PM
Crystal Reports, Crystal Reports 10, Crystal Reports error messages, Crystal Reports Export, Excel 2003, Microsoft Excel
asked by:
5 pts.

Macro to Open Crystal Reports
I have an excel spreadsheet that I’ve used to create a crystal report. The excel file has multiple employee id’s on it. The crystal report has a parameter that uses the employee id to only show that employee’s information. I’m trying to set up a macro to loop through the employee ID column, pass one [...]

Answer Question   |  May 4, 2009  2:27 PM
Crystal Reports, Excel macros, Microsoft Excel
asked by:
5 pts.

Determining if a field has data in Crystal Reports
There are no ‘data dictionaries’ that I can find…and no way to tell exactly what fields ‘have’ data when writing a report. There are HUNDREDS of fields…and I would like to see WHICH fields have data w/out having to click each one to browse?? Thanks!

Answer Question   |  April 30, 2009  3:38 AM
Crystal Reports, Crystal Reports Conditional Parameters
asked by:
5 pts.

Printing variable data in different colors using Crystal Reports 8.5
I am trying to print variable data in different colors. Using the formatting parameters in Crystal Reports I am able to display the proper colors on the screen but when I issue a print the report appears black/white only (yes, I am using a color printer!) How can this be resolved?

Answer Question   |  April 30, 2009  8:45 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports printing
asked by:
20 pts.

Cache to Crystal
How can I pull reports from my cache database using crystal reports? I can’t even get it to connect or see the data

Answer Question   |  May 24, 2009  2:51 PM
Crystal Reports, InterSystems Cache
asked by:
10 pts.