Hi,
I am facing compatibilty issues of Crystal Report 8.0 with SQL server 2005.
I am unable to generate reports designed in Crystal 8.0. My application calls the Report file which in turn uses SQL Stored procedures where business rules and logic is written.
I am afraid is there any compatibility issues persists with Crytal 8.0 and SQL Server 2005. If so, kindly suggeest me the Crytal report compatible version for SQL server 2005.
I shall be very thankful to get a solution on this.
Regards,
Nethesh KannanSorry, but if you want help you will need to supply more details than "It don't work".
Wednesday, March 7, 2012
Saturday, February 25, 2012
Crystal 4.6 Question
this is my code, and when It comes to show the report on the screen nothing happens:
CrystalReport1.Connect = "Provider = Microsoft.Jet.OLEDB.4.0;" &
App.Path & "\config.mdb;UID=sa;PWD=12345;"
Me.CrystalReport1.DataFiles(0) = App.Path + "\db.mdb"
CrystalReport1.ReportFileName = App.Path + "\boent_rep.rpt"
CrystalReport1.Destination = crptToWindow
CrystalReport1.DiscardSavedData = True
CrystalReport1.ReportFileName = "c:\lm_cliente.rpt"
CrystalReport1.SelectionFormula = formula 'whatever formula is
CrystalReport1.Action = 1
After the last line I have checked the .status property being the result -1. I know that after a successful display the result in .status is 3.
What is the .status property means, what are the possible results. What does it means if a -1 result is what I get? Please help :D*bump*|||Did you know the answer?
CrystalReport1.Connect = "Provider = Microsoft.Jet.OLEDB.4.0;" &
App.Path & "\config.mdb;UID=sa;PWD=12345;"
Me.CrystalReport1.DataFiles(0) = App.Path + "\db.mdb"
CrystalReport1.ReportFileName = App.Path + "\boent_rep.rpt"
CrystalReport1.Destination = crptToWindow
CrystalReport1.DiscardSavedData = True
CrystalReport1.ReportFileName = "c:\lm_cliente.rpt"
CrystalReport1.SelectionFormula = formula 'whatever formula is
CrystalReport1.Action = 1
After the last line I have checked the .status property being the result -1. I know that after a successful display the result in .status is 3.
What is the .status property means, what are the possible results. What does it means if a -1 result is what I get? Please help :D*bump*|||Did you know the answer?
Crystal 4.6 connection to Access 2000?
I have a VB6 package that uses CR 4.6 and has installed successfully on numerous PCs under all versions of Windows (97 to XP).
Now I when I run the package on my new laptop and try to print a report, I get error error 2147417848 - disconnected from client.
Moreover, although the CR report designer recognises the rpt files, the preview window gives an error. I'm assuming connecting to the database is the problem. The new laptop has no problem with any other software or with printing in general.
I have tried re-installing VB6 and Crystal Reports, re-registering crystl32.ocx, tried the Dependency Walker from Crystal, spent hours trawling the web, all to no avail.
Any bright ideas out there?Are you able to open the report?
Do verify database
Now I when I run the package on my new laptop and try to print a report, I get error error 2147417848 - disconnected from client.
Moreover, although the CR report designer recognises the rpt files, the preview window gives an error. I'm assuming connecting to the database is the problem. The new laptop has no problem with any other software or with printing in general.
I have tried re-installing VB6 and Crystal Reports, re-registering crystl32.ocx, tried the Dependency Walker from Crystal, spent hours trawling the web, all to no avail.
Any bright ideas out there?Are you able to open the report?
Do verify database
Crystal 2 ReportingServices
Does anybody know a free tool to convert Crystal Reports to Reporting
Services ?
Thanks ins advance,
Tito.On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> Does anybody know a free tool to convert Crystal Reports to Reporting
> Services ?
> Thanks ins advance,
> Tito.
Unfortunately, I have not found any free conversion options. Here are
a few that can do the conversion for a price though:
http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
http://www.rpttordl.com/
Sorry I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you !
"EMartinez" <emartinez.pr1@.gmail.com> escreveu na mensagem
news:1181100921.907554.304710@.p77g2000hsh.googlegroups.com...
> On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
>> Does anybody know a free tool to convert Crystal Reports to Reporting
>> Services ?
>> Thanks ins advance,
>> Tito.
>
> Unfortunately, I have not found any free conversion options. Here are
> a few that can do the conversion for a price though:
> http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
> http://www.rpttordl.com/
> Sorry I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 6, 8:22 am, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> Thank you !
> "EMartinez" <emartinez...@.gmail.com> escreveu na mensagemnews:1181100921.907554.304710@.p77g2000hsh.googlegroups.com...
> > On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> >> Does anybody know a free tool to convert Crystal Reports to Reporting
> >> Services ?
> >> Thanks ins advance,
> >> Tito.
> > Unfortunately, I have not found any free conversion options. Here are
> > a few that can do the conversion for a price though:
> >http://www.microsoft.com/sql/technologies/reporting/partners/crystal-...
> >http://www.rpttordl.com/
> > Sorry I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Services ?
Thanks ins advance,
Tito.On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> Does anybody know a free tool to convert Crystal Reports to Reporting
> Services ?
> Thanks ins advance,
> Tito.
Unfortunately, I have not found any free conversion options. Here are
a few that can do the conversion for a price though:
http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
http://www.rpttordl.com/
Sorry I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you !
"EMartinez" <emartinez.pr1@.gmail.com> escreveu na mensagem
news:1181100921.907554.304710@.p77g2000hsh.googlegroups.com...
> On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
>> Does anybody know a free tool to convert Crystal Reports to Reporting
>> Services ?
>> Thanks ins advance,
>> Tito.
>
> Unfortunately, I have not found any free conversion options. Here are
> a few that can do the conversion for a price though:
> http://www.microsoft.com/sql/technologies/reporting/partners/crystal-migration.mspx
> http://www.rpttordl.com/
> Sorry I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 6, 8:22 am, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> Thank you !
> "EMartinez" <emartinez...@.gmail.com> escreveu na mensagemnews:1181100921.907554.304710@.p77g2000hsh.googlegroups.com...
> > On Jun 5, 1:10 pm, "Marcos Tito" <mrct...@.hotmail.com> wrote:
> >> Does anybody know a free tool to convert Crystal Reports to Reporting
> >> Services ?
> >> Thanks ins advance,
> >> Tito.
> > Unfortunately, I have not found any free conversion options. Here are
> > a few that can do the conversion for a price though:
> >http://www.microsoft.com/sql/technologies/reporting/partners/crystal-...
> >http://www.rpttordl.com/
> > Sorry I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
Crystal 10 Using ASP page for datebase connections
I hope someone can help me get started on this. I wish I knew all of the terminology to use for this, but I have limited knowledge of Crystal Enterise 10. I am trying to figure this out as the person who created it is no longer around. He is my problem. I have a Crystal report ( Crystal 10) that has two subreports. The main report and the two subreports are all from different datasources. The report runs fine on my machine using the Crystal application. The problem comes in when I run it via Internet Explorer. There is an ASP page that is used to pass the connection information to the Crystal report. It works fine via the web with only one subreport. I can not figure out how to add the third datasource to the ASP page. I will include the ASP page that is used for the two current connections. What I need to know is how to add the third datasource connection to the existing information. I am going to attach a PDF of the code. Thank you for your help.
<%@. Language=VBScript CodePage=65001 %>
<%
'=======================================================================
' CRYSTAL ENTERPRISE REPORT APPLICATION SERVER (CE EMBEDDED) 10
' Purpose: Demonstrate how to change the datasource location at runtime
' Special Note* - ODBC Datasources
'=======================================================================
' This line creates a string variable called reportName that we will use to pass
' the Crystal Report file name (.rpt file) to the OpenReport method.
reportname = "Reports/"&Request("CRReport")
'============================================================================
' CREATE THE REPORT CLIENT DOCUMENT OBJECT AND OPEN THE REPORT
'============================================================================
' Use the Object Factory object to create other RAS objects (useful for versioning changes)
Set objFactory = CreateObject("CrystalReports.ObjectFactory")
' This "While/Wend" loop is used to determine the physical path (eg: C:\) to the
' Crystal Report .rpt by translating the URL virtual path (eg: http://Domain/Dir)
Dim path, iLen
path = Request.ServerVariables("PATH_TRANSLATED")
While (Right(path, 1) <> "\" And Len(path) <> 0)
iLen = Len(path) - 1
path = Left(path, iLen)
Wend
' Create a new ReportClientDocument object
Set Session("oClientDoc") = objFactory.CreateObject("CrystalClientDoc.ReportClientDocument")
' Specify the RAS Server (computer name or IP address) to use (If SDK and RAS Service are running on seperate machines)
Session("oClientDoc").ReportAppServer = "localhost"
' Open the report object to initialize the ReportClientDocument
Session("oClientDoc").Open path & reportName
'===============================================================
' CHANGING THE MAIN REPORT DATABASE INFO
'===============================================================
Set oDBInfo = Session("oClientDoc").DatabaseController.GetConnectionInfos().Item(0)
oDBInfo.UserName = "sa"
oDBInfo.Password = "blackfin"
'Get the collection of tables in the main report
Set Tables = Session("oClientDoc").DataDefController.Database.Tables
For Each table in Tables
'clone the table object
Set newTable = Table.Clone
'set the table's connectionInfo to the current connection info
newTable.ConnectionInfo = oDBInfo
'set the table object qualified name to include the new database name
'i.e. original = 'db1.dbo.myTable', new = 'db2.dbo.myTable'
'newTable.QualifiedName = Database & ".dbo." & Table.Name
'put this newly modified table object back into the report client doc
Session("oClientDoc").DatabaseController.SetTableLocation table, newTable
Next
'===============================================================
' CHANGING THE DATABASE FOR ALL SUBREPORTS
'===============================================================
'get a collection of subreport names
Set subReportNames = Session("oClientDoc").SubReportController.QuerySubreportNames
For each subName in subReportnames
'we can't reference a subreport table object directly, so we get the collection of tables first
Set subTables = Session("oClientDoc").SubReportController.GetSubreportDatabase(subName).Tables
For each subTable in subTables
'clone the subreport table object
Set newSubTable = subTable.Clone
'set the subreport table's connectionInfo to the current connection info
newSubTable.ConnectionInfo.UserName = "william_l"
newSubTable.ConnectionInfo.Password = "bdl700"
'set the table object qualified name to include the new database name
'i.e. original = 'db1.dbo.myTable', new = 'db2.dbo.myTable'
'newSubTable.QualifiedName = Database & ".dbo." & subTable.Name
'put this newly modified table object back into the report client doc
Session("oClientDoc").SubReportController.SetTableLocation subName, subTable, newSubTable
'on error resume next
Next
Next
'============================================================================
' CHOOSING THE REPORT VIEWER
'============================================================================
'
' There are four Report Viewers:
' 1. Crystal Reports Interactive Viewer (CrystalReportsInteractiveViewer.asp)
' 2. Crystal Reports Viewer (CrystalReportsViewer.asp)
' 3. Crystal Reports Parts Viewer (CrystalReportsPartsViewer.asp)
' 4. Legacy ActiveX Viewer (ActiveXViewer.asp)
'
' Note that to use this these viewers you must have the appropriate .asp file in the
' same virtual directory as the main ASP page. Choose from one of the four viewers below,
' simply uncomment the one you want to use:
' *** Crystal Reports Interactive Viewer ***
Response.Redirect "CrystalReportsInteractiveViewer.asp"
' *** Crystal Reports Viewer ***
'Response.Redirect "CrystalReportsViewer.asp"
' IMPORTANT NOTE - To use the report parts viewer successfully you are required to
' choose and name three objects in the report to Node1, Node2 and Node3.
' You can access an objects name by using the Format Editor dialog box.
' For more information on the Format Editor Dialog Box and setting objects
' names, please refer to the Help Contents (Help Menu->Crystal Reports Help)
' or by pressing F1
' *** Crystal Reports Parts Viewer ***
'Response.Redirect "CrystalReportsPartsViewer.asp"
' IMPORTANT NOTE - The ActiveXviewer does NOT have the ability to prompt for parameters,
' selection formulas, or login information. If your report requires this information
' to run, look at the the appropriate code samples to pass this information before
' using this viewer.
' *** Legacy ActiveX Viewer ***
'Response.Redirect "ActiveXViewer.asp"
'=============================================================================
%>
%>Hi, Does anyone have an ideas? Does my question make sense?
Thank you|||What I see is that the line that change to new database location is a comment
'newSubTable.QualifiedName = Database & ".dbo." & subTable.Name|||Thank you jggtz for the reply.
Would the Database piece be the ODBC name? What needs to be modified on the ".dbo." section? Does the subTable.Name stay like it is?
You don't know how much I appreciate your help.
Thank you.|||Maybe this can help -->
http://www.codeproject.com/aspnet/crystalwithaspdotnet.asp?df=100&forumid=188132&exp=0&select=1455404
<%@. Language=VBScript CodePage=65001 %>
<%
'=======================================================================
' CRYSTAL ENTERPRISE REPORT APPLICATION SERVER (CE EMBEDDED) 10
' Purpose: Demonstrate how to change the datasource location at runtime
' Special Note* - ODBC Datasources
'=======================================================================
' This line creates a string variable called reportName that we will use to pass
' the Crystal Report file name (.rpt file) to the OpenReport method.
reportname = "Reports/"&Request("CRReport")
'============================================================================
' CREATE THE REPORT CLIENT DOCUMENT OBJECT AND OPEN THE REPORT
'============================================================================
' Use the Object Factory object to create other RAS objects (useful for versioning changes)
Set objFactory = CreateObject("CrystalReports.ObjectFactory")
' This "While/Wend" loop is used to determine the physical path (eg: C:\) to the
' Crystal Report .rpt by translating the URL virtual path (eg: http://Domain/Dir)
Dim path, iLen
path = Request.ServerVariables("PATH_TRANSLATED")
While (Right(path, 1) <> "\" And Len(path) <> 0)
iLen = Len(path) - 1
path = Left(path, iLen)
Wend
' Create a new ReportClientDocument object
Set Session("oClientDoc") = objFactory.CreateObject("CrystalClientDoc.ReportClientDocument")
' Specify the RAS Server (computer name or IP address) to use (If SDK and RAS Service are running on seperate machines)
Session("oClientDoc").ReportAppServer = "localhost"
' Open the report object to initialize the ReportClientDocument
Session("oClientDoc").Open path & reportName
'===============================================================
' CHANGING THE MAIN REPORT DATABASE INFO
'===============================================================
Set oDBInfo = Session("oClientDoc").DatabaseController.GetConnectionInfos().Item(0)
oDBInfo.UserName = "sa"
oDBInfo.Password = "blackfin"
'Get the collection of tables in the main report
Set Tables = Session("oClientDoc").DataDefController.Database.Tables
For Each table in Tables
'clone the table object
Set newTable = Table.Clone
'set the table's connectionInfo to the current connection info
newTable.ConnectionInfo = oDBInfo
'set the table object qualified name to include the new database name
'i.e. original = 'db1.dbo.myTable', new = 'db2.dbo.myTable'
'newTable.QualifiedName = Database & ".dbo." & Table.Name
'put this newly modified table object back into the report client doc
Session("oClientDoc").DatabaseController.SetTableLocation table, newTable
Next
'===============================================================
' CHANGING THE DATABASE FOR ALL SUBREPORTS
'===============================================================
'get a collection of subreport names
Set subReportNames = Session("oClientDoc").SubReportController.QuerySubreportNames
For each subName in subReportnames
'we can't reference a subreport table object directly, so we get the collection of tables first
Set subTables = Session("oClientDoc").SubReportController.GetSubreportDatabase(subName).Tables
For each subTable in subTables
'clone the subreport table object
Set newSubTable = subTable.Clone
'set the subreport table's connectionInfo to the current connection info
newSubTable.ConnectionInfo.UserName = "william_l"
newSubTable.ConnectionInfo.Password = "bdl700"
'set the table object qualified name to include the new database name
'i.e. original = 'db1.dbo.myTable', new = 'db2.dbo.myTable'
'newSubTable.QualifiedName = Database & ".dbo." & subTable.Name
'put this newly modified table object back into the report client doc
Session("oClientDoc").SubReportController.SetTableLocation subName, subTable, newSubTable
'on error resume next
Next
Next
'============================================================================
' CHOOSING THE REPORT VIEWER
'============================================================================
'
' There are four Report Viewers:
' 1. Crystal Reports Interactive Viewer (CrystalReportsInteractiveViewer.asp)
' 2. Crystal Reports Viewer (CrystalReportsViewer.asp)
' 3. Crystal Reports Parts Viewer (CrystalReportsPartsViewer.asp)
' 4. Legacy ActiveX Viewer (ActiveXViewer.asp)
'
' Note that to use this these viewers you must have the appropriate .asp file in the
' same virtual directory as the main ASP page. Choose from one of the four viewers below,
' simply uncomment the one you want to use:
' *** Crystal Reports Interactive Viewer ***
Response.Redirect "CrystalReportsInteractiveViewer.asp"
' *** Crystal Reports Viewer ***
'Response.Redirect "CrystalReportsViewer.asp"
' IMPORTANT NOTE - To use the report parts viewer successfully you are required to
' choose and name three objects in the report to Node1, Node2 and Node3.
' You can access an objects name by using the Format Editor dialog box.
' For more information on the Format Editor Dialog Box and setting objects
' names, please refer to the Help Contents (Help Menu->Crystal Reports Help)
' or by pressing F1
' *** Crystal Reports Parts Viewer ***
'Response.Redirect "CrystalReportsPartsViewer.asp"
' IMPORTANT NOTE - The ActiveXviewer does NOT have the ability to prompt for parameters,
' selection formulas, or login information. If your report requires this information
' to run, look at the the appropriate code samples to pass this information before
' using this viewer.
' *** Legacy ActiveX Viewer ***
'Response.Redirect "ActiveXViewer.asp"
'=============================================================================
%>
%>Hi, Does anyone have an ideas? Does my question make sense?
Thank you|||What I see is that the line that change to new database location is a comment
'newSubTable.QualifiedName = Database & ".dbo." & subTable.Name|||Thank you jggtz for the reply.
Would the Database piece be the ODBC name? What needs to be modified on the ".dbo." section? Does the subTable.Name stay like it is?
You don't know how much I appreciate your help.
Thank you.|||Maybe this can help -->
http://www.codeproject.com/aspnet/crystalwithaspdotnet.asp?df=100&forumid=188132&exp=0&select=1455404
Crystal 10 multi-threading?
I have a debug windows service which picks up records from a database and based on some flags runs few hundreds reports. Reports are created not by odbc connection but accessing a .dll which has a dataset and so on. Not a very nice solution to write 30 pages of sql instead of using stored procedures... anyway.
For some reason not all threads are running at the same time, for some reason second thread won't start until first one releases CR object. My question is... does Crystal Report 10 support multithreading?? Almost forgot... objects used: craxdrt.dll
Thanks,
RobertTry searching in http://support.businessobjects.com
For some reason not all threads are running at the same time, for some reason second thread won't start until first one releases CR object. My question is... does Crystal Report 10 support multithreading?? Almost forgot... objects used: craxdrt.dll
Thanks,
RobertTry searching in http://support.businessobjects.com
Crystal 10 grouping layout issue
I need some assistance with some layout issues I am having with a report. I have searched through help for the software as well as a book I have and so far having absolutely no luck in fixing my problem!
I have a report that groups by Country and then by site (multiple sites within a country) and I have totals(summaries) for each of those categories. The problem that it is splitting up in the middle of the detail data for site groupings from the end of one page and continuing to the top of another page. I am wanting to keep all the site detail data together for any one site and not have it split between pages in the middle of the data. I have made sure on the group expert and section expert that "keep together" is checked and in the group footer 1(country) in the section expert I have checked New Page After with the formula Not OnLastRecord which helps in the differentiation between the countries for layout, but not sure what else I can do to keep site detail data together. I am wracking my brain and I have tried everything I already know how to do and absolutely having no luck.
Help a girl out please!
Thanks!
StacyDid you enable "keep together" option for both Country and Site groups? This should provide you with enough protection against splitting details. This option will also keep together group headers and footers where the summary fields are usually displayed.
Again, you should use "keep together" option in groups, not sections, because keeping together sections will not keep together your group summaries.
When kept together, the group will only be split if it cannot fit into a single page. In rare occasions, though, the summary for such group can still be moved to the next page, leaving all detail rows to prevous page, *IF* the detail rows will occupy exactly 1 page. I call it orphaned summary. There are 2 workaround technics for avoiding orphaned footers in Crystal knowledge base:
http://support.businessobjects.com/library/kbase/articles/c2000973.asp
http://support.businessobjects.com/library/kbase/articles/c2004981.asp
Hope it helps.|||I did uncheck "Keep Together" in all of the group sections and in the details section. I kept the "Keep Together" checked on the group expert for each grouping and that seemed to resolve things for two of the reports, however there is still one report where the details are still splitting up. It's one of the bigger reports of course so not sure if it's just a matter of size, guess I will find out as those reports grow as to whether or not the issue is really fixed with them. No issues with orphaned/widowed summaries though.
Essentially here is what it would look like and it seems to only be a problem on the first page with that includes the report header, the rest of the report is just fine with no splitting of details.
Top of page 1
RH
PH
GH1 - Country
GH2
D
D
D
GF2
End of page 1
GH2
D - Site, patient
D - Site, patient
D - Site, patient
PF
Top of Page 2
PH
D - Site, patient
D - Site, patient
GF2 - summary of sites
No idea if this helps at all. Group Footer 1 is hidden as is Report Footer|||Two things I would try - first, remove "keep together" for outer group, as this group cannot be kept together anyway. Second, I would create a new report based only on couple of tables used for grouping. Then I would insert the same 2 groups and see if the behaviour will be the same.
BTW, you have CR10 SP4 applied, don't you?|||Okay removing the "Keep Together" on the outer group seems to have taken care of it. Still having our IT folks install the service pack regardless. Thanks for the tip on that and for all the help. Literally I had been working on this for several weeks and was not about to give up. Again thank you so much!
Stacy|||No prob :D
I have a report that groups by Country and then by site (multiple sites within a country) and I have totals(summaries) for each of those categories. The problem that it is splitting up in the middle of the detail data for site groupings from the end of one page and continuing to the top of another page. I am wanting to keep all the site detail data together for any one site and not have it split between pages in the middle of the data. I have made sure on the group expert and section expert that "keep together" is checked and in the group footer 1(country) in the section expert I have checked New Page After with the formula Not OnLastRecord which helps in the differentiation between the countries for layout, but not sure what else I can do to keep site detail data together. I am wracking my brain and I have tried everything I already know how to do and absolutely having no luck.
Help a girl out please!
Thanks!
StacyDid you enable "keep together" option for both Country and Site groups? This should provide you with enough protection against splitting details. This option will also keep together group headers and footers where the summary fields are usually displayed.
Again, you should use "keep together" option in groups, not sections, because keeping together sections will not keep together your group summaries.
When kept together, the group will only be split if it cannot fit into a single page. In rare occasions, though, the summary for such group can still be moved to the next page, leaving all detail rows to prevous page, *IF* the detail rows will occupy exactly 1 page. I call it orphaned summary. There are 2 workaround technics for avoiding orphaned footers in Crystal knowledge base:
http://support.businessobjects.com/library/kbase/articles/c2000973.asp
http://support.businessobjects.com/library/kbase/articles/c2004981.asp
Hope it helps.|||I did uncheck "Keep Together" in all of the group sections and in the details section. I kept the "Keep Together" checked on the group expert for each grouping and that seemed to resolve things for two of the reports, however there is still one report where the details are still splitting up. It's one of the bigger reports of course so not sure if it's just a matter of size, guess I will find out as those reports grow as to whether or not the issue is really fixed with them. No issues with orphaned/widowed summaries though.
Essentially here is what it would look like and it seems to only be a problem on the first page with that includes the report header, the rest of the report is just fine with no splitting of details.
Top of page 1
RH
PH
GH1 - Country
GH2
D
D
D
GF2
End of page 1
GH2
D - Site, patient
D - Site, patient
D - Site, patient
PF
Top of Page 2
PH
D - Site, patient
D - Site, patient
GF2 - summary of sites
No idea if this helps at all. Group Footer 1 is hidden as is Report Footer|||Two things I would try - first, remove "keep together" for outer group, as this group cannot be kept together anyway. Second, I would create a new report based only on couple of tables used for grouping. Then I would insert the same 2 groups and see if the behaviour will be the same.
BTW, you have CR10 SP4 applied, don't you?|||Okay removing the "Keep Together" on the outer group seems to have taken care of it. Still having our IT folks install the service pack regardless. Thanks for the tip on that and for all the help. Literally I had been working on this for several weeks and was not about to give up. Again thank you so much!
Stacy|||No prob :D
Subscribe to:
Posts (Atom)