Crystal Reports

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

crystal report ver.10

how to pass the value from subreport as positive number?

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?

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.

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

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

How to automatically refresh Crystal Reports 8.5 after new value?

how to refresh crystal report automatically after inserting value into table

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: "There was an...

create event

how do I create an event in CE XI R2?

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.

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?

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.

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

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?

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.

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?

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

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!

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?

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