question

SSRS-VS avatar image
0 Votes"
SSRS-VS asked ZoeHui-MSFT commented

Report Builder do not open Datasets when I modified the stored procedure in SSMS

I have my datasets inside a folder in my SSRS web portal. This datasets are asociated with a stored procedure in SQL Server.
I create datasets, I run them to see the result and then I use them in my mobile reports.
Everything is ok.

The problem comes out when I update the stored procedure in SSMS and add new columns in the result. When I open the mobile report from Mobile publisher and I click "update data", nothing happen. This is because I must first run the dataset from report builder to regenerate the new columns. But when I click in de dataset "edit in report builder"
This happen:

104155-imagen.png

It remain loading some time and then it close and do not open the dataset (it has no relation if I use windows credential or an sql user). This don't happen if I open a dataset wich stored procedure has not been updated (updated with new columns). Now, what I have to do is create a new Dataset with the update procedure and recreate the mobile report...

What is happening? Why I can't open datasets with Report Builder when I update the stored procedure?

Thank you.

sql-server-reporting-services
imagen.png (25.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered SSRS-VS commented

Hi @SSRS-VS,

I test locally that when I edit the dataset via report builder on web portal, it will keep ask for credential each time when I edit the dataset.

And then I edit with user name and password and choose save password with connection.

Even though the store procedure is updated with new column, it won't ask for the credentials.

You may have a check.

Regards,

Zoe


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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SSRS-VS avatar image
0 Votes"
SSRS-VS answered ZoeHui-MSFT commented

The problem is that I cannot edit the dataset because the Report Builder do not open the dataset. When ask me for datasource credentials, after I write them, it closes. And this only happen for those datsets wich stored procedure has been updated in SQL Server Management Studio.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please make sure that you have entered the correct use name and password.
When you select Use this user name and password, a user name and password must be supplied to access the data source. For a SQL Server database, the credentials might be for a database login. The credentials are passed to the data source for authentication.

0 Votes 0 ·

Yes, I do that with all my datasets. I write the sql credentials and then the Report Builder opens correctly the dataset. But when I made some updates in the stored procedure and try to open that dataset (who is also used by a mobile report) the report builder close and it not show any error message

0 Votes 0 ·

I couldn't reproduce the issue, you may post this issue here.This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

0 Votes 0 ·