I need to check out if two fields are null in dataset Then, if two fields are null, then i wantto set the visible property of layout of detail section( of corresponding records) to false. O do following check:

Expression     Operator           Value
=Fields.X           =                      = Null


And finally how filter of detail section of report looks:
=Fields.X = = Null

However nothing happens. Help pls.
Thanks...

Hi I am stuck on a problem. I have 2 tables which are nested on a single report. Both datasources are being set in their needdatasource method respectively.

My problem lies in retrieving a value from the parent table which will populate the child tables based on whatever values which are retrieved from the parent. I just need to retrieve one variable from the parent table once it is populated so that I can populate the child table accordingly.

Basically, I want a master-details / master-child relationship

Thanks

Hi,

I have Created a InvoiceMaster Report, Its working fine.
and a InvoiceDetail report, which have a stored procedure (with parameters) as datasource and this InvoiceDetail report working file separataly (providing report parameters correaponding to each stored procedure parameter).

Now I am using InvoiceDetail report in detail section of InvoiceMaster.

the problem is, how to send report parameters from each item of  InvoiceMaster  to InvoiceDetail.

Thanks in advance....

Hi,

is there a way for me to do this? I've tried doing it but the FormattingRule class does not expose a property that allows me to change the Expression. I'm passing parameters to the report constuctor and based on those parameters the formating conditions need to be set up.

Thanx

Is there a way to create a custom report parameter by deriving from ReportParameter?  Basically I would like to have the Telerik RadComboBox control be a possible parameter so that when a user starts typing in the box the box will load with matching information.

Any help would be greatly appreciated.  This is the one thing that is holding me back from moving forward with Telerik Reporting.

FYI, I know I can create my own custom report parameter area and pass the values in the code behind, but I am trying to avoid this and make things more graceful.

Hi,

is it possible to stream a report (i.e. when a hyperlink is clicked just downoad/open a report) instead of exporting it through the report viewer & if so can you give me a code example (VB preferably)

Regards

Does anyone know of a way to prevent the opening of a browser window on export? Basically you click on the export link and it opens a new window which in turn opens acrobat. So then you have to close acrobat and then close the blank window opened by the reportviewer control.  This behavior does not seem to exist when adding an export button to the grid.

Current behavior: http://demos.telerik.com/reporting/sales-dashboard/demo.aspx
Desired behavior: http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/pdfexport/defaultcs.aspx

Hi,
1 Ques. I am trying to create a report filter which should use a parameter value which is a variable along with a wildcard report.
I want to get the result for a SQL query like:
"Select users from Usertable where UserName LIKE %@Name%"

I am trying to get the "@Name" from the Parameter. Have enabled the UI for the parameter.

Here is the filter:

Filter:
("=Fields.[Name]", ((Telerik.Reporting.Data.FilterOperator)(Telerik.Reporting.Data.FilterOperator.Like)), "=Trim(Parameters.Name)")});
If have tried following in the value field :
=%Parameters.Name% : Gives Missing Operand for Mod operator.
=Parameters.Name: This works but does an exact match, I need a wildcard support.


2 Ques. Is there a way to enable filter only when the user selects/inputs any value for the parameters in the UI.
I want to display all the records by default. But when I set filters and get the parameter values from UI the report does not display any values by default.

Thank you for your help.

-Brenda.

I wanted to share my experiences with the crosstab and pivottable features of Telerik Reporting as it took me a significant amount of time to develop and I hope this will help someone else reduce their time.

I have some values I want pivoted from a schedule and printed appropriately. Since we work schedule by days instead of hours this is slightly different than what most people would do but I believe you could use this example to duplicate.

I had a table output like this:

installdate (date), locationname, team_neam, techname, technumber, ma, installerStatus (number)

I wanted to pivot on the installdate and create dynamic columns across the page and open a new page only after grouping by week.

So my output would look like:

Team Name (grouped), TechName, Tech #, MA, dynamic columns based on date range grouped by week number, then sub-grouped (though each resulted in a single record) by date and day of week.

So first I created a blank report, with header, footer, and detail section. I set up the header section with a logo, and an htmltextbox, in the codebehind I grab the first row of my output and get the locname from there to fill in the htmlbox, and get the month name from a passing variable to initiate the report. So my top has a logo and "xxx Location  |  August Schedule". My footer has a legend a single textbox with lightgreenbackground and black text that says working, another textbox with red background and black text that says off and a page # cue. I set the pagenumber by dropping a textbox in the bottom right, set the textalign to right, aligned it with the end of my header row and put this value in it: 

='Page ' + PageNumber + ' of ' + PageCount

Then comes the fun/confusing part. I've had some difficulty with the crosstab portion of the designer so after some trial and error I started copying the files (.cs, designer, and resource file) to a safe spot before every change. If the change failed I copied them back.
I created a dataset with the fields I want, used the crosstab wizard to create a basic report with only team name on the row group, installdate on the column group, and sum of installerstatus on the detail group.

I then finished the wizard and added some code to the codebehind to fill the dataset. I also added some user functions under to clean up my data (and get week number of year etc) Put these at the bottom of your class, but inside. You must rebuild your project to get access to them in the designer.


Then I change back to designer view and right click on the teamname group in the area and added a child group for each column. Very Important: Add a child group to team name, do not add a child group and try to add another child group to that group! Then I added a child group to installdate, and another child group to installdate for my date, and dayofweek column/rows. Then right click on the first column group I created and set the group expression and value expression using the previous examples (see ProductSalesbyYear/QTR) (right click on it and choose properties, set Expression, click expression, choose user functions, select the one you want, then fields, and click the field you want). I set the sort on these to be the installdate field itself (not the user function!). I also changed the groupbyexpression for my prebuilt column of installdate for the Week # using userfunction. I had to merge some cells, and manually type my header names above each one in the corner tab but that was easy enough. I also set the team name field, and it's rowgroup field to vertical 90 degree angle.

Hope this help someone else, if you have any question let me know I would be glad to help.

I installed the Reporting msi file but when I launch my VS 80 Prof., I don't see Report Wizards for me to design the report.  can someone help?

Thanks