Telerik Forums
Reporting Forum
1 answer
236 views
Hi, I'm coming from MS Access world. I'm moving in to Web-based app through the door ASP.NET equipped with Telerik. Would you please walk me through by giving me step-by-step on how to create this report. This is a report that I've created in MS Access, but I don't know how to do the same in Telerik Reporting. Here is the DataSet (1 Table):

FullName

ShippingAddress

ShippingDate

TrackingNumbers

ItemNum

ItemDescription

Units

Doe, John

12345 ABC Road

Sample City, ST 123456

8/1/2012

1Z123456789123456

123456789

This Is An Example Description 1

124

 

Doe, John

12345 ABC Road

Sample City, ST 123456

8/1/2012

1Z123456789654231

1Z2345678

This Is An Example Description 2

0

 

Doe, John 2

654321 ABC Road

Sample City, ST 123456

8/1/15

1Z123456789123456

123456789

This Is An Example Description 2

124

 

Doe, John 2

654321 ABC Road

Sample City, ST 123456

8/1/15

1Z123456789654231

1Z2345678

This Is An Example Description 2

0

 

Doe, John 3

145623 ABC Road

Sample City, ST 123456

8/1/15

1Z123456789123456

123456789

This Is An Example Description

124

 

Doe, John 3

145623 ABC Road

Sample City, ST 123456

8/1/15

1Z123456789123456

1Z2345678

This Is An Example Description

0

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


(As you can see, it is group-by (FullName + ShippingAddress + ShippingDate), I colored it for you for easier seeing)

Attached, please find the output report that come out from this dataset.

Thanks

Lamk.
Steve
Telerik team
 answered on 27 Aug 2012
3 answers
256 views
Hi,

I have a report that follows the brasilian invoicing law called "DANFE".

Almost everything is correct, except for the page footer.
All info there must be printed only once and in the first page. I managed to do that with the Style, using the condition "PageNumber = 1".

The problem is that it still leaves a blank section that sould be used by my subreport to print the items. Does the tool provide any way to print the footer on the first page only and keep everything else in the current order, using all the available space in the page?

        If you need an example please tell me.

        Thanks,
Steve
Telerik team
 answered on 27 Aug 2012
3 answers
129 views
Good day,

   I have a 1 page report, when I view it in windows 7 with (I3 and 4GIG) specs, report is rendered in 2-3 seconds, but when I view it in windows xp with celeron processor and 1GIG of RAM, it took 2-3 minutes to render a 1 page of report. Is there any OS requirement or is this related to silverlight in windows XP?


Thank you
Steve
Telerik team
 answered on 27 Aug 2012
1 answer
126 views
Hi..
The legend on my chart sits on top of the right Y axis.
I've tried everything to move it off to the right.  Any ideas?
thx 
See attachment
Hadib Ahmabi
Top achievements
Rank 1
 answered on 27 Aug 2012
1 answer
234 views
Hello,

I have run into an issue where a RadComboBox does not display any items when clicked in a WPF 4 application (Reporting Version 5.3.11.1116). The combobox itself lies within a RadToolBar in a ReportViewer. A small sliver of a dropdown is displayed (see image, same width as the RadComboBox) as though there is nothing in it. Even if there were no items to display, I would expect the combobox's dropdown to respect the MinWidth="150" seen below.

