This is a migrated thread and some comments may be shown as answers.

Grouping report with three DB fileds

12 Answers 102 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Arjun
Top achievements
Rank 1
Arjun asked on 29 Nov 2010, 02:41 PM
Hi Telerik Admin,

m stuck while grouping report data by three DB fields like (Firstname,lastname and Phone no).
is there any way to get this?
FYI: -m using Q2 2010 SP1.
       -there are total seven DB fields
      -need  to group by these three fields(as mentioned above).
its quite urgent.please help me ASAP.

Thanks in advance.
-Dhungana

12 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 01 Dec 2010, 06:16 PM
Hi Arjun,

Check the Product Catalog demo report that shows scenario very similar to your inquiry.

Sincerely yours,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Arjun
Top achievements
Rank 1
answered on 02 Dec 2010, 02:59 PM
Hi Admin,
its using three group section for three fields but i want only one group section for three fields.
like in SQL query

Select firstname,lastname,phoneno,email searchCount
from users
 group by firstname,lastname
 
here the generated data grouped by (firstname+lastname).

i want same scenario on reporting also

please see the attached image file for  expected result sample.


# beside this one: i have another query:

is there a way to set the different style for different export format (files like xls,pdf,doc,TIFF,rtf..etc)?
like, i dnt want textcolor and interactive action link(underline) on to be exported files

i just wanna style on  to be exported report file as a printer friendly or as per requirement style.

m stuck over it ,please help me .




Thanks
Arjun Dhungana
0
Accepted
Steve
Telerik team
answered on 03 Dec 2010, 06:23 PM
Hi Arjun,

You should add three grouping expressions in a single group as shown in the attached screenshot. As for your second question, the answer is no. You should create another report without the styles that would be used for printing.

Regards,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Arjun
Top achievements
Rank 1
answered on 03 Dec 2010, 07:17 PM
ok , well, i will create that another report without the styles which would be used for printing but how can i manage that report just for printing and exporting purpose.
indeed, i need the running system as is and this another report just for printing and exporting purpose.

Thank You
Arjun Dhungana
Sr. Software Engineer.





0
Steve
Telerik team
answered on 06 Dec 2010, 08:34 AM
Hello Arjun,

By hiding the report viewer's print button and creating your own UI (e.g. print button), which would use the report without the styles.

Greetings,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Arjun
Top achievements
Rank 1
answered on 08 Dec 2010, 12:41 PM
Thanks Admin

I need NO Scrolls on  the reports  but page should expand based on data ,now how do i achieve that.
one more query-
can i make Reportviewer 's  height  dynamic based on data?
Its Urgent -Thanks in advance

Dhungana
0
Accepted
Steve
Telerik team
answered on 09 Dec 2010, 02:49 PM
Hi Arjun,

Report items can only grow vertically and it is because of the fact that HTML is not page oriented format that makes this invalid when showing the report in the web report viewer. So in this line of thoughts you cannot take the actual dimensions of the report in the HTML rendering, since it grows in both directions without taking into account the Page Settings.
So in short, what you ask for is not possible and even more, such a thing is not good idea in general as if the viewer grew dynamically it would change the entire page layout.

All the best,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Arjun
Top achievements
Rank 1
answered on 09 Dec 2010, 03:57 PM
Thanks Admin,
now i have a very urgent query.

is there any way to know that the report is newly generated or navigated back?

i want that flag to prevent sorting session for navigated back report.

very very urgent.

Thank you,
Dhungana.



0
Steve
Telerik team
answered on 13 Dec 2010, 11:03 AM
Hi Arjun,

This is not possible as the report address depends strictly on the parameters and it remembers where you came from similar to browsers where even the scroll position is remembered. In this line of thoughts it is not correct to "clear" all that information and navigate to the "base version" of the previous report.

Hope this clears any confusion.

Best wishes,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
Arjun
Top achievements
Rank 1
answered on 13 Dec 2010, 12:49 PM

well,now i have a scenario of interactive  sorting.
for ex, i have four coulmns (vin,year, make,model)--its car info

now, i need interactive sorting by any column and interactive action on particular vin( FYI: action on records not on column) for more vehicle details.

please guide me how i can achieve this.

Thanks Admin

Dhungana.

0
Arjun
Top achievements
Rank 1
answered on 21 Dec 2010, 02:12 PM
Hi Admin,

I am desperately waiting for your response.
its very urgent ,please guide me .

Thanks
Dhungana
0
Steve
Telerik team
answered on 22 Dec 2010, 06:46 PM
Hi Arjun,

Check the following forum thread that elaborates on interactive sorting and contains a runnable example. More information on the available interactive actions is available in the following help section: Adding Interactivity to Reports.

Kind regards,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
Tags
General Discussions
Asked by
Arjun
Top achievements
Rank 1
Answers by
Steve
Telerik team
Arjun
Top achievements
Rank 1
Share this question
or