Search results for query: *

Never had it in Info Server but there is this problem happening in Crystal Enterprise 10 if you are in a clustered environment. If you look at the Patch ID: 37042716 in latest SP5 for CE10, you can see description of this issue. I guess the symptoms might be same for this behaviour in Info...

Give it this way.It is always recommended not to use any IF clauses in select expert. ({Table.Field1} = {?Parm1} OR {?Parm1} = "ALL") AND ({Table.Field2} = {?Parm2} OR {?Parm2} = "ALL") AND ({Table.Field3} = {?Parm3} OR {?Parm1} = "ALL") Add "ALL" in...

Try inserting a formula in Text Field: That is First insert the text APEX in the text field.Hit enter and then on second line insert the formula @address: Also explain what do you want to say by this line: On the first line there could be the words "FRONT OF" "OPPOSITE&quot...

From the main report choose EDIT --> Sub Report Links and i t should be self expainatary from there. http://www.jannah.com/forum/ The day He summons you, you will respond by praising Him, and you will then realize that you had lasted in this life but a short while.

What knd of database you have ? Oracle or SQL server or any other...cos working with procedures is lil different in Oracle when compared to MS-SQL Server.But in any case go to knowledge base on Crystal Decisions site and search using keyword: The knowledge base page is...

Try to set the Database Location at first.Database--> Set Location and then browse to the location where you have ur ".mdb" file and then hit SET. Now, refresh the report.That should help you. That is the only thing which should be affecting your report since you saved last unless...

It is really very helpful and helped me a lot. Thank You ! http://www.jannah.com/forum/ The day He summons you, you will respond by praising Him, and you will then realize that you had lasted in this life but a short while.

You might be having the option " SAVE DATA WITH REPORT" checked in.You would like to UNCHECK it and SAVE the reports. To disable it FILE-->OPTIONS-->REPORTING TAB-->SAVE DATA WITH REPORT I dont know if that might help you but that might be better thing to do anyway.

Make a GROUP on the Field in which u have '113' '114' in ur stated example.It insert a Group footer along with it which comes below ur Detail section (if you have only 1 group in ur report.) Now ur report is as u described Current YTD 113 xxxx 001 xxxx 122 total...

First thing you need to understand is that Crystal Reports is Two-Pass reporting Process. The Sub report Query is passed to Database during SECOND PASS and hence it is always advised to go for Sub-Report if you had already tried all options at hand.Using Stored Procedure is best way to design...

If i were you i would probably start by going through VB samples which crystal reports comes with.The typical location of those sampes will be: C:\Program Files\Seagate Software\Crystal Reports\Samples\En\Code\Visual Basic

I had run with this issue about an year ago. The things i will recommend you are: 1) Make sure the ODBC datasource you have on ur machine points to SAME database as the other machine ( In case you have Development and Production Databases) 2) Check the Version of ODBC datasource you have on...

The best way might be to write STORED procedure and then report on that Procedure.

That warning message is also displayed when you LINK two fields with different datatype.Eg Table1.Field1( Numeric 4 ) and Table2.Field2 ( Numeric 8 ). In the baove case also u get that warning but if your sure that those fields will have same data then report works fine. That is just a warnig...

There is other option too.Place the below Data in GROUP HEAER 2 and suppress the GROUP 1. GROUP1 and GROUP2 Record1 Record2 Record3 Record4 Then place this info in GROUP Header 3 GROUP3 Record5 Record6 NOTE: With the above option make sure to have "New Page...