<telerik:RadToolBar Grid.Row="0">
    <!--<telerik:RadButton Command="{Binding NavigateBackCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/NavBack.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadButton Command="{Binding NavigateForwardCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/NavForward.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadToolBarSeparator/>-->
    <telerik:RadButton Command="{Binding RefreshReportCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/Refresh.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadToolBarSeparator/>
    <telerik:RadButton Command="{Binding MoveToFirstPageCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/FirstPage.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadButton Command="{Binding MoveToPreviousPageCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/PrevPage.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadToolBarSeparator/>
    <TextBox IsEnabled="{Binding IsMoveToPageEnabled}" Margin="10,0,0,0" MinWidth="30" TextAlignment="Center" Text="{Binding PageNumber, Mode=TwoWay}" VerticalAlignment="Center"/>
    <TextBlock Margin="2,0,10,0" TextAlignment="Center" VerticalAlignment="Center">
            <TextBlock.Text>
                <Binding ConverterParameter="of {0} pages" Path="PageCount">
                    <Binding.Converter>
                        <tr:FormatedNumberConverter/>
                    </Binding.Converter>
                </Binding>
            </TextBlock.Text>
    </TextBlock>
    <telerik:RadToolBarSeparator/>
    <telerik:RadButton Command="{Binding MoveToNextPageCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/NextPage.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadButton Command="{Binding MoveToLastPageCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/LastPage.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadToolBarSeparator/>
    <telerik:RadToggleButton Command="{Binding TogglePrintPreviewCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2" Visibility="{TemplateBinding ViewModeToggleVisibility}">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/PrintPreview.png"/>
            </Image.Source>
        </Image>
    </telerik:RadToggleButton>
    <telerik:RadButton Command="{Binding PrintReportCommand}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/Print.png"/>
            </Image.Source>
        </Image>
    </telerik:RadButton>
    <telerik:RadToolBarSeparator/>
    <telerik:RadComboBox Height="24"  Margin="1,0" MaxDropDownHeight="300" Padding="2,0" Width="45">
        <telerik:RadComboBox.EmptySelectionBoxTemplate>
            <DataTemplate>
                <Image HorizontalAlignment="Left" Height="16" Visibility="Visible" Width="16">
                    <Image.Source>
                        <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/Export.png"/>
                    </Image.Source>
                </Image>
            </DataTemplate>
        </telerik:RadComboBox.EmptySelectionBoxTemplate>
        <telerik:RadComboBox.ItemTemplate>
            <DataTemplate>
                <TextBlock MinWidth="150" Text="{Binding Description}"/>
            </DataTemplate>
        </telerik:RadComboBox.ItemTemplate>
        <telerik:RadComboBox.SelectionBoxTemplate>
            <DataTemplate>
                <Image HorizontalAlignment="Left" Height="16" Visibility="Visible" Width="16">
                    <Image.Source>
                        <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/Export.png"/>
                    </Image.Source>
                </Image>
            </DataTemplate>
        </telerik:RadComboBox.SelectionBoxTemplate>
        <telerik:StyleManager.Theme>
            <telerik:Office_BlackTheme/>
        </telerik:StyleManager.Theme>
    </telerik:RadComboBox>
    <telerik:RadToolBarSeparator/>
    <telerik:RadToggleButton IsChecked="{Binding IsDocumentMapVisible, Mode=TwoWay}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <telerik:RadToggleButton.Visibility>
            <Binding Path="HasDocumentMap">
                <Binding.Converter>
                    <tr:VisibilityConverter/>
                </Binding.Converter>
            </Binding>
        </telerik:RadToggleButton.Visibility>
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/DocumentMap.png"/>
            </Image.Source>
        </Image>
    </telerik:RadToggleButton>
    <telerik:RadToggleButton IsChecked="{Binding IsParametersAreaVisible, Mode=TwoWay}" InnerCornerRadius="0" Margin="0,2" Padding="2">
        <telerik:RadToggleButton.Visibility>
            <Binding Path="HasParameters">
                <Binding.Converter>
                    <tr:VisibilityConverter/>
                </Binding.Converter>
            </Binding>
        </telerik:RadToggleButton.Visibility>
        <Image Height="16" Width="16">
            <Image.Source>
                <BitmapImage UriSource="pack://application:,,,/Telerik.ReportViewer.Wpf;component/images/Parameters.png"/>
            </Image.Source>
        </Image>
    </telerik:RadToggleButton>
</telerik:RadToolBar>

I have included the following in a configSection in my app.config to no avail:

<Telerik.Reporting>
    <Extensions>
        <Render>
            <Extension name="IMAGE" description="TIFF Image" visible="false" />
            <Extension name="PDF" description="Adobe Acrobat PDF" visible="true" />
            <Extension name="MHTML" description="Compressed Web Archive" visible="false" />
            <Extension name="XLS" description="Excel" visible="false" />
            <Extension name="CSV" description="Comma Seperated Values" visible="false" />
            <Extension name="RTF" description="Rich Text File (RTF)" visible="false" />
            <Extension name="XPS" description="Microsoft XPS Document" visible="true" />
        </Render>
    </Extensions>
</Telerik.Reporting>

Is there anything apparent that I am missing?

Thanks for your time,

Dane
Steve
Telerik team
 answered on 24 Aug 2012
3 answers
2.2K+ views
Hi,
   I want to have the textbox to be auto-sized. I want the size to grow depends on the value of the textbox. Does this achievable? I can specify the max width, afterwhich it should wrap. How to get these?

Thanks in advance.
Peter
Telerik team
 answered on 24 Aug 2012
1 answer
96 views
Hello All,


I have a report, which mianly needs 3 sections of data.

Can i use the 3 details group in parellelism? namely I need 3 data sets for one report. Is this possible in telerik or not?
 
Steve
Telerik team
 answered on 24 Aug 2012
0 answers
144 views
Hi,

are there any working examples for integrating Telerik Reporting into a Sandboxed/Office365/SharePoint Online environment?

Best regards,
Edmund
Edmund
Top achievements
Rank 1
 asked on 24 Aug 2012
1 answer
362 views

In a report I'm working on we want to display some images based on the value of a field. For that purpose I've created a UserFunction that grabs the image out of our embedded resource pack and returns it.

This is where things get a bit ugly.

Since this is a WPF app, we use BitmapImage for storing embedded image resources. It appears that the PictureBox doesn't support BitmapImage? The exception rendered in the Picturebox is "The given key was not present in the dictionary"

To avoid using BitmapImage I've tried returning the URI to the resource, also to no avail. The URI is prefixed with pack:// and that is apparently an unsupported prefix (according to the exception message.)

Going from BitmapImage to an  actual GDI+ Image is not trivial since we're running a WPF app and I would really like to avoid doing that. Physical paths are also not an option...

Any ideas?

IvanY
Telerik team
 answered on 23 Aug 2012
28 answers
772 views
Hi ... after update to 2012/Q2 i cannot figure out, how to convert my code to your new reportsource system:

protected void BTN_Process_Click(object sender, EventArgs e)
        {
            ReportBook reportbook = new ReportBook();
            ReportViewer1.Report = null
 
            foreach (GridDataItem si in RG_Reports.SelectedItems)
            
                string ReportName = si.OwnerTableView.DataKeyValues[si.ItemIndex]["Report"].ToString();
 
                Type reportType = Type.GetType(Server.UrlDecode(ReportName));
                Telerik.Reporting.Report report = (Telerik.Reporting.Report)Activator.CreateInstance(reportType);
 
                report.ReportParameters["Filter"].Value = Session["FilterTextAsset"];
                report.ReportParameters["FilterExA"].Value = Session["FilterExA"];
                report.ReportParameters["IsActive"].Value = Session["FilterIsCheckedAsset"];
                report.ReportParameters["OrgUnitId"].Value = Request.QueryString["OrgUnitId"];
                report.ReportParameters["AssetId"].Value = Request.QueryString["AssetId"];
                report.ReportParameters["UserId"].Value = Session["UserId"];
                report.ReportParameters["IsInStock"].Value = Session["FilterIsInStockAsset"];
                report.ReportParameters["IsOrder"].Value = Session["FilterIsOrder"];
                 
                report.ReportParameters["Group1"].Value = new string[] { "" };
                report.ReportParameters["Group2"].Value = new string[] { "" };
 
                report.ReportParameters["Sort1"].Value = "";
                report.ReportParameters["Sort2"].Value = "";
 
                reportbook.Reports.Add(report);
            }
 
            if (RG_Reports.SelectedItems.Count != 0)
            {
                reportbook.DocumentName = "Assets";
                ReportViewer1.Report = reportbook;
            }
             
        }

this code doesn't work anymore!

Thank you!
Steve
Telerik team
 answered on 23 Aug 2012
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?