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 |
What are the sections that we have in Crystal reports?
How to write a formula to change a font based upon data ?
If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?
Where is the image located, after youve placed it on the report?
Can we add any database field once we have chosen ?Close? button?
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.
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
Suppose I have a crystal report with a linked subreport as well. Is there any way not to print the current record on the main report if no records are returned from the subreport?
Why do we use crystal reports when we have reporting tools in bo itself?
When looking at the join types in Crystal - what does it mean when you coose Enforce and Enforce To or Enforce From
I am not able to see any image on Crystal Report at Run time. So how can I load any image which is saved in local disk so that it can be viewed at Runtime in Crystal reports?
Is there any feature like summing total in crystal report?