Telerik Forums
Reporting Forum
1 answer
210 views
Hello.
Is it possible to somehow define the characters used for wrapping?
For example I have following string containing list of people in format : "Name Surname Hour:Minute"
"Michal Michalski 08:35, Damian Damianski 09:46, Roman Romanski 10:45"

Depending on TextBox's size wrapping can break line after space, ":" or ",".
I Need to block possibility of breaking line after certain character (in this case space and ":", so it could only break line after "," character).
Maybe there is any special escape character?

If there is no way of blocking or defining characters for wrapping, Do you maybe have any ideas how can I achieve such functionality?
I have only 1 idea - which is counting size of text, but I think its kind of complicated, cos I would have to keep in mind that there could be like hundreds of combinations of Font and its style chosen.

I will appreciate any help.

Greetings
Michal
Michal
Top achievements
Rank 1
 answered on 06 Aug 2012
4 answers
300 views
Hi ,

i have a sql query with a where condition

like this where customername=@customername

For the @customername parameter , i want to provide  multiple values so i change the code
to
where customername in (@customername)...and enabled the multivalue property to true in  the report parameters property
 but when i choose mutiple vlaues from my customer name drop down , the report is throwing an error...

'An repression of non-Boolean type specified in a context where condition is expected near ',''

Can someone guide me on how to do this...
Ravi
Top achievements
Rank 1
 answered on 03 Aug 2012
3 answers
114 views
I have my report working (mostly) nicely with Telerik ORM (ignoring that the report Preview has a heart attack 50% of the time).

I have two Open Access Data Sources.
oadsOrders = Main data, 1 record per page.
oadsOrderItems = Order detail, many per Order, displayed in a report table.

See screenshots:
report.png = report designer.
mass 2.jpg = screenshot showing how I oadsOrderItems is populated using parameter from oadsOrders


Problem:
I need to show report order total, ie sum(orderItem.amount) though I can't figure a good way to do this.
Telerik report doesn't navigate into 1-N relationships it seems, so I can't tell it to aggregate like this sum(Order.OrderItems.amount) .

I can use custom functions, but they are static and don't know about reportItem, nor could I seem to pass that in properly - it didn't recognise the function.

Do I have to create ANOTHER datasource so that values from OrderItems can be aggreated? Seems like overkill to me..

Thanks,

Pat.

Elian
Telerik team
 answered on 03 Aug 2012
1 answer
331 views
I have a textbox bound to "Field.A".
The problem is that sometimes "Field.A" does not exist and in these cases I need to bind the textbox to "Field.B".

It was recommended that I use a user function :

public static String ResolveField()
{
string s = new string();

// ????
// Check if Field.A exists
// if yes then s = Field.A
// else s = FieldB

return s;
}


How can I check to see if a field exists without an exception?
Steve
Telerik team
 answered on 03 Aug 2012
3 answers
113 views
Hi All

I have a sub report and in the NeedDataSource event I extract my data.
For each row I loop through the columns collection and if that column contains any text I create a textbox on the fly and add it to the report. Each row appears on a new page.

This all works fine apart from one major issue.

  • If the first row contains 6 columns containing text then I generate 6 textboxes.
  • If the second row only has 4 columns containing text then I add 4 textboxes but an additional 2 empty textboxes appear at the end.

I am assuming that these textboxes are remnants from the previous iteration but for the life of me I cannot get a handle on them.
Is there any way I can get a handle on the current page of the sub report so I can remove these empty textboxes?

Chris Gillies
Top achievements
Rank 1
 answered on 03 Aug 2012
1 answer
359 views
I have a report that contains multiple graphs as sub-reports. I am getting an overflow error whenever I navigate to one particular graph in the report (the rest are all fine). See the attached screenshot.

I appreciate I've not provided details on the report, or the type of data etc but i'm more generally looking for how I should approach this in terms of trying to debug the issue. Very little information is available and I've tried to no avail to determine the cause myself.

The report is in the Silverlight reportviewer, so it being rendered on the server side and accessed via the WCF service.

Any tips would be greatly appreciated!

Thanks.
Steve
Telerik team
 answered on 03 Aug 2012
2 answers
256 views
Is there a way to disable the action for a textbox on a databound event?  I'm using an action on a table item to navigation to a drilldown report.  There is no child report, it just opens the same report and navigates to the next node in my hierarchy tree so to speak.  I'm simply passing a value to the same report to indicate who the drilldown parent is.  Everything works fine until I get to the point where there are no more children and I don't want the action to do anything at this point otherwise it will take me to a report with no results.

I've been able to work around my problem by creating two versions of the textbox that contains my action.  One with the action and one without the action.  The one textox is superimposed on the other.  I then simply hide or show the appropriate textbox on a databound event.  Unfortunately, I've run into a problem with this approach and the table object.  A table column can contain only one textbox, so I can't have two different versions of the textbox in a single column.  I can't use two columns, hide one and show the other since some rows may have child reports and some may not. 
Nick Jacka
Top achievements
Rank 1
 answered on 03 Aug 2012
0 answers
88 views
i have 1 report with 2 sub reports, when run the reports one subrepot not show up in main report, that subreport i used only 1 detail section and 1 sqldatasource, this sqldatasource  needs 4 parameters, 3 params gettinf from input's and 1 param is getting from main report result field.
1st  i tried to set the datasource property with sqldatasource1 -- - subreport doesn't show up in main report even with design time values, empty space shows in main report

2nd i tried with need source event this time calls needdatasource event -- this time also didn't sow up any thing in main report, only empty space show up in main report.

please give me solution for this issue

Thanks in Advance
Siva
Top achievements
Rank 1
 asked on 02 Aug 2012
0 answers
157 views
We are creating a report which will supress duplicate values. But we want to keep them if it is a new page. I could not find a way to determine if it is a new page Help!!
Jason
Top achievements
Rank 1
 asked on 02 Aug 2012
1 answer
85 views
Hi. I want to export a report from Silverlight but by calling a web invoke operation method. I can view the reports within silverlight with no problems.However, I would like to call a method where I pass the report name and the parameters to the web application part of the silverlight application, this will produce the report export [e.g PDF] and save it on the server.

Could you advise if this can be done and some example code?

Thanks
P
madladuk
Top achievements
Rank 2
 answered on 02 Aug 2012
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?