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.

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...

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.

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().

Is there a method to check if a section in the report is suppressed? I have multiple subreports in multiple report sections and want to display a specific footer image (in page footer) depending on what section is displayed.

I don't know if there is a good outer join work around when your not able to select the outer join option in the link between two different data sources. I'm trying to do a full outer join between a SQL database and SAP BW data. I thought about doing two left join sub reports but where I'm...

I was wondering if there is a good work around for creating a chart that is from a formula (%) from 2 running totals. I know the issue is that with charts you can't create graphs from the formulas of running totals since charts are rendered beforehand. I currently have couple of groups already...