Report Summary with Data Rows

[jp2code]

I am (still) working on my Sales Report.

The Report Summary is huge, and it has been taking me a really long time to write. Partially because the data isn't there, partially because I do not understand the business logic that it uses, and partially because I'm new to this tool.

Now I am to a point in the Report Summary section where they want me to summarize the tax codes that were reported in the Data Band section. For each Tax Code that was used, I write out the Tax Code, Tax Code Description, Tax Rate, then (using the data from the Data Band) the Sum of the Gross Sales, Taxable Sales, Non-Taxable Sales, and Taxes Collected.

The problem is that there could be 1 Tax Code used or several Tax Codes used.

Is there any way to display this data in a Report Summary section?

I have attached my report. I started to add a new Report Summary section below the first, but then I realized it wasn't going to do what was required.

[jp2code]

I'm going to add to this.

I am also trying to figure out how to apply Conditional Formatting to my output.

In my attached report above, I have a Parameter Variable p_intWhichFormat that is passed in before the Report is displayed.

The default value is p_intWhichFormat == 0, meaning show all the details.

If p_intWhichFormat == 1, I need to hide [HeaderBand1] and [DataBand1].

If p_intWhichFormat == 2, I need to hide [HeaderBand1], [DataBand1], and [FooterBand1].

The doc Report Internals > Conditional Formatting > Conditional Formatting says to set conditions using this screen:



I can get to the screen, but the only option I see is Highlight Condition:



How do I toggle the object's Visible property?

In the .Net Reports' HTML Preview tab, I can see the [HeaderBand1], [DataBand1], and [FooterBand1]. When I attempt to publish the report, however, only the Summary Bands [ReportTotalsBand1] and [CodesReport1] display.

I am not seeing any errors. How do I troubleshoot why data is not appearing?

[HighAley]

Hello.

You should use Highlight Condition. Set the Field is to expression. Then write an expression and uncheck the Component is Enabled option. When the expression is true the component will be disabled.

As about your first question this depends on what you need to show, just a list of Tax codes or you need to show additional info. Usually you should put a Panel on the Summary Band. Then put a Data Band on this Panel with necessary data source. You could set Filter there if you need. And show necessary information there. It's possible to add several data bands on the one report page.

Thank you.

[jp2code]

Thanks for the response!

I've got the Highlight Conditions added. They do not seem to be doing anything different whenever I run the preview with different values set in the parameter, though. I'm still working on it. If I find out something, I will post up.

On the Tax Codes, I need to do something like this (using a mix of SQL and Report.Net features):

Code: Select all

SELECT VwTaxCode.TaxCodeName, Sum(DataBand1, VwInvoice.TaxableValue), Sum(DataBand1, VwInvoice.NontaxableValue)
FROM DataBand1 -- DataBand1 is filtered VwInvoice data
JOIN VwTaxCode ON VwTaxCode.TaxCodeId=DataBand1.TaxCodeId
WHERE VwTaxCode.TaxCodeId IN (SELECT DISTINCT TaxCodeId FROM DataBand1)

So, I need distinct Tax Code Names from the Data band showing separate Sums for the Taxable and Non Taxable items for each Tax Code.

[jp2code]

Hey Aley,

Is there a way to use custom functions or methods? I see Event Handlers on the Properties pages and there are built in functions.

Would it be possible to link in a code file (like with a `using` statement) so that I could call my custom code?

[HighAley]

Hello.

You could add any assembly to the Referenced Assemblies property of the report and use methods from it.

ReferencedAssemblies.png (43.2 KiB) Viewed 3372 times

Also you could write your functions in the Code tab before auto generated code and use them in the report as well.

code-tab.png (11.3 KiB) Viewed 3372 times

Thank you.