No selecting-out null records from the data set before generating report? Bruce A. Chitiea SafeSectors, Inc. 112 Harvard Ave #272 | Claremont CA 91711-4716 USA (909) 238-9012 m | [email protected] On Nov 10, 2022, 14:53 -0800, [email protected], wrote: > I am trying to figure out how where the picture names/links are stored. > How do you know how many picture placeholders to assign in the report? > If you have a record in Table1 and the corresponding picture names are stored > in Table2 on a 1 to many relationships, which I believe would the recommended > approach, then you can create a parent and a child table in your report, and > I will print only pictures that are available and not display blank > placeholders. > I will guess that your application is probable different > You can always create a blank picture that is basically a blank, thin sliver > and then, when you get your variables run something like this: > IF vFilename3 IS NULL THEN > SET VAT vFilename3 = ‘c:\BlankPic.jpg’ > ENDIF > This will display the blank picture that should not take much space. > I am not sure how your data is structured in you application and hopefully, > the above is of help. > > Javier, > > Javier Valencia, PE > 913-915-3137 > > From: 'Karen Tellef' via RBASE-L <[email protected]> > Sent: Thursday, November 10, 2022 1:46 PM > To: [email protected] > Subject: Re: [RBASE-L] - A "null" variable image > > I'm guessing I have to go with a "null" image to display. Certainly easier > than the code to make the images visible or invisible. > > I do not have to collapse the space, only one part prints on a page and the > photos are at the bottom > > Karen > > > > > -----Original Message----- > From: Robert Thompson <[email protected]> > To: [email protected] > Sent: Thu, Nov 10, 2022 2:28 pm > Subject: RE: [RBASE-L] - A "null" variable image > Not sure about a setting, perhaps someone else is. > > But if not, you might consider a "default" image that is a simple white or > transparent square. Then predefine all 4 variables to "Default.jpg" (or what > ever). > > Then if you do not assign an actual image, the default will always display. > No real code changes other than the variable filename predefault. > > This would also allow you to display a default image for information or some > other nice option. > > However if you are wanting to collapse the print space when both image 3 & 4 > are null, this would not help. > > And as you stated, the make invisible code would work as well. > > > > Robert Thompson > TTC Inc. > 219-363-7441 > > > -------- Original message -------- > From: 'Karen Tellef' via RBASE-L <[email protected]> > Date: 11/10/22 1:53 PM (GMT-05:00) > To: [email protected] > Subject: [RBASE-L] - A "null" variable image > > Hopefully I can explain this. I have attached a print-screen because my > embedded images don't show in the list emails. > > Each part we print on this report can have unlimited (or no) photos saved on > disk. We will print no more than 4 on the page, so I am pulling 4 random > photos into my text variables (vfilename1, 2, 3, 4), and Variable Images are > located. > > Works great except when I have null variables. As shown on the attached, > vFilename1 and vFilename2 have values and print the photos just fine. But > variables vFilename3 and vFilename4 are NULL (as shown below, my null setting > is actually ' ' when printing but I changed to -0- to show you the list). > > The null ones have that weird white/red thing. I'm wondering if I am missing > a setting for these. I know I can write code to make controls invisible, but > I was hoping I'm missing something simple. > > Any clues for me? > > Karen > > Variable = Value Type > ------------------------------ ------------------------------ > ------- > vFilename1 = F:\Quality\123773-A.jpg TEXT > vFilename2 = F:\Quality\123773-B.jpg TEXT > vFilename3 = -0- TEXT > vFilename4 = -0- TEXT > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/1588128635.1982897.1668106391324%40mail.yahoo.com. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/636d510f.810a0220.9f9d.04b8SMTPIN_ADDED_BROKEN%40gmr-mx.google.com. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/1444136802.2005358.1668109576636%40mail.yahoo.com. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAEoT7VLG%2B2xPhcccRyrrDaQBAAAAAA%3D%3D%40vtgonline.com.
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/dd5f754e-cd95-41ca-b369-a74efd84ecb5%40Spark.
