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 |
how should i highlight a particular column in a report in actuate e designer report? It should be done dynamically while creating report Thanks in advance!!!!!!!!!!
Is there a way to export a report definition without writing code?
Explain reporter footer contents are move depend the page footer values?
If we create reports in Crystal Reports using the UCAR Data Warehouse database, which tables should be used?
Reports can be optimized for web viewing using which of the following strategies: a. Using subreports instead of linking tables b. Avoiding maps c. Using the Page N of M special field to help users understand how many pages are in the report d. Saving reports as version 10 e. Avoiding reports with drill-down capabilities
Why is Excel Report preferred over crystal reports?
3 Answers Atos Origin, Collabera, Lighthouse Technologies,
How many types of reports can be generated in crystal reports?
7 Answers Finite Infotech, Precision Techconet, VMware, winfoware,
One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita
Is there any feature like summing total in crystal report?
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?
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?
Can we call or add subreport within subreport?
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)