SSRS report preview

Hi Expert,

I have a report,  design is good, but when I click preview, nothing happen, no error, all gray,

any idea?

I tested database connection is ok,

Thanks in advance.
LVL 1
dshi15Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony303Commented:
Any error messages?
There is no data probably, is your query working in the dataset?
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Another way I've seen this happen is that if your report has a tablix control, and the detail section was inadvertently deleted.  Unfortunately I haven't discovered a way to re-insert a detail section in a tablix, which would meand you'd have to delete it and re-create it.

>design is good, but when I click preview, nothing happen,
Just out of curiosity, how do you know that the design is good?
0
dshi15Author Commented:
Dataset used a store procedure, there are a Parameter on the report, when I click on review

the parameter disabled, I couldn't pick value from the list.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

dshi15Author Commented:
report is working on the server, I just download it and try to modify some string.
0
Tony303Commented:
Are you editing the .rdl only?
Are you editing in BIDS? or notepad? or something else?
0
dshi15Author Commented:
In BIRS
0
Tony303Commented:
The .rdl has to be part of a project?
Are you seeing the rdl as an XML?
0
ValentinoVBI ConsultantCommented:
After attempting the preview do you get anything in the Output window?  Hit CTRL + ALT + O if you don't see that window (or View > Output in the menu).
0
Mike EghtebasDatabase and Application DeveloperCommented:
You have two options to see the report:

1. Click on Preview tab or
2. Run the using F5

Test using F5. After that option 1 also may start working. I have no explanations why it is so. Try it to see if it works for you.

Mike
0
Tony303Commented:
How about trying by editing the report from the report manager on the SSRS. Open the report in Report Builder.

Can you test the report here?
If so, you could make your change.
Test it.

Please do not save the report in Report Builder until you are happy with the result.
This is a "sloppy" method of working however.
If you do actually have a BIDS project for this report then your code in the BIDS project is now outdated compared to the report we just changed at the SSRS in the Report Builder app.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ValentinoVBI ConsultantCommented:
"2. Run the using F5"

In BIDS that won't have the desired effect.  It will use a project property, StartItem, to decide what report gets run.  If the setting is empty then it will result in an error.
0
dshi15Author Commented:
Thank you very much for help, actually report design isn't good, it didn't run on report server anymore, it called a CLR function and probably the CLR function changed and caused a problem.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.