Telerik Forums
Reporting Forum
1 answer
416 views
Hello,

I'm new to Telerik Reporting, I've benn working with it for a few days trying to make a specific report. So... my question - is there any way of adding columns to a table codebehind, not from the design view. Tere is no problem for generating rows from the datasource, but the thing is every time I call the report I'm giving it a different DataSet(Different columns and entirely different data) codebehind, so I cant know how many comumns are there going to be, so I cant assign the values and number of the columns at design view. I would appriciate any help.

Thanks, 
Apostol Apostolov
Steve
Telerik team
 answered on 17 Sep 2009
2 answers
134 views
I am using Version 2.9.8.1209.

I would like to generate an invoice report. In the report, I have my main report with 3 sub reports in the middle, meaning main report data then follow with 3 sub reports and then main data report data after that in the main report like below.

Date: 23rd Nov 2009

To : CEO

Sub Report 1
Sub Report 2

Sub Report 3

Total Amount : Five Hundred and sixty only


---------------------------------
Eugene
Marketing Officer

i would like to be able to control that if at the end sub report 2 there is only left a certain amount of space on that page, automatically the sub report 3 should move to the next page and not right after the sub report 2 on the same page. this is because also there are times that the signature section will end up at the top of the next page which is not acceptable for an invoice. i would like it to know when to move to the bottom of the page.

Currently now i have no idea on how to go about this or go around it. please advice. thanks
Eugene
Top achievements
Rank 1
 answered on 17 Sep 2009
4 answers
434 views
I have a report that needs to use a multivalue parameter with a stored procedure, yet I am getting an error when I select multiple values because it comes back as an array when the report doesn't seem to be expecting it.

Does anybody have an example where they are using a stored proc with a multi value parameter?

Thanks in advance.
Steve
Telerik team
 answered on 16 Sep 2009
1 answer
213 views
Hi there, we have been using the telerik reporting for quite a while now, and found it handy in most of the scenarios we're facing. Thanks for the great work.

However, one of the problem we got now is that as we send the report as an email out (which using MHTML, and works fine), the mail content become large as what telerik reporting engine generate all images as mime and embeds into the content.
as example
<img alt="Image" src="cid:uf32gweyf5y" style="width:100%; height:100%" /></div

then as we generate the report as HTML, it export the follow for image
<img alt="Image" src="/Telerik.ReportViewer.axd?culture=en-NZ&amp;uiculture=en-US&amp;instanceid=3d09e5a8d49d412c9e85073ece538511&amp;&amp;optype=ReportImage&amp;StreamID=m4b13jtidmk" style="width:100%; height:100%" /> 

The question is, how would we export it, as the orignal link instead? Is that a way which we can put a unique identfier and replace it in the code-behind as work around? (prefer no workaround though)
Steve
Telerik team
 answered on 16 Sep 2009
1 answer
235 views
Hi,

I wonder if it is possible to generate report for a LINQ object that might  have different number of fields.
For example, we currently have 7 active stores and have to make a sales/stock report as follows.
Each data row requires two lines to fit in the letter-sized printed output.
------------------------------------------------------------------
 Item       Store1        Store2      Store3      Store4
         Sale Stock   Sale Stock Sale Stock Sale Stock
             Store5          Store6    Store7        Total
         Sale Stock   Sale Stock Sale Stock Sale Stock
------------------------------------------------------------------

But a few month later we are going to open 2 more stores so there will have to be 3 line for each item.
The header should look like the following.
------------------------------------------------------------------
 Item       Store1        Store2      Store3      Store4
         Sale Stock   Sale Stock Sale Stock Sale Stock
             Store5          Store6    Store7        Store8
         Sale Stock   Sale Stock Sale Stock Sale Stock
             Store9                                            Total
         Sale Stock                                      Sale Stock
-----------------------------------------------------------------

In case of .NET ReportViewer Object, I heard that we can modify the RDLC file at run time and generate the report dynamically.

Olso is there any way to allow detail-line of each data-row to be extended into multiple lines dynamically??

Thanks,

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

Milen | Product Manager @DX
Telerik team
 answered on 16 Sep 2009
5 answers
340 views
Okay I've watched this video about parameterized queries.

I created my sqldataadapter with the following select:
SELECT     ApplicationDisplay, RoleDisplay, FirstName, LastName, EffectiveStartDate, EffectiveEndDate, EnvironmentDisplay, ApplicationId
FROM         AppUsersByRoleView
where     applicationid in (@appId)

I want to use the built-in report parameters in telerik reporting.  I created a report parameter named "Application" with a type of Integer.  (I've also tried a type of string).  It is a MultiValue parameter with the available values valuemembers being integers.  I also setup the filter to be =Fields.ApplicationId In =Parameters.Application.

Within my codebehind for NeedDataSource I have the following code.

'Transfer the ReportParameter value to the parameter of the select command    
Me.SqlDataAdapter1.SelectCommand.Parameters("@appID").Value = Me.ReportParameters("Application").Value

'Take the Telerik.Reporting.Processing.Report instance and set the adapter as   
'it's DataSource    
Dim report As Telerik.Reporting.Processing.Report = CType(sender, Telerik.Reporting.Processing.Report)
report.DataSource = Me.SqlDataAdapter1

When I run the report, NeedDataSource runs fine, but then I get an error within my reportviewer.

An error has occured while processing Report '':
Failed to convert parameter value from a ArrayList to a Int32.

Any help would be appreciated.
Thanks.
Steve
Telerik team
 answered on 16 Sep 2009
1 answer
84 views
I'm trying to deploy my site to a server setup for "precomiled" web server.  I got the Telerik reporting DLLs up there and working but where do I put my config file?  The reports can't seem to find the settings for the database connection.
Steve
Telerik team
 answered on 16 Sep 2009
1 answer
467 views
Hi ,

i have a report which shows the dates as below based on the user inputs

     Batch Date:  September 15,2009   --- This should be displayed when the user selects only one day
                           0r
     September 1,2009  to September 15,2009  --- This should be displayed when the user selects date range

BtachDate:  textbox1
Fromdate:   textbox2
Todate:       textbox3
to:               textbox4

In the report i want to compare Fromdate and ToDate and if they are equal, then hide textbox3, textbox4
                                                                                                           Notequal, then hide textbox1

I have seen some examples in the forum( attaching a databounditem event to a textbox),
but i dont see a situation where we can make a textbox visible/invisible based on ther textbox values?

How can this be accomplished??


Thanks,
PK
Steve
Telerik team
 answered on 16 Sep 2009
1 answer
179 views
Good day everyone.

I trying out your report and am very pleased with it. Except for one thing.
In report designer when elements overlap or are out of page a yellow exclamation mark appears in the corner of overlapping element (something like this image) . It's a handy feature but I'm designing report with a lot overlapping elements. I tried to somehow avoid overlapping but it is very hard.

Is there a way to hide or disable those warnings (yellow exclamation mark)?

Thank you in advance.
Steve
Telerik team
 answered on 16 Sep 2009
0 answers
46 views

Hello Friends,

In Windows Telerik Report, I want to provide a such functionality so that by clicking on specific field in report , some other screen will opens and also want to open other telerik report.

If anyone know this kind of functionality in Windows Telerik Report than please give me reply as soon as possible.

Thanks in advance.


Projects Computerra
Top achievements
Rank 1
 asked on 16 Sep 2009
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?