Suppress Main Section Based on Subreport

Hello:

In Crystal XI, I want to suppress sections of the main report when either of 
the two subreports that I have on my main report are blank.  
 
Specifically, each of these two subreports does not always show data.  
That's because I have configured the one and only field in each subreport to 
suppress itself when that field is greater than or equal to 0.
 
In any case, if either of these two subreports are not displaying data, I do 
not want sections of the main report to display data.  And, that's true if 
those sections contain either of these two subreports, any other subreports, 
or simply data from the main report.
 
How do I configure this?

Thanks.

childofthe1980s
0
Utf
11/14/2009 10:50:01 PM
greatplains 29623 articles. 4 followers. Follow

0 Replies
1204 Views

Similar Articles

[PageSpeed] 27

Reply:

Similar Artilces:

How to suppress #VALUE!
After setting up functions, the spreadsheet appears ugly when there are empty input cells. Is there any method in suppressing the display of #VALUE! etc, say assigning white colour to these error words? Thanks! Fix the errors, dont just hide them, eg Instead of your_formula that appears to give you the error when an input cell is empty (assume it is A1), try =IF(A1="","",your_formula) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------�-------------------...

Main Form checkbox toggles many subform checkboxes
I have a main form / subform setup. The subform has a field that is a yes/no data type, represented by a checkbox in the field. How do I set up a control on the main form (possibly another checkbox) so that when I click the control, it will toggle ALL of the checkboxes in the subform on and off. Similar to a "select/deselect all"? -- Message posted via http://www.accessmonster.com Use the AfterUpdate event procedure of the unbound check box on the main form, to execute an Update query on the subform's table. This kind of thing: Private Sub chkSetAll_AfterUpdate() Dim ...

java based pdf and excel generation
I am working on a browser based reporting tool and would like to give the client the option to save the reports in excel and pdf forms. The reporting tool is a part of a WebLogic (Java) based application. Ideally I would like to use a Java package that can generate both pdf and excel documents. I have come across some tools such as iText (for pdf) and Java Excel API (for excel). Is there any library which could do both. i.e. a single library which can generate both pdf and excel documents? Thanks I believe reporting packages such as JReports can do this. <paulthomasweb@gmail.com> w...

Printing multiple records based on a field.
I have a database containing all students for our classes, and what class they are taking. I need a way to print off each record, one per page, of all students taking the same class. How would I go about this? do you have all your info in one table or multiple tables? build a query based on the table(s). this will allow you to set parameter (filters) for one page based on one course. this query can also be copied and change the filter for other reports if you need them later. generate the report to group by class and sort by student. once the report is generated by the wizard, you ca...

blank page runs through after main page has printed
After my main page has printed a blank page runs through the printer. What is my problem? Do you have a second page that is blank in the pub file? Look at the bottom of the screen and see if there is a single page icon or if there are two page icons. If there is a second icon, Edit, delete page. -- Don Vancouver, USA "lewieB" <lewieB@discussions.microsoft.com> wrote in message news:975E4078-F1F2-4E7E-851C-F2DF1CF1B64C@microsoft.com... > After my main page has printed a blank page runs through the printer. What > is my problem? Open your printer folder, right-cl...

How to suppress "Entourage cannot find server" message when offline?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: Exchange Greetings. I'm a frequent traveler, and I can only access my email when connected to a VPN. When I am offline, I get the following error every time I send an email. <br><br>&quot;Entourage cannot find the server. Verify the server information is entered correctly in the Account Settings, and that your DNS settings in the Network pane of System Preferences are correct. <br><br>Mail could not be sent. Error -3176&quot; <br><br>What I wan...

Display bitmap on main frame window
When my MDI application starts up, the main frame window is a big ugly grey rectangle. I would like to display a nice bitmap as a background for the application. Any suggestions how I might do this? --- Al. "TVR Fan" <nosuch@address.com> wrote in message news:O%232CR03MEHA.3096@TK2MSFTNGP12.phx.gbl... > When my MDI application starts up, the main frame window is a big ugly grey > rectangle. I would like to display a nice bitmap as a background for the > application. > > Any suggestions how I might do this? http://support.microsoft.com/default.aspx?scid=kb%3...

Embedding Visio in .net based Windows Forms Application
Hello, I am using Visual studio.net to programmitically control Visio 2003. I read some of the MSDN articles about this topic and trying to develop some small sample programs. I got some sample program devloped in VB 6.0 that just opens Visio document with basic diagrams template with Basic shapes and then adds Rectangle shape to the drawing and then sets the text to "HELLO WORLD". so The VB code to achecive this task is as follows. Sub HelloWorld () 'Instance of Visio Dim appVisio As Visio.Application 'Documents collection of instance Dim docsOb...

