Telerik Forums
Reporting Forum
5 answers
330 views
Please help me with buttlet spacing in my report on the HtmlTextBox i add my connction from sqldatabase. At the bottom of the report the report don't show right
Attach capture1 is the code copy out of sql database and paste in your Edit Expression
Attach capture2 is the review when i get the data from sqldatabase

please help to get this right

IvanDT
Telerik team
 answered on 10 Nov 2011
1 answer
80 views
Hi,
    I have, on my webpage, a telerik report and a ajax pane that the user can select certain paramteres to update the data in the report. If I remove the ajax UpdatePanel on the pane, when the btton is pressed the data on the report is updated. However, if I leave the ajax UpdatePanel on the pane and the user clicks the button, the code behind function is catched and the code executed but the report is not updated. It's as if the ajax panel is not allowing the report to referesh. Any ideas?
Elian
Telerik team
 answered on 09 Nov 2011
1 answer
85 views
Hi, 
   We know that Telerik Report reside on the server which means that the data should be available on the server. In my project, the client generate the data ( the type is ObservableCollection<T>), it needs to display by the format of report.  So  my problem that can the client create a self-host reporting service, it needn't transmit the big data to the server.
     thanks a lot 
     jeremy
Elian
Telerik team
 answered on 09 Nov 2011
1 answer
122 views
Hello
This is my code to input data into a table on the report.
The table is linked to a objectdatasource with the same columns
When i bind to the report none of my data comes through

private void monthlyservicesales_NeedDataSource(object sender, EventArgs e)
       {
           var report = (Telerik.Reporting.Processing.Report)sender;
 
           using (var mySql = new MySQL(App.ConnString))
           {
               var data =
                   mySql.QueryDataset(
                       @"SELECT servicetable.Name,count(*) as Total,0 as BWTotal
                                 FROM    axxess.axstable axstable
                                      JOIN
                                         axxess.servicetypetable servicetypetable
                                      ON (axstable.ServiceTypeId = servicetypetable.ServiceTypeId)
                                      join axxess.servicetable ON servicetypetable.ServiceId = axxess.servicetable.ServiceId
                                WHERE     (date_format(axstable.DateCreated,'%Y%M') =  date_format(?0,'%Y%M'))
                                        and axxess.servicetable.Name not like '%*%'
                                    Group by servicetypetable.ServiceId
                                    order by count(*) desc",
                       report.Parameters["datetime"].Value);
 
               var objectDataSource = new Telerik.Reporting.ObjectDataSource();
               objectDataSource.DataSource = data.Tables[0]; // GetData returns a DataSet with three tables
               
               report.DataSource = objectDataSource;
           }
       }
Steve
Telerik team
 answered on 09 Nov 2011
2 answers
135 views
Anyone knows how to print next student on next paper in case one student take up 1,2 or 3 pages.
Customer will use a duplex printer.

Greatefull for help.

Steve
Telerik team
 answered on 09 Nov 2011
2 answers
132 views
I want control the reportviewer's documentmap,and want change the documentmap's background .How can I do?
he seaman
Top achievements
Rank 1
 answered on 09 Nov 2011
1 answer
111 views
I've got a table built using the table wizard that seems to be trying to generate an infinite number of pages.

There's only supposed to be a little over 200 records, but when I hit the preview tab, it works until it hits an out of memory exception. I tried the HTML preview, and it will actually show me the first page of the report, which is all of the right records, but the page count keeps going up, and all of the other pages are exactly the same as the first page. The first time I didn't notice that the page count was going up, and it got up to over 1100 pages.

I've verified that my query is returning the right number of records. It seems to be just this table.

What's going on here?

Thanks
Devin
Top achievements
Rank 1
 answered on 09 Nov 2011
3 answers
214 views
I'm getting the following error trying to install reporting Q1 2011.  Here is the error:

Error-2147467259: failed to create SQL Database: AdventureWorks, error detail: Unknown error.

I do already have the AdventureWorks database.
TonyG
Top achievements
Rank 1
 answered on 08 Nov 2011
4 answers
591 views
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!
TonyG
Top achievements
Rank 1
 answered on 08 Nov 2011
1 answer
174 views
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. 
Elian
Telerik team
 answered on 08 Nov 2011
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?