Link to home
Start Free TrialLog in
Avatar of fruhj
fruhj

asked on

javascript error on page of MS SQL Reporting Services - Datasource.aspx?createnew

Hi All,

 Still trying to learn SQL Server reporting services and having some trouble.

 I'm trying to create a new datasource (using the /reports virtual directory, not via visual studio)

 I created one before with no problems,

  Now on that page I get an javascript page and the familiar ! error sybol at the bottom left of IE

  The error is line 388 char 3 error: Object expected Code:0 Url   https://www.mysite.com/Reports/Pages/DataSources.aspx?CreateNew=True...

  Line 388 is pointless, becuase when I view source I get a file with 294 lines. (maybe it's including the contents of the external javascripts?)

  - Anyhow,

    After I installed RS, I had to move it to a differnent website (didn't need it on default) - that worked almost fine, except I got a few errors that seemed to be related to the lack of an SSL certificate - So I created one with cert server and installed it on IIS - I think its' around then that it stopped working, but hard to say, I've done a lot over the past 3 days.

  If this has ever happened to you, please post a reply, even if you don't have the answer so I can guage how common this is.

Thanks,
Jack

ASKER CERTIFIED SOLUTION
Avatar of simon_kirk
simon_kirk
Flag of United Kingdom of Great Britain and Northern Ireland 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 fruhj
fruhj

ASKER

Hey Simon,

  It seems to be just the datasource.aspx page. Reports are showing fine and the other screens I've accessed via the /reports virtual directory all seem fine as well (they render to IE fine with no javascript errors)

I've got a test server here (without the error) I think I'll do an MD5 checksum on the folders and compare it to an MD5 of the problem server to verify that the files are the same - then at least we can rule out the aspx and js files as the problem.
Avatar of fruhj

ASKER

Hi Again Simon,

I did the MD5 and all files are the same, minus 2 config files that were mentioned in the article.

I noticed something else today that might help:

I can't add a new folder - the ok button doesnt do anything - leads me to think it's not getting the javascript file or something.
However that' the case testing from the new site I have setup (copied the folders per your article)

On the original "default web site", I am able to add a folder.
Both point to the same RS code - so it must be something different - maybe permissions setup, maybe config file, maybe the .net include files aren't in the new site I setup (I tried a test aspx page and it works, but it didn't use any client side javascript for validation - so maybe I'm missing that on my new site?)

Ok Simon, thanks again, if you think of anything else, please let me know!

- Jack
Avatar of fruhj

ASKER

Hey Simon, that was it!

How F**ing Stupid of me!

I thought I followed your article, and obviously I missed the last step - copying the asp_net client.

(I never got the error message about not finding the js file from IE or I'm sure I'd figured this one out sooner)

Anyhow Simon, once again thanks for all your help on this question and questions you've helped me out in the past with!

- Jack
Avatar of fruhj

ASKER

Follow up message for someone reading this in the PAQ

I had a problem with reporting services on a new site I had created.

Many of the problems were related to client side buttons not working.

It turned out to be a missing javascript file on the new site I created.

ASP.net uses a .js file for it's client side javascript code - used in things like validation, etc...

I had created a new site, and aspx files were working, so I forgot all about the js file.

I copied the folder: aspnet_client from another site off my machine (the default site to be exact) into the site I had used for Reporting services.

This fixed the problem.

Hopefully this paq can help someone else!
Glad I could be of help