It sounds like you want to add a total or subtotal in the report. I found a tutorial that I think will answer your question.

Add total...

I have a report where I use values from a dataset in the header. I just use an expression rather than code at the report level to access the data.

I...

I enjoy getting the daily newsletter, but I value your well being and understand why you are making this decision. Thank you for all you do.

The screenshot doesn't show up so I don't know exactly what your layout is.

What if you set the Hidden property on your comments subreport to hide the report when there...

I think this will produce the summary numbers that you seek. Maybe there's a better way that I haven't thought of yet because this solution uses bit masking.

            
March 11, 2021 at 8:00 pm
            
#3856656

            
            
                                                
        

Well it looks like you have a few different issues to resolve only some of which I can help with.

First, here are a couple PowerShell commands that can help you...

I think the cleanest option, if it is an option for you, would be to create a new report that only presents data for one student, and then make calls...

Does your SSRS report display results for just one student and you need to run the report again for each student? If so, I may have a solution for you.

If...

I think it's probably in an ESRI namespace rather than the .NET Framework, but as to exactly which one I don't know because I haven't worked ESRI.

My guess is that "if at one stop i have more than one address then i have siblings" is lost in translation, and I think you need to read it...

Best wishes for a speedy recovery. I have found your blog helpful on multiple occasions.

I don't have an exact answer for you just some information that may get you closer to the answer if you haven't already found these resources. It looks to me...

I think in the case that the last action was a reseed, then it is that value.

DBCC CHECKIDENT ('MyTable', RESEED, 20);

I've used CHOOSE to translate an error number into a descriptive reason in SSRS.

DECLARE @ErrorNum int = 2;
SELECT CHOOSE(@ErrorNum, 'Failed due to reason X', 'Failed due to...

There might be a better way to do this as this is a proof a concept. I'm not sure what you are trying to print on the postcards so this...

• This reply was modified 4 years, 11 months ago by  bfoster-764881.