Showing posts with label adding. Show all posts
Showing posts with label adding. Show all posts
Tuesday, March 20, 2012
Crystal Reports 11 crashes when adding sub-report
I'm a new user of Crystal Reports 11. I'm able to create a new report without trouble. As soon as I try to add a sub-report to this report, CR crashes and this happens everytime. I uninstalled and re-installed CR thrice, but this problem still persists.
I'd really appreciate if anyone could share why this might be happening?Refer support page of this site
www.BusinessObjects.com|||Hi!
I just wanted to tell you, I migrated from cr 10 to 11 yesterday and had a cr 10 report with a subreport in it, wich I opened in cr 11. And it worked well.
Hope it works out for you.
/Helenius
I'd really appreciate if anyone could share why this might be happening?Refer support page of this site
www.BusinessObjects.com|||Hi!
I just wanted to tell you, I migrated from cr 10 to 11 yesterday and had a cr 10 report with a subreport in it, wich I opened in cr 11. And it worked well.
Hope it works out for you.
/Helenius
Thursday, March 8, 2012
Crystal Report - subreport - old data (PLEASE HELP !)
**Note - I'm developing with version 6.0 of Crystal Reports
I am adding a simple subreport to an existing report.
The existing report runs perfect with no problems.
It was when I added the subreport that the problem began.
The MAIN report retrieves from a stored procedure.
The subreport is linked from a field on the MAIN report to a table on the dB.
The first time I run the report, the report runs fine and displays data for the 1st parameters chosen from the screen. (pauses for a second - appears to be hitting the dB)
The second time I run the report, the report runs fine and displays data for the 2nd parameters chosen from the screen. (pauses for a second - appears to be hitting the dB)
The third time I run the report, the report runs, BUT displays the parameters chosen from the second run(old data). (doesn't pause at all, the report appears quickly - is not hitting the dB to run the stored procedure to refresh the data with new parameters chosen from the screen.)
I've tried setting cache to zero in the code and I've tried adding a field to the report which shows the surrent server time. Nothing has worked.
Is this a cache problem ? - i'm thinking maybe so, since the report runs correctly TWICE then suddenly not.
ANY suggestions about how to fix this ?? What other possible things can I try that might clear the cache ?
thanks !!!!
~JackiOpen the Report; Goto File and uncheck the option "Save Data with Reports"
I am adding a simple subreport to an existing report.
The existing report runs perfect with no problems.
It was when I added the subreport that the problem began.
The MAIN report retrieves from a stored procedure.
The subreport is linked from a field on the MAIN report to a table on the dB.
The first time I run the report, the report runs fine and displays data for the 1st parameters chosen from the screen. (pauses for a second - appears to be hitting the dB)
The second time I run the report, the report runs fine and displays data for the 2nd parameters chosen from the screen. (pauses for a second - appears to be hitting the dB)
The third time I run the report, the report runs, BUT displays the parameters chosen from the second run(old data). (doesn't pause at all, the report appears quickly - is not hitting the dB to run the stored procedure to refresh the data with new parameters chosen from the screen.)
I've tried setting cache to zero in the code and I've tried adding a field to the report which shows the surrent server time. Nothing has worked.
Is this a cache problem ? - i'm thinking maybe so, since the report runs correctly TWICE then suddenly not.
ANY suggestions about how to fix this ?? What other possible things can I try that might clear the cache ?
thanks !!!!
~JackiOpen the Report; Goto File and uncheck the option "Save Data with Reports"
Wednesday, March 7, 2012
Crystal 9 hyperlink text
I am formating text by adding a hyperlink that looks like this:
"https://IQuoteSummary.asp?vid=" & {v_L.VersionId}&"&lid=" &
{Locations.LocationId}
Both database fields are type number
The url enters the address:
"https://IQuoteSummary.asp?vid=1,521.00&lid=12.00"
It works when I run the report in crystal but after publishing it on
the crystal publishing wizard thing, I get those weird numbers.
I need these numbers as ints and without a comma. I tried changing the
formatting on the database fields on the report but that doesn't work.
Any idea how to get the url to print like this:
"https://IQuoteSummary.asp?vid=1521&lid=12"
ThanksFound it:
"http://blahblah/page.asp?=" + totext({field}, 0, "")
The zero removes the decimals and the third argument apparently is the
thousands separator.
Subscribe to:
Posts (Atom)