Hi,

I've got a problem with the quality of the output when printing from the Silverlight ReportViewer.
If I print from the designer's preview or set the UseNativePrinting property of the ReportViewer to false everything is sharp.

But using the native silverlight printing in the ReportViewer makes the output of barcodes and Telerik.Reporting.Shape types like ellipse very blurry on paper, regular text is still sharp though.


Tomas

Hi

Firstly I wanna thanks Telerik for it's excellent Reporting tool :)

My question:
I have developped a program for printing labels. Now I saw that it prints labels from top->bottom then column 2 etc.
Now I want it to print from left to right, then row 2, 3 etc.
I don't know how to do it? Is it possible? It's of great importance to me!

Thank you in advance

Marnik
VB developper

Hi,

I am not sure this is the right place to post improvement suggestions but i will drop it here anyway:

while editing an existing binding expression in the "edit binding" dialog by double clicking the expression ( i.e. without invoking the "edit expression" using the dropdown) using the arrow keyboard keys causes the focus to change to the property path. This behavior is not intuitive and mildly annoying.

Hi,

In Visual Studio 2010 I added a data source to sql server 2008 r2 . In Configure DataSource Command screen I added a store procedure, I gave the parameters, I press the button Execute query, it shows nice the results but when I click Finish, no fields are shown in Data Explorer.
I did some tests and I discover when I have a stored procedure that internal use temporary tables, and the last select is from temporary table, it not shows the fields in data explorer.
Example
-------------------this doesn't show the field department in data explorer -------------
create procedure TEst_Department
as
BEGIN
SET NOCOUNT ON


select 'D1' as Department into #temp1

select * from #temp1

 END

 --------------this shows the data in data explorer

create procedure TEst_Department
as
BEGIN
SET NOCOUNT ON

select 'D1' as Department into #temp1

DECLARE @dept TABLE
(
    department NVARCHAR(10)
)


insert into @dept (department)
Select Department from #temp1

select * from @dept

 END

----------------------------------------------------------------


I have a pretty complicated stored procedure with a lot of temporary tables and at the end I have to add a Table variable and I have to insert the results in this table variable in order to work with your reports

Any thoughts ?

Regards,

Hans

Hello,
Will TRDX defined reports load  faster  then traditional report load times? I am hoping to prebuild reports that the user will need to page through very quickly, with minimal delay between pages. Will TRDX reports help by speeding up the initial load time for the initial and each subsequent report.

Does the Document Map allow only the first page to display and not pre-build/compile the other pages until they are clicked on? Or does the report Book allow this. What I am trying to accomplish is to load the first page and each subsequent page in the quickest possible way. My report is a simple layout without too much data but there can be upto 50-100 pages.

Thanks!

I am writing this for 2 reasons.

Firstly to help out anyone that like me, has spent hours on Report Databinding issues.
Secondly, to put this down on paper (virtual?) to help me remember what I learned.
The problem I was having is related to binding a SQLDatasource to a report.
I was having a hell of a time trying to figure out why the filtered datasource was not getting reflected in the web report viewer.

Heres the setup I was using:

- A Telerik  Report with 1 table and 1 crosstab in a class library (as recommended by Telerik)
- The report had the report datasource, the table and crosstab datasources pointing to the reports SQLdatasource object.
-The report had no filters and no parameters and displayed all the data in the query (via stored proc) - good so far
-The report worked fine in the designer preview -also good
- A web page with a reportviewer
- Code behind setting the reportviewer report to the report described above (The working Code shown at the end of this article)

Now here is what was happening,

When I designed the report, and viewed it in the preview tab in the report designer, the report displayed fine and showed all the data in the query as it should.
When I viewed the report in the web page using the report viewer, I used code behind to get the data from a query, set a filter and bind the datasource of the report to that. The problem I was having was that the report was displaying all the data and not the filtered data.