text box as label to appear when subreport does
I have a text box used as a label with the control source: ="Attributes" +IIf(IsNull([FillTemp_Label]),Null,"") I'd like to add a subreport to this: srptFGProcessingPacketPouchAtts. Can this be done? Thanks! -- www.Marzetti.com What do you want to do? -- Duane Hookom Microsoft Access MVP "JohnLute" wrote: > I have a text box used as a label with the control source: > ="Attributes" +IIf(IsNull([FillTemp_Label]),Null,"") > > I'd like to add a subreport to this: srptFGProcessingPacketPouchAtts. > > Can this be...

Suppressing
I have a report that has a table with basically one grouping. I have sever rows of the same group and another table inside each of the rows. So basically I have 25 rows od the same group with a different table inside eavh row. So table inside of a table. My problem is that whenever one of the group tables has no data, it still shows whitespace and I cant get it to suppress when its blank. Any ideas? hi, can you set the width=0 and then set the visible for that row=false. Regards VB "Ben Watts" wrote: > I have a report that has a table with basica...

Suppress X Axis Scaling
I have a table I’m charting. There are 15 textual descriptions in a column and 6 date field headings. When I grab that table and switch the “Series In: to rows, the chart builds correctly – to some degree. Though there are only 6 contiguous date field headings, the dates are not. Is there a way to suppress the X Axis Scaling to show only the dates associated with this table, not adding filler dates that do not exist for this data? Sincerely, Arturo D'oh! An apostrophe at the beginning of the date does the trick… "Arturo" wrote: > I have a table I’m charting. Th...

Generation of new subform record based on combobox AND main form
I have an unbound combobox (cboDOVSearchChart) whose row source is a query that brings up all of the dates associated with a particular medical record number. It consists of two columns, chart ID (hidden), and date. Each combination of MR and date yields a unique (autonumber) chart ID. The first column serves as the link field to associate with a subform that is based off of chart ID and contains all of the chart information. Is there any way to use the NotInList event for this combobox to create a new record in the subform that will contain the next autonumber for Chart ID with the MR number ...

OnCreate of CFrameWnd based splitter pane gets called twice!!!
Hi All, I have a splitter window, in which I want to have 3 panes (as vertical columns). My primary requirement is I want a menu inside one of the panes, i.e, menu should belong to the pane and not the whole window. To achieve this, I put a CFrameWnd derived class inside the pane. This CFrameWnd derived class has the menu I want. Now, my problem is that after I do this, the OnCreate of the FrameWnd is getting called twice all the time. Can anyone help me know why this is happening? Or even better, does anyone have an alternate solution to putting a menu in each pane of a splitter window? ...

suppression
Hi, my problem is the suppression of a recording to àpartir of a list indeed when I want to remove a customer for example an error message is posted: impossibe to remove contact the system administrator Thanck You Please stop workflows related to that list / record and also close activities related to that. It is basically because useable record. -- Regards, MS CRM Certified Professional http://microsoftcrm3.blogspot.com Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com "ahmed" wrote: > Hi, my problem is the suppression of a recording to ...

Suppressing VBA Errors
I think I've seen a way to prevent (supress?) errors in VBA but hav forgotten just how I should do it. This is my code. As you can see, it's to update data in a Currenc Conversion file that I made. Sub CurrencyUpdate() Range("C5").Select Selection.QueryTable.Refresh BackgroundQuery:=False End Sub Sometimes I get a Run-time error '1004' message saying "This web quer returned no data". Any solutions? Would appreciate any help -- Message posted from http://www.ExcelForum.com Hi have a look at on error resume next and on error goto 0 -- Regards Frank Kab...

