Crystal Reports

Selected Fields print in Crystal Report 8 or 9

Dear Sir, How I can print a report baised on col. selected by user (eq if there are 10 col. in report and user wants to see only 4 col.), in VB 6.0 and crystal report 8 or 9 Please help me

Crystal Report Licensing

One of my customer developing application using Crystal Report XI, And they put the Aplication exe in the Web. They Build Web using Visual Studio. Please advise me about the CAL of crystal report who acces Crystal Report exe from that web? Thanks

Export report into seperate Word docs

Hi, I have created a Crystal report that runs from an Access Database. The report shows details of different projects. There are around 300 projects in total, and when I am exporting these at the moment, all the details are being produced in one report. However, I want to be able to export the...

Used CRViewer component in VB 6 and Crystal Reports but can't set portrait printing

Hi I used Crviewer component in my project for designing and printing reports but I can't set it portrait and it is landscape all the time and I couldn't find any properties about orientation!!!! I use of visual stedio 6 (vb6) and crystal report 8(os is winxp sp2) Could you please help me soon!!??...

Crystal Report Query - Customers with Multiple Products

I work as MI Analyst for an insurance company and have a query regarding a Crystal Report I need to run. I have been provided with some MI requests from a supplier who we provide products for on a cost per acquisition basis. They require a monthly report containing the total number of sales that...

Create Opening total in Crystal Reports

How create opening total ? and how to make it display only one time?

Crystal Reports - Control Breaks and variables

In my report I have 3 groups(Control Brekas): Bank1, Bank2, Branch. Bank1 is for the whole Bank Bank2 is for the District Branch is for the Branch within Bank2 At control break time for Bank2 the last Branch information is printed on the total page. This includes the Branch Name and Number. The...

Printing from Crystal Reports XI

I would like to create 2 labels in base of one filed information (this will be numeric information, usually the number 2). I would like to create these labels on base of field BOX# , this number is the number of labels I need to print. I use Crystal Reports XI. My question: Does this have to be a...

crystaL reports totals

Is the evaluate / reset an "AND" or "OR" situation. I have coded to evaluate and reset. My logic was to evaluate after every record to see if there was a break, reset fields after there is a break in the control field. I am totaling on item number when I have multiple items with the same item...

i want month number in crystal reports

hi there i want to get the number of month in crystal report from a date field means if date is of 16/05/2008 i want to get 5 from this for this i need help with best regards, Naeem Akhtar

How to compute number of hours in Crystal Reports

please help me given admtime as starttime with format (YYYY-MM-DD HH:MM:SS.MS) and currentdate as variable how can I compute the number of hours between the two parameters. please give me a sample formula.thanks

Crystal Record selection

I need to eliminate duplicate records by comparing two fields, if the data is the same, I only want it to appear once. "Select Distinct" report option compares the complete record. Please help

Dynamic Database Path Change in C# .NET

The Crystal Reports templates that our software uses are on the C: drive. The Crystal Reports templates selected database tables have a C: drive path. If the databases used by the report and the report templates are both on the C: drive, the reports appear correctly. If the databases are on the...

Is there a way to make ODBC see SQL Server 2005 Synonyms

I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.

Upgrading from Crystal Reports basic to Crystal Reports 11

Hi I have visual studio 2005 which ships with crystal report basic. I also have crystal report 11 developer edition. How can i upgrade the CR basic to CR 11 in visual studio

Specified week date range Crystal Reports

I'm working on an invoice type report in Crystal Reports and the top of the report needs to have "Billing Period: Sunday's Date - Saturday's Date" with the dates being for the week we are billing. I found a formula that pulls the dates for the previous week: CStr(Minimum(LastFullWeek)) + "-"+...

auto fit of object in crystal report after supression

i have three formula fields containing some data.Based on some condition middle object is supressed.After suppression i just want fit the place for the remaining 2 object.Is that possble that instead of 3 object place , i fit 2 object after supression of middle object.So in earlier situation same...

CRW32.EXE application error

I installed Crystal Reports v11 on my Server 2003 system. Then when I try to open it I'm getting: crw32.exe Application Error. The instruction at "0x7ff2fbfc" referenced memory at "0x7ff2fbfc". The memory could not be "written". Can anybody tell me what is happening and how to fix it? Marty

Table of Contents

Can you create a table of contents report in crystal (for another crystal report?)

format object of number

I am new to crystal report.I just want to display a number like 2345.56 in a format like (2345.5) . if i right click of formuls feild and go to format object option , i can get number formatting options ,Even through I select "(1123.00) in a number section of format Object options" but even through...