web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / ssrs show data in the ...
Microsoft Dynamics AX (Archived)

ssrs show data in the footer

(0) ShareShare
ReportReport
Posted on by ALAhmed 916

HI there ,

The green part is what i have in the report body and i want to remove the taxValue field and TaxAmount field in the dataset and display this field in the footer like the blue part .

Is it possible to show data from database in SSRS footer?I tried but the only option i know is to show first record from dataset. But I want to show all records (I just need to show two column) one by one on each page.

IS there any way (ssrs expression) to loop through the rows of a dataset and create field in footer part ?
5141.Capture.PNG

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 236,859 Most Valuable Professional on at
    RE: how to use loop in ssrs expression

    Loop is a statement, not an expression. What do you want to do inside the loop? Maybe you can write an expression that provides the same result (e.g. a sum of values).

  • ALAhmed Profile Picture
    ALAhmed 916 on at
    RE: how to use loop in ssrs expression

    Martin Thanks for the quick reply,may you suggest to me an exemple of expression to display TaxValue and TaxAmount fields in Footer like i explain in the screenshot

    I create new text box in the footer and  treid this expression :

    =Lookup(Fields!BillingCode.Value,Fields!BillingCode.Value,Fields!TaxValue.Value, "FreeTextInvoiceDS")
but i have this error Lookup is invalid. InvalidIdentifier
  • Martin Dráb Profile Picture
    Martin Dráb 236,859 Most Valuable Professional on at
    RE: ssrs show data in the footer

    Your screenshot doesn't really explain your specific requirements. The green section shows individual transactions, while the grey section shows totals, therefore I suggested to sum the values. Please either confirm it (then you can use SUM() function), or explain what else you want to do with those values.

  • ALAhmed Profile Picture
    ALAhmed 916 on at
    RE: ssrs show data in the footer

    Hi Martin,

    To get the what i want i was create a new table in the section body .Now i have new requirement i want this new tablix repeat on all page like a footer.

  • Martin Dráb Profile Picture
    Martin Dráb 236,859 Most Valuable Professional on at
    RE: ssrs show data in the footer

    You can easily repeat things by putting them to a footer, but it's intended for static data. I can't imagine how your matrix would be populated. I think it's not a feasible design.

    A workaround might be using a tablix with a header repeated on every page and putting your matrix to the header.

  • ALAhmed Profile Picture
    ALAhmed 916 on at
    RE: ssrs show data in the footer

    Martin, for the first time i shared a screen that contain what i'm looking for. so when i can't show the result in the footer section(can't create tablix in footer)   i was  create it in the body section for using sum() function and grouping. So actualy in body section i have tablix that i want repeat it in all page.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans