Search results for query: *

sv, It works just fine. Thanks so much. I spent several hours trying to fix this issue. Only modification I did here was to suppress the variables and on the sections, suppress blank pages. You deserve a * for this. I will send one your way, and could we put this together in a FAQ area? Thanks...

Folks.. I am trying print page footers based on the presence of subreport section in the main report. CR 8.5 on Sybase. I have 3 page footers. Page Footer_a = will print when subreport_a is printed Page footer_b = will print when main report is printed Page footer_c = will print when...

Thanks for the response. I said in the post that when you are printing in crystal, it appears as it should. Did you try exporting that? Please try to export to PDF. Not print to pdf printer, but using export tool of crystal. Maybe v10 is different. But v8.5 result of junk chars not text boxes...

Wingdings font (check boxes, etc)print correctly in crystal. After export to PDF, it's all junk letters (stars and stuff) nothing related to check boxes. I have explored different areas of forum and have not come across any solution to this. Has anyone been able to find a work around to this...

Here is another details. RHa - blank RHb - SR1 - subreport PH - blank - suppressed Groups 1- 8, including details, GHs, GFs - main groups of the main report. RF - SR2 - subreport in report footer PF - Common footer for all 3 report areas - SR1, Main, and SR2 There are some items there that...

Any suggestion for getting the page footer fields to print based on the following report configuration? RHa - blank RHb - SR1 - subreport PH - blank - suppressed Groups 1- 8, including details, GHs, GFs - main groups of the main report. RF - SR2 - subreport in report footer PF - Common footer...

lbass, any suggestion for getting the page numbers corrected. Here is now the configuration of the report. RHa - blank RHb - SR1 PH - none Groups 1- 8, including details, GHs, GFs, for main groups of the main report - Former SR2 RF - SR3 PF - Common footer for all 3 report areas - SR1, Main...

lbass and others, I have to change my strategy at the last minute due to the problem of being able to get those other subreport information to work. And I have a deadline of EOB day today. What I have decided now to do is to use SR2 from my original post as the main report, and embed SR1 and...

The 3 subreport information should will be populated in SR2 only. sub report 3 sql pull data is populated as part of details section in SR2. The problem is that the pulled data MUST appear as one block on information. Example: DA - Paving Equipment DB - {All of DB section info currently comes...

That is what I tried doing initially, but the repeatition is so much. Do you know NVL oracle function equivalent in Sybase? i have searched everywhere for something similar in sybase without success. Maybe I can capture these information in an array and pass the values to the report...

the 3 subreports are linked to this main report sql with the following sql sr1 sql and is linked to main with the following parameters - none. subreport is in the group footer section subreport 2 sql

lbass. I have implemented the solution you suggested with mior modification and that seem to work ok, right now. I will post the modification after the my project deadline on thursday. I think this should be writen as an FAQ. However, there is one more problem that I just run into right now...

I have spent some time on sub1. Honestly, Header thing does not seems to work. I tried to not suppress anything, and it will only print on fist page. I tried moving the the group_header_1 fields to report header since I only this once on this particular report, and not suppressing anything on...

I am giving another try with this expanded information. I was careful to make sure the "repeat group header on each page" was set, and reaffirm several times that its checked. will post an update if the solution has solved the problem. Thanks LB -b

LB, You are probably wondering why I haven't responded. I have been trying your solution. For what ever reason, it's not working for me. Both the repeating on page header and page footer. I have done all the things that you have mentioned here, I do not have the desired result especially the...

Let me try to give as much information as possible here. Scenario: Main report(MR) with 2 complex subreports (SR) - R1 and R2. R1 formating before merge to MR (Page Header -PH, Page Footer -PF) PHa - print once on entire report PHb - print from page 2 to end of report PFa - print from page 2...

That is what my thoughts has been, but I have read through several threads on this site that seems to bash sub reports in favor of union or stored proceedure. I was hoping someone can help me out towards that direction. In the meantime I have created 2 views from these queries and used that as 2...

The numbers will be used for populating certain sections within the subreport. I will also use the numbers to populate certain sections of main report. Each of the subreports has several sections that need to print based on certain conditions - one of which is last page for sub report. I want to...

Crystal Version 8. environment: Main report with 2 large subreports Question: How can I capture the number of pages that makes subreport. Of course the subreports are generated dynamically. I have combed through the forum but havent seen anything like that. Plainly, what I am looking to get is...

I am also posting this to a new thread, and thought should also put it here since this is where the original problem came from. The link to the new thread is below: http://www.tek-tips.com/viewthread.cfm?qid=1115728&page=1 Thanks for all your input. -b