473,403 Members | 2,366 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

Drill Down in Crystal Reports

I am using CR in ASP.NET , I am able to show drill down graphs where
grouping is done on single column from result set of sql query, is it
possible to achieve drill down by grouping on multiple groups?

-Naseem
Dec 7 '05 #1
3 3205
I am using CR in ASP.NET , I am able to show drill down graphs where
grouping is done on single column from result set of sql query, is it
possible to achieve drill down by grouping on multiple columns?

-Naseem
"Naseem" <ns*@brain.net.pk_REMOVE> wrote in message
news:eh****************@TK2MSFTNGP10.phx.gbl...
I am using CR in ASP.NET , I am able to show drill down graphs where
grouping is done on single column from result set of sql query, is it
possible to achieve drill down by grouping on multiple groups?

-Naseem

Dec 7 '05 #2

KFactor-

If you want to pass a value to another server, but don't want the value to
be visible to the user in the url, you might try sending
the value in a cookie. In the first page:

Response.Cookies.Add(new System.Web.HttpCookie("userID", "300"));
Response.Redirect("http://somserver.net/Test.aspx");

Inside the destination page:

this.Response.Write("User ID is " + this.Request.Cookies["userID"].Value);

This scheme will pass a value from server to server, without the value
being in the querystring. Of course, it's not the least bit
_secure_, as the cookies are sent in the HTTP request, and it's not
difficult to look at the request.

Another suggestion:

Do you want the data to be secure? You could encrypt the userID on the
first machine, attach it to the querystring (or put it in a
cookie), and decrypt it on the target machine.

System.Security.Cryptography has some classes that will let you encrypt
and decrypt text (DESCryptoServiceProvider is your friend
here). If you can distribute a shared secrect key to both servers, the
encrypted userID will be pretty safe unless someone gets hold
of the secret key.

Hope this helps,
Jim Suruda

Dec 7 '05 #3
Naseem,
I am a little confused. Did you try and add a new group? You should
be able to drill-down on each group, but as you are probably aware that
each group added will be above or below the previous group. You may
want to look into adding a subreport instead of adding multiple groups.

-brian

Naseem wrote:
I am using CR in ASP.NET , I am able to show drill down graphs where
grouping is done on single column from result set of sql query, is it
possible to achieve drill down by grouping on multiple groups?

-Naseem


Dec 7 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Atif | last post by:
Hi Two problem are there. 1- I am using Crystal Reports 9.0. I want to Drill Down into the CrossTab. 2- Using Sub Report into a Sub Report
5
by: BStorm | last post by:
I have a transaction log file where the DataSet table's Description column is actually delimited into "subcolumns" based upon the transaction id. I would like to parse these into separate fields...
3
by: Gheaci Maschl | last post by:
Hi all! I would like to have your opinion about my problem and my proposal how to solve it: Ingredients: - BTriev database - Crystal Reports - maybe MS Access - Liinos6 (small ERP software)
0
by: jpeters | last post by:
I am trying to create a crystal report in c# dotnet environment that allows the user to drill down. I have divided the report into groups and made them drillable. So for example the user can...
2
by: mrwoopey | last post by:
Hi, I need to be able to click onto a map and then drill down to a report. For example, could we have a map of the Chicagoland area with clickable areas (zip code) and when a user clicks on an...
0
by: adamz5 | last post by:
I am currently exporting a crystal report using code. This works fine and exports the report to a word document onto disk using DiskFileDestinationOptions() and ExportOptions However when i...
0
by: RAF | last post by:
is it possible to drill down on stacked bar graph
3
by: VMI | last post by:
I know this may not be the best NG for this, but I feel you guys know more about this than any of the other NGs. I need to build several simple reports (over 50 of them and they get their data...
3
by: Miro | last post by:
Hi, Just wondering what a good book is on visual studios 2008 ( or 2005 if no 2008 ) that teaches you how to properly use crystal reports with it. Or im assuming that as long as I can create a...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.