I tried several things to troubleshoot this over several hours...
Some of the things I noticed were:
1. I could not get the NeedDatasource in the web report code behind to fire
2. If I put a Datagrid on the page bound to the same data, it showed the filtered data just fine but the report did not.
3. Weird- if I changed the filter to return no data (ID=9999), no data displayed in the report but if I used any valid filter (ID=1), all the data displayed
4. If I set the datasource in the report to nothing it displayed nothing even though getting set in code behind

After messing with this for several hours I got it to work properly and here's what I needed to do, and what I learned in the process:

The main problem I was having was that in my report, the main report was pointing to the report SQLdatasource, as were the 2 bound objects on the report, a table and a crosstab. All of the messing around I was doing was never setting the datasource of the 2 objects properly. Setting the main report datasource did not change the 2 bound objects in the report.

To fix this I did a few things:
1. Set the 2 objects datasources to point to the main report datasource using the NeedDataSource event (IN THE REPORT)

Something important to note here:
Dont use Table1.DataSource=Report.DataSource- it wont work. Make sure you refer to 'Sender'

2. In the report constructor, be sure to set the datasource to nothing (null in C#) or the NeedDataSources WILL NOT FIRE !

 

So now in the report viewer (web page) code behind, when you run the method to load the report data, you set the main report datasource to the queried data object, whatever happens to be (Dataset, datareader, collection etc), and then since the report objects have their datasources set to nothing, the NeedDatasource events back on the report code behind fire and set the datasources for the table and crosstab to the main datasource for the report (which was set in the web page code behind).
Now- this gives us another very nice benefit, when you view the report in the report designer, it will work correctly because you leave the report and the table and the crosstab on the report bound to the SQL dataSource in the report. Some other forum posts I have seen recommended to set the datasource when building the report and then removing it when done designing.
You dont need to do that using this approach.

Here is the code for the report and web page code behind:

Report code behind (All the code)

 
Web Page Code Behind (all revelant code only)



I hope this clears some things up for you and saves you some time and headaches.
Please drop me an email if it does at billymac@advancedinteractive.net

Cheers...

Hi,
  I am using report viewr for reports.Reports are working fine in my local,test and QA servers.But when we deployed in production server getting error " "

I have a report where I have a hierarchy of data related to work schedules.. Some of the time that is tracked has an additional grouping I need to total on, others don't.. see below:


Some divisions of labor will have the optional category that requires totals, some will not.

ADMIN STAFF

     Employee 1 [hours worked]

     Employee 2 [hours worked]

     Employee 3 [hours worked]

ADMIN STAFF TOTALS

 

SUPERVISION

   Supervisors

     Employee 1 [hours worked]

     Employee 2 [hours worked]

   Supervisors Totals

 

   Asst. Supervisors

     Employee 1 [hours worked]

     Employee 2 [hours worked]

   Asst. Supervisors Totals

 

SUPERVISION TOTALS

 

LABOR & LOGISTICS

   Labor Foreman

     Employee 1 [hours worked]

     Employee 2 [hours worked]

   Labor Foreman Totals

 

   Laborer / Logistics

     Employee 1 [hours worked]

     Employee 2 [hours worked]

   Laborer / Logistics Totals

 

   Laborer

     Employee 1 [hours worked]

     Employee 2 [hours worked]

   Laborer Totals

 

LABOR & LOGISTICS TOTALS

In the above, Admin Staff has no sub-category or totals. Labor & Logistics does. 

So.. I need a grouping with totals for the "Optional" category but do not need that optional category for Admin staff and other divisions of labor that do not need sub-grouping categories. I have the data being captured already, I just need to know how make the report do this.

Thanks.

Hi there.

I have a crosstab report. The headers are split by company region then by year. How do I split my grand total column by year, i.e. the second type of header?

Thanks

Hi,

I can't get the table row group headers in a report I'm designing to repeat on every page. Here's the table group structure I have

ParentGroup
Static
Static
Detail Group

I would like the two static rows to be repeated when a group spans multiple pages. I'm using Q1 2013.

Thanks,

Joe