Skip to Content
avatar image
Former Member

Using results of a report in another report

Hi:

I have this issue across multiple reports.

Most of my customers like to see data from the past month and the previous month in the same report. My database is set up with an 'as of date' flag so we can pull data from specific points in time.

For example if I issue a payment last week and is voided this week, I can pull a report as of last week and I will see that payment as "issued", in the same way if I pull the same data as of today that payment should appear as voided.

I can produce a report with a single 'as of date'. What I want to do is I want to use the report produced last month and attach the data for this month. I tried using union in the same report , adding a query from the universe, etc. but it gives me only one option to set the 'as of date', rather than giving me two options for the as of date.

I'm using web intelligence applet and I don't have access to SQL.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 09, 2017 at 10:34 PM

    Sure:

    lets think that this is my report for January first, obviously is dummy data.

    The data for this row will change during the month, when any value in this row is updated the as of date also is updated (if is a different day)

    Next month I want to get the same report, and it works fine. The problem is when I try to use 2 different "as of date". I'm thinking that If I could somehow use the data from my previous completed report then I won't have to worry about solving how to get around the issue of the "as"of date

    Hope this makes sense. I can give more examples if you want.

    Thanks, I really appreciate your help

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 10, 2017 at 10:17 AM

    are you maintaining the historical data in Database table?If historical data is present in the table based on the date then you can display one week or one month data in report.

    You have to add the report prompt on date object to get the data based on the user prompt.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15, 2017 at 08:46 PM

    Hi:

    Yeah, your assumption is correct, I maintain my historical data. The issue is when I make a union query for example, I add an "as of" for the user input and it show only one for both queries, I wish I could run a report where I can make a query with an as of 01/01/2017 union as of 2/01/2017, I can hard code the dates on the filter but once I run my report the user prompt always shows one "as of date" option. Not sure if is my set up or this is yet another BO long list limitation

    Thanks

    Add comment
    10|10000 characters needed characters exceeded