Search results for query: *

Has anyone had a issue with a mismatch codepages when pulling data from a datasource? If yes, how do you go about fixing it since it's occurring on the data fetch.

Yep, that is correct. For some reason I'm getting a blank page at the end. If I take that "showPage = N" formula out that blank page disappears.

I know there is a option in the section expert to suppress if blank but the issues I’m running into is that I also have code in that same section of showPage = N to suppress. The problem seems to be that code is not hiding the blank subreport so I wasn’t sure if there was another way to...

If your going to use wildcards asterisk you need to use “LIKE” and not “IN”. IN doesn’t accept wildcards.

Not sure if it's possible but can you have a formula that is generated in the detail's data displaying a header or group header?

What's the proper method to set the decimal of a field to be a specific length? Example is that I would want all to be 0 decimal place but a couple rows I would like it to expand to .00 decimal places.

bborissov, thanks that's what I was looking for. Andrzejek, thanks for the info on the joins. I already have a printout of those joins and was struggling with only selecting after a initial select. :)

bborissov, to take it another step further how would I only pull from Table B only if Column A is found in Table A.

What would be the best process to union two tables together based on if Table A has data I would only pull data from Table B? SELECT Column A, Column B, Column C FROM Table A union Select Column A, Column B, Column C FROM Table B So in the end I need to union two tables but only pull data if...

I'm currently using Previous() to do a running counter since I'm hiding some rows based on a formula. What's the best way to start the counter if previous doesn't work on the 1st row since there is nothing for it to compare against? I can't used ISNULL().

Sorry for the confusion. Just trying to process the vision I’m trying to get working. :)

So do I need a page footer for each report footer section or for each image? Example 5 page footer or 3 page footers?

Well i've restructured and have RF_a - F but I'm only using 1 Page Footer since using multiples seems to throw off my page formatting in the subreport. I have: RF_B RF_C RF_D RF_E RF_F 3 Images are located in PF_A. Image 1: needs to display with RF_B, C & D Image 2: RF_E Image 3: RF_F I've...

Here's the suppression formula for the image. Whileprintingrecords; Booleanvar flagE; flagE = False//note no colon I used what you stated to use for the Page Footer on the image. I have the false formula in the Report Header and in the Page footer B which is after Page Footer A where the...

Can it not be applied on the image?

I tried to place the suppression on the image and not the page footer section and it isn't working since one image keeps on showing on the wrong pages.

Amazing logic lbass. That seemed to do the trick.

No the sub isn't a multipage subreport. I'm using suppression and using the shared value I get back to suppress or not. Also I had a type in that Note 1 and 2 are in the "Page Footer" not report footer. Problem I'm running into is that Note 1 is showing on subsequent pages since its...

Ok that's not going to work with what my vision is. It works for getting the page footer note to appear but it's appearing on every page but I only need it on Page A. Example is: Report Footer A - Subreport 1 Report Footer B - Subreport 2 Report Footer C - Subreport 3 Report Footer D -...

lbass, I'll give that a try and see what happens.