Avatar of dshi15
dshi15Flag for United States of America asked on

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.
Microsoft SQL Server 2008SSRS

Avatar of undefined
Last Comment
dshi15

8/22/2022 - Mon
Tony303

Any error messages?
There is no data probably, is your query working in the dataset?
SOLUTION
Jim Horn

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
dshi15

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.
ASKER
dshi15

report is working on the server, I just download it and try to modify some string.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Tony303

Are you editing the .rdl only?
Are you editing in BIDS? or notepad? or something else?
ASKER
dshi15

In BIRS
Tony303

The .rdl has to be part of a project?
Are you seeing the rdl as an XML?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ValentinoV

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).
Mike Eghtebas

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
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ValentinoV

"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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
dshi15

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.