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

Hi!

I'm trying to create your invoice demo example using datasets but I cannot get it to work.
Does parameters and filters work for datasets?

I have a dataset called "dsInvoiceInformation" containing two tables "Header" and "Rows"
In my master report, I have set the datasource to "dsInvoiceInformation" and datamember to "Header".
When I generate my reports, the header information is shown without problem, but how do I bind my "Rows" table to the SubReport datasource/datamember and how do I get it to filter out the rows belonging to the right invoice (from the "Rows" table)?

Regards
Per

Before I download the beta, I was wondering if telerik reporting is going to support using RDLC report templates?

We've developed some in Visual Studio 2005 for use with the webform reportViewer control, and would like to avoid having to rebuild those.  Plus we have some customers that are building their own in Visual Web Dev Express.

Hello,
I've got a row from database of type [String] [Double], I want to set the Y value to the string and showing "Classe1", "Classe" ... so I also need to disable the autostep property ...how can I do that since for the Y value I've got a double?
Can I?

Thanks
Paolo

hi,

is it possible to catch a change-event of the parameter-combobox? mhm, when i have a report opened with web report-viewer, i have two parameter comboboxes and now i change the first and the second could only be load by the data of the first.

any ideas??

greetz

Hi Telerik,
I have the following "challenge":
In a Crosstab I get the following Columns "r1, r2, r3, r4, r5, r6" with the Values "v1-v6". But I need only the Columns "r2, r3, r5" with their values. How can I filter this Columns out?
In other words: It exists "fields.first()" and "fields.last()". How I get a "fields.inbetween()"?

Thanks for answering,
Res