I'm guessing this is not a new problem but it's the first time I'm seeing it. I'm fully documenting this for anyone else who has a similar situation. When I install the current (Q2 2010 SP1) release of Reporting with Examples I get:

Error -2147217900: failed to execute SQL string, error detail: Database 'AdventureWorks' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details., SQL key: PrepareTempTable SQL String ... USE Adventureworks;

I am running a local instance of SQL Server Express 2005. I realized that I had deleted the AdventureWorks_Data.mdf, so "inaccessible files" made sense. I reinstalled the database using the Microsoft msi.

Even though I'm running with a user with administrator privileges, I wasn't able to connect using the VS2008 Server Explorer until I set "User Instance=True". So now my ConfigurationString is:
Data Source=NINJA\SQLEXPRESS;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf";Integrated Security=True;User Instance=True
So now VS connects and I can see the whole database.

But I still get the same error installing Telerik Reporting. See the attached image.

The installer does a rollback on failure so we can't get by this issue after it occurs. Restarting the installer I disabled the install of the Examples and the install completed successfully.  So that's how to get around the issue.

I opened Services. My "SQL Server (SQLEXPRESS)" service is running under account "NT AUTHORITY\NetworkService".  I stopped the server and changed the logon to "Local System account", then restarted the service. Then I went to Add/Remove Programs, opened Telerik Reporting, and selected Change. I re-enabled Examples, and it installed to completion.  Simply running SQL Server as Local System Account would have solved the problem before it happened, and I'm sure that's how many people already have it setup. For those who don't... I hope this helps.  Unfortunately people who don't want to change the login like that may need another solution.

Is there any way that we can change the configuration string for the installer for the Examples, so that it will install?  More importantly, I don't think a software installer should fail with a database connection like this. Let the product install and then let the runtime fail. We can fix that problem when it happens.

Does Telerik have any other recommendations in this area?

Thanks!

Hi,

We have lots of PDF files stored as BLOBs in our database. We need to display these PDF files in a silverlight application, but the user must not be able to print or save the PDF file. How can we implement this requirement using the Silverlight Report Viewer ?
Any help will be appreciated. 

Hello everyone,

I am trying to pass some ReportParameters to a report class that I´ve created.

I´ve got the following set up:

Created Report Class as per Telerik best practices.
Created 2 parameters. one called CMU the other AlarmType.

On .net web app, I´ve got a set of drop down lists that should be used to filter the info required.

I´ve got a ReportViewer1 that calls the "Reporting" class.

On my code behind, I´ve got the following:


The ReportParameters in my Report class are set to not accept null, so that i know If the value is being passed or not.

In my web app, the given values ARE accepted apparently, as no error is being thrown at the moment the values are fed, however, when the Report regenerates, it says "

Invalid value of report parameter 'CMU'.

If i set the paramter to accept null values, it simply shows the report, but with no results.

Any help?

Hello everyone

I started using telerik reporting this week and it's great. But I'm little stuck because of lack of knowledge and little time left to do my tasks.
I have a multiple select dropdown list report parameter and i want for every selected item in the list to create detailed report coresponding for that selected item, and every detailed report to be in one different page. What should i do, any hint or guide will be great. 
Thanks very much :)

I'm using report in silverlight, when I enter the page number in the box and hit enter key, nothing happened, the page is not refreshed. but this is working in asp.net, how to make this work in silverlight too?

thanks

hello


i am getting an error in my report-viewer page because the objects used for datasource use IList which does not implement ISerializable.

Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode.

i am using state server for sessionStates

how can i use state server and a hierarchy of entities as datasource?

regards

How can you change the language of the ReportViewer interface in Silverlight?

I am not talking about globalization of my reports, only changing the interface language of the ReportViewer with a translation for the labels such as "of x pages", "rendering report", ...

Jim

Hi guys,

I am having an issue with charts, I haven't been able to find any specific documentation on this.
I am using the wizard - the chart works, but it seems to display a number sequence on the x-axis (1,2,3,4 etc) rather than the dates I want.

I've tried a SQL CAST to make the dates into VARCHARs and also as FLOAT in my datasource, but this doesn't seem to change anything.

Where should I be setting this up?

Thanks,
 Ed

Is it possible to define (and apply) the rules for conditional formatting programmatically?

--
Stuart

I have a subreport that looks like this:

Fields.AuthorName    Fields.Subject
                                  Fields.Note
                                  Created: Fields.CreateDate        Last updated: Fields.LastUpdated

I would like the textbox holding Fields.Subject and Fields.Note to grow as necessary and push the CreateDate and LastUpdated and their labels down the page.  Right now I am concentrating on the Note field.  Note has CanGrow, TextWrap, and Multiline set to True.
 
When there are multiple lines in the Note, only 2 lines show, the rest are cut off.  I have tried setting the Anchor property on Note to Top, Bottom, Left, Right and the Anchor property on the CreateDate and LastUpdated fields and their labels to Bottom, but this doesn't seem to do much.

I also tried putting the AuthorName and Subject fields in a group header and the CreateDate and LastUpdated fields in a group footer so that the Note field is the only thing in the detail section.  I tried this both with and withoutt the Anchor property on Note set.  The behavior is the same, even though there isn't even anything in the section for the Note textbox to push against.

It seems like what I am looking to do should be possible, but I haven't found much help with this in my searches on the site.  Does anyone know how to get a textbox to grow and push down what's below it?