How I can generate report with all pull requests and their created and completed time?

Question

How I can generate report with all pull requests and their created and completed time?

Dominika Stawowa 0

I need to generate a report with number of pull reguest, title, created time and completed time.

Olaf Helper 47,441 Reputation points

2023-01-24T10:24:53.5833333+00:00

Your question is more then vague and not clear for me. What's the data source? What for pull request?

Please provide much more details.
Dominika Stawowa 0 Reputation points

2023-01-24T10:33:54.84+00:00

Thanks for your reply. I need a report that will include the creation date and completed date of the PR. I need this to calculate PR lifetime. I have a view with the list of pull requests and created date or completed date, but unfortunately I can't to generate this view to file or query. Do you have any ideas how I can do this?
Olaf Helper 47,441 Reputation points

2023-01-24T10:42:58.4966667+00:00

That's still really to less on information.

Please post table design as DDL, some sample data as DML statement and the expected result.

1 answer

Your answer

Olaf Helper 47,441 Reputation points

2023-01-24T10:24:53.5833333+00:00

Your question is more then vague and not clear for me. What's the data source? What for pull request?

Please provide much more details.
Dominika Stawowa 0 Reputation points

2023-01-24T10:33:54.84+00:00

Thanks for your reply. I need a report that will include the creation date and completed date of the PR. I need this to calculate PR lifetime. I have a view with the list of pull requests and created date or completed date, but unfortunately I can't to generate this view to file or query. Do you have any ideas how I can do this?
Olaf Helper 47,441 Reputation points

2023-01-24T10:42:58.4966667+00:00

That's still really to less on information.

Please post table design as DDL, some sample data as DML statement and the expected result.

Answer 1

ZoeHui-MSFT 41,491

Hi @Dominika Stawowa

If you have a view with the list of pull requests and created date or completed date, you may add another dataset in the report with sql query and then design your report.

See: Create SSRS Report using Views

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

ZoeHui-MSFT 41,491 Reputation points

2023-01-30T08:15:33+00:00

Hi @Dominika Stawowa

Do you have further question on this, could we offer more support?

If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Share via

How I can generate report with all pull requests and their created and completed time?

1 answer

Your answer