Post reply

Calculate dynamic columns

  • October 6, 2016 at 2:55 am

    #330730

    Hello team,

    On Sql Server Report Builder, I'de like to know how to calculate dynamic columns or how to deal with columns based on their names please.

    Here is the problem:

    On the column "Delivery_Status" there will be 4 dynamics columns on runtime (DELIVERED, EXPIRED, UNDELIVERABLE, " "), i want to programme the "Success rate" column with:

    Succes rate = delivred x 100 / SMS_MT (SMS_MT is the column with no name)

    So when i want to get the DELIVERED data for begin i tried

    Success = ReportItems!Total1.Value

    http://imgur.com/a/KYdDc

    with this command it gets the last data (UNDELIVERABLE) instead (DELIVERED), see the screenshot

    http://imgur.com/a/b1s9Y

    Please how to programm something like this ?

    =(Fields!Delivery_Status.Value, "DELIVERED") *100/SMS_MT.Value

    (SMS_MT is the column with no name).

    Thanks in advance.

  • October 6, 2016 at 3:52 am

    #1905112

    or how to get value of a specific cell please.

  • October 7, 2016 at 2:03 am

    #1905321

    I'm actually struggling to work out what you're after here, and I'm not really sure I understand your post. I'm really confused by your mention of having an unnamed column.

    The best thing to do to help users here provide an answer to getting your data to look how you want is to provide us with your DDL and Sample data. If you're then putting that data into a different format in your statement, ensure you include a sample SELECT statement as well.

    Considering that you have certain expectations of how you want your data to look as well, provide a sample of how you want your end data for your sample data to look. Then everyone is working from the same page.

    Although this is SSRS, you're still querying data, and expecting certain results, so this is all relevant.

    See Jeff's[/url] on best practices on posting here. You'll get much quicker, and better responses if you follow it 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 9, 2016 at 3:11 am

    #1905548

    Hello, thanks for your replay.

    I just want to multiply the "DELIVERED" data column (x100) and devide it by the unnamed column, to have the success rate, and i can't do it because "DELIVERED" is a dynamic column, so it's not defined ...

    Hope i was inderstood 🙂

  • October 9, 2016 at 10:33 am

    #1905568

    Sounds like you need a Matrix on your report, but it would be a lot easier to solve with some data.

    Can you post some sample data?

    A create table statement and some inserts... enough to reproduce the problem.

  • October 10, 2016 at 3:09 am

    #1905612

    Hello,

    You want me to share sample data like what please ? here is my skype: gangsta-loving

    Thanks in advance.

  • October 10, 2016 at 3:19 am

    #1905614

    See the link in my previous post, it tells you how you should share sample data.

    Sending stuff over Skype isn't great for a number of reasons.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • October 10, 2016 at 11:22 am

    #1905728

    We need DDL statements for your tables, inserts, and the queries with any parameters you are using in your report to pull your datasets.

    Please start from the top. Just like when you are planning out the design of your ssrs report. Whatever information you need , we will need as well to a certain level.

    If you have not, please read the link on how to post to forums that was provided to your earlier.

    ----------------------------------------------------

  • November 15, 2016 at 11:58 pm

    #1912679

    Echoes like you need a Matrix on your report; however it would be a great deal less demanding to explain Help with an essay[/url] few information. Could you post some example information? A make table articulation and a few additions... enough to replicate the issue.

  • May 24, 2017 at 8:28 am

    #1943992

    it is hard to make Sql server report builder which is known for the users and calculate dynamic columns on routine problems. There are lots of students at this level with some helping persons like research paper help and it would be personally delivered from the qualified writers.

  • May 31, 2018 at 1:12 pm

    #1992542

    http://cheatskit.com/  download your favorite games

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply