Link to home
Start Free TrialLog in
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.
Avatar of Tony303
Tony303
Flag of New Zealand image

Any error messages?
There is no data probably, is your query working in the dataset?
SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dshi15

ASKER

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.
Avatar of dshi15

ASKER

report is working on the server, I just download it and try to modify some string.
Are you editing the .rdl only?
Are you editing in BIDS? or notepad? or something else?
Avatar of dshi15

ASKER

In BIRS
The .rdl has to be part of a project?
Are you seeing the rdl as an XML?
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).
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"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.
Avatar of dshi15

ASKER

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.