Are there any limitations in crystal reports?
Answers were Sorted based on User's Feedback
Answer / rahul
1. In export- While exporting data formatting is lost.
2. If database is having field whose length is more than
255 characters, then you cannot make formula using that
field.
3.When you browse data just by right clicking on the field
then it displays that is there in the database not the data
selected by the query.
| Is This Answer Correct ? | 41 Yes | 8 No |
Answer / vijay yadav
Yes inside a subreport another subreport is not allowed so
very big limitations of crystal report.
| Is This Answer Correct ? | 24 Yes | 4 No |
Answer / mlmcc
Crystal 9 removed the length limitation on strings or text
in a formula.
Depending on the format chosen for the export you can get a
formatted report exported. For instance if you export to
Word or PDF the file looks like the report.
| Is This Answer Correct ? | 12 Yes | 4 No |
1) End User need to have the crystal report viewer in his pc
in order to see the crystal reports.
2) You need to buy crystal reports license for each pc you
are used to design crystal reports
3) inside Subreports you are not allowed to another subreports
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / anoop
in reply to answer no 1 i would like to say.
while export in crystal report 10 formating is not lost (i
have checked in case of date).
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sajal kumar
There is sizing limitation of the of formula language, like
The maximum length of a string constant, a string value held
by string variable, a string value returned by a function or
string element of a string array is 65,534
The maximum size of array is 1000 elements
The maximum number off arguments in any function is
1000.this is applicable to function that can have infinite
number of arguments like choose
Date time function modeled in crystal report function
accepts date from year 1 to 9999.
The maximum number of loop condition evaluation of per
evaluation of formula is 100000. Option loop can be used to
change this limitation.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / roshan
Yes there are many limitations in crystal reports..
We can'ot have relative growth for the two text boxes in
the crystal reports ..
We can'ot have the formula fields output that can be given
for the crystal report
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ranjani
Stored procedure cannot be linked with any tables
| Is This Answer Correct ? | 10 Yes | 8 No |
Answer / theeba
It does not recognise <a></a> tag. Any Ideas.
Example: One field has
"This is <a href='www.abcdef.com'>abcdef</a>".
Text Interpretation to HTML should convert it to This is
abcdef with hyperlink for abcdef right.
But it is not converting.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / paul marks
Is any member aware of any restrictions relating to the
number of sections processed and printed on a report at
using the runtime DLL’s
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we use Crystal report as a stand-alone application?
How to pass stored Procedure Parameters to the report?
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?
Is it possible to join more than one universe in Busniess Objects BOE XI ? If its so Please explain how is that possible ? Thanks in advance for the people posting the answers
I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.
How can we improve the performance of a crystal report? OR What all performance improvement techniques used in crystal reports? (particularly CR XI)
How do we connect to the database?
Why is Excel Report preferred over crystal reports?
3 Answers Atos Origin, Collabera, Lighthouse Technologies,
If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?
Is it possible to export crystal report with linked subreports in one excel sheet?If yes,then how?
How many Sub Reports added in One MainReport?
4 Answers Amadeus, Aviva, CTS, Patni, Welkin,
what is the "refresh" button suppose to do on the crystal report viewer?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)