virtual CDialog base class
I need to add some functionality to a few dialogs AND property pages in my program. Since property pages are derived from CDialog, I thought that in order to avoid confusion I'd create a dialog class with required behaviour with CDialog as virtual base class. Problem is that the moment I change class definition from: "class CMyDialog : public CDialog" to "class CMyDialog : virtual public CDialog" compiler emits errors like below in WM_ON_PAINT() (and other ) message map definitions. error C2440: 'static_cast' : cannot convert from 'void (__thiscall CMyDial...

Changing main menu colors
I'd like to change the background gray and selection color for the main menu. What's the simplest way to do this? I have an owner draw menu and am overriding DrawItem and MeasureItem but it's a lot of work just to get this color change. I'm thinking there has to be something simpler. Thanks much Eric You are out of luck to do this if you are talking about menu bar. You will need to onwer draw the pop up menus in order to change the color. You could make main menu bar a toolbar and then its color (relatively easy and code is available at different sites). --- Aja...

Hiding fields based on security privileges
Is it possible to hide a field/tab based on a user's security privileges? I know how to do basic field/tab hiding, but how can check for the user's privileges? Presumably, there is a GUID for each security role, so I am just wondering what the code is for this. Cheers There is no published code for this. C360 have a field security addon or you will need to go researching to build the code. ============================== John O'Donnell Microsoft CRM MVP http://www.crowecrm.com "WiLLerZ" <willerz69@hotmail.com> wrote in message news:1162163816.765962.160960...

suppress detail in a report?
I have a trial version of MS Money 2004. I want to generate a report based on Classification 1 and would like to see a summary only with no detail.. just the amounts for each Classification. I do not see an option in the custom report generator to suppress the detail (in Rows & Columns). Have I overlooked this option? If so, how do I accomplish this? Thanks! Have you tried Spending by Category with Customize|Rows & Columns|Rows:Classification 1 and Columns:Totals Only??? "speedlever" <speedlever@yahoo.com> wrote in message news:965b1a76.0308130430.69d03f29@posting.g...

Tabbing between a main form and a subform
Normally when dropping a subform into a main for the tab order is automatically set so that when you hit 'Tab' on the last record of the main form it moves the cursor to the first record of the sub form. I have created a main form linked to a subform but no matter what I try the tab simply cycles in the main form. (The subform does not appear in the tab order of the detail section of the main form.) Is there some setting so that I can get it to move to the subform? Thanks -- Aussie On Mon, 16 Nov 2009 23:06:02 -0800, Peter <Peter@discussions.microsoft.com> wr...

Workflow based on create Product entity -- possible?
Hello all, Sorry if this is an elementary question -- I'm kind of fumbling my way around on this, and I haven't found any documentation or resources on any other sites that directly answer it. The basic workflow I want to accomplish is for our accounting department to be notified (via email) when a product specialist adds a new Product to the system. I'm trying to use Workflow Manager to create a new workflow based on the create event for the Product entity type, but that type isn't in that primary list in Manager. I see maybe 25 built-in types in there, but not Product. Th...

Auto fill Column based on data in other columns
I have a report I'm downloading into Excel each day. Columns A, B, and C have the same number of rows populated. Columns D and E don't. I want to populate columns D and E with code the same number of rows Columns A, B and C are. I want to auto fill Column D with the text "ABCD" and Column E would be the current date in 06/05/06 format. I would like to put this code into an existing Macro. Any help you can give me is appreciated. Double click on the fill-handle http://www.mvps.org/dmcritchie/excel/fillhand.htm If you want to simulate with a macro Filldown as...

For the selected section and the following one: unlink headers from previous section
Dear Experts: Below macro unlinks the current headers from the previous section. How has this code to be expanded if I also wanted the following section's headers to be unlinked from the previous section? Help is much appreciated. Thank you very much in advance. Regards, Andreas With Selection.Sections(1) ..Headers(wdHeaderFooterPrimary).LinkToPrevious = False ..Headers(wdHeaderFooterFirstPage).LinkToPrevious = False ..Headers(wdHeaderFooterEvenPages).LinkToPrevious = False End With You can use With ActiveDocument.Sections(Selection.Sections(1).Index + 1) as the f...

Recipient Policy based on OU?
Read through a few posts and searched a bit on how to set up a Recipient Policy based on a users OU and not having a lot of luck. This is what I do: 1) ESM 2) New recipient policy (email property pages only) 3) Name it 4) Modify 5) Change the find to "Organizational Unit" and choose Find Now 6) Select the OU(s) I want, hit OK 7) Brings me back to the General tab and the filter rules are always (&(ou>="")) 8) Tried putting the exact name in the Find field and get (&(ou>="")(name=MyOU*)) but never seems to do anything. What am I missing? I ...

Suppress UI of Dialog box.
i want to suppress the ui show after installing the cab in the PPC using SHELLEXECUTEINFO. i have tried sei.cbSize = sizeof(sei); sei.fMask = SEE_MASK_FLAG_NO_UI | SEE_MASK_NOCLOSEPROCESS ; sei.hwnd = NULL; sei.lpVerb = _T("open"); sei.lpFile = tszCabPathName; sei.lpParameters = _T("safe /noui /nouninstall /delete 0"); sei.lpDirectory = _T(""); sei.nShow = SW_HIDE; still it shows successful installation of cab, and i want to avoid that dailog box. Can u please help me? Thanks, Bhavin "Bks" <bhavinshah.com@gmail.com> wrot...