JO No, i click a hyperlink in a page which directs to default.aspx like this /default.aspx?Server_id=45 then in default.aspx i have a request.querystring('server_id') statement, this all works, and i can read the value 45, but i cant insert the request statement into the crystalreportsource control! Im not great with VB, and so dont really understand what you mean by ur last post Jo, but am i wrong in my method, surely it should be so simple! Could it be something got to do with the crystalreportsource control. like it doesnt accept asp code in the middle of it?? I am also reviewing this example, and i cant pass a parameter into that either!!! http://www.codeproject.com/vb/net/CrystalReports_in_VBNET.asp[^] Aaaaahhhh, please someone help :sigh:

Jo, thanks for your reply and suggestions 1. no i dont get any runtime exception 2. yes the parameters match 3. i tried ur method but it acts the same as mine, it simply prompts for the parameter, server_id i was reading on MSDN site that one can use a querystringparameter; http://msdn2.microsoft.com/en-us/library/ms227827(VS.80).aspx[^] However i cannot find any example that use this and cannot get the querystringparameter tag to work! Could it be that the crystalreportsource control does not allow this segment of asp code?? Could it be somethin wrong with my web.config file or something im not including in the default.aspx.vb page???? Any help would be great, Thanks again

Hello all, I have been working on this project for quite some time now and to be honest i cant stand it anymore! I have a simple request, i want to get a parameter, taken from a querysting and pass it to a crystal report. I have setup the crystal report viewer on my default.aspx page and by setting the default value of the parameter, i am able to view the crystal report. Here is the follwing code that i use --------------------------------------------------------------------------------- ------------------------------------------------------------------------------------ This code works fine, however i want to have the parameter SERVER_ID to be taken from a querystring sent to this page! Si in my innocence i thought, instead of having the defaultvalue="45" can i use DefaultValue=" <% response.write request.querystring('server_id') %>" but this doesnt work. I have read somewhere that like a control parameter one can code a querystring parameter! Does anyone know how to do this?? Im sure someone can help me, the idea behinf this is so simple, but im only new to Asp and am not sure where im goin wrong. If anyone can help it would be greatly appreciated!

Hello all, I am currently working on a project where i want to have a webpage that passes a parameter to a crystal report, which then displays a result based on the parameter. I have built the webpage and the report but am having problems pasing the parameter, i have been following the guidelines outlined on this page; http://www.codeproject.com/script/comments/forums.asp?msg=1855661&forumid=1646&mode=all&userid=3569060#xx1855661xx[^] But am geetin an error when trying to pass the parameter. I have posted an message below this article, but still have found no-one who can help! Any help would be greatly appreciated! thanks guys!

I wonder can someone help me with a project im working on I am currently creating an WebSite in asp.net, which links to some crystal reports. Now im new to asp.net and dont have an advanced level of VB knowledge. However i was able to view the reports on an .aspx page using the crystalreportsviewer object. Now what im trying to do seems extremely simple but yet i havent found a simple explanation on the web. My report designed in VisStudio 2005, prompts for a parameter before executing and displaying the result. So simply, what i would like to do is link to the report and pass this parameter without having to manually enter it on the webpage! So i am going to pass the value via a querystring into the page to contains the viewer, upon which the code will set this value as the parameter and request the report! Here's the code i have with just the viewer; <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> <%@ Register TagPrefix="CR" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" %> Untitled Page < CR:CrystalReportViewer ID="CrystalReportViewer1" Runat="server" AutoDataBind="True" Height="947px" ReportSourceID="CrystalReportSource1" Width="845px" /> < CR:CrystalReportSource ID="CrystalReportSource1" runat="server"> < /Report> < /CR: CrystalReportSource> I have read article that say to use the reportdocument class, but i cannot find sny information on how to use this! Surely there HAS to be a simply way of setting the parameter, something like this: parameter.name.value = "Value" Anyway any help would be greatly appreciated! -- modified at 4:50 Tuesday 23rd January, 2007

Since no-one knows how to do this can anyone direct me to a webpage or an .asp script that could do this! Is there a name for this kind of sorting?

yes i know that SQL statement. But then the list sorting is not dynamic, what if lots of 'BAT' customers were added to the table, one would then have to go into the code and add the SQL statement for that! i need to use arrays that sift through the table plucking out groups of names that have similar first letters! i just dont know the best approach!

Can any1 help please, i just need some advice on the best approach to this problem!

Hey everyone, Im currently workin on a little project for work which is driving me insane! I didnt want it to come to this (asking experts for help) but i feel the project needs some fresh eyes to guide me to a better solution. So let me just outline what im trying to do; First, we have a large list of customers on our server, approx 1316 customers. Now on our intranet webpage i wish to create a fast way of finding customers using an ASP tree. So consider a list of customer names returned from an SQL query into a large array. I then wish to check the first couple of letters of each customer, and group customers with similiar names together under one branch in the tree. The Result would look something like this; Customers | |-A ___|-ar ______-arson, pat ______-arson, mick ______-arsen, jon ______... ______... ___|-as ______-asnot, mark ______... ______... ___|-Other A's ______... ______... |-B ___|-ba ______|-bai __________-bailey, john __________-bailey, mark __________... __________... ______|-bar __________-barker, paul __________-barton, mike __________... __________... ___|-br ______-bromich, dave ______-brockurst, mick ______... ______... ___|-Other B's ______... ______... |-C ___-charles, john ___-chaplin, pat ______-chan, johnny |-D ___|-da . . . .... just to explain anything with a | beside it represents a branch which has leaves while anythin with just - represents a leaf which will hold a customer name One main important thing about this code is that i want it to be very dynamic and one important feature is groups of similar names, being grouped in their own branch. For example the code should read like; if there are less than X names beginning with 'ar' then group these names under a branch called 'ar' But if there are more than X names beginning with 'ar' then search again through this group and compare the first 3 letters for similarity. This idea is shown in the B section, here the code found more than X names with -ba as the first two letters, and so and the code ran again comparing the first three letters, these groups of three letters had less hits than X and so are plotted in their own trees -bai and -bar. I hope you can follow me now as you read this and it makes some sort of sense! I want it to be so dynamic that lets say, we enter many customers with names starting with -bai, the program will then scan the first four letters of the name and if this is over X, it will scan the first five letters of each name, if ag

Hey everyone, Im pretty much a n00b to asp but have a bit of programming experience. Im currently workin on a little project for work which is driving me insane! I didnt want it to come to this (asking experts for help) but i feel the project needs some fresh eyes to guide me to a better solution. So let me just outline what im trying to do; First, we have a large list of customers on our server, approx 1316 customers. Now on our intranet webpage i wish to create a fast way of finding customers using an ASP tree. So consider a list of customer names returned from an SQL query into a large array. I then wish to check the first couple of letters of each customer, and group customers with similiar names together under one branch in the tree. The Result would look something like this; Customers | |-A ___|-ar ______-arson, pat ______-arson, mick ______-arsen, jon ______... ______... ___|-as ______-asnot, mark ______... ______... ___|-Other A's ______... ______... |-B ___|-ba ______|-bai __________-bailey, john __________-bailey, mark __________... __________... ______|-bar __________-barker, paul __________-barton, mike __________... __________... ___|-br ______-bromich, dave ______-brockurst, mick ______... ______... ___|-Other B's ______... ______... |-C ___-charles, john ___-chaplin, pat ______-chan, johnny |-D ___|-da . . . .... just to explain anything with a | beside it represents a branch which has leaves while anythin with just - represents a leaf which will hold a customer name One main important thing about this code is that i want it to be very dynamic and one important feature is groups of similar names, being grouped in their own branch. For example the code should read like; if there are less than X names beginning with 'ar' then group these names under a branch called 'ar' But if there are more than X names beginning with 'ar' then search again through this group and compare the first 3 letters for similarity. This idea is shown in the B section, here the code found more than X names with -ba as the first two letters, and so and the code ran again comparing the first three letters, these groups of three letters had less hits than X and so are plotted in their own trees -bai and -bar. I hope you can follow me now as you read this and it makes some sort of sense! I want it to be so dynamic that lets say, we enter many customers with names starting with -bai, the program will then scan the first four letter

Thanks Sir, Actually im new in a Job and am learnin SQL on my own, so my knowledge of these different commands is limited. Thanks though, anymore hints would be great!

Hey everyone! I have been scouring the internet for help on an SQL query i need to run and have been trying for a day or two now to no avail! Can any SQL heroes please help me??? My problem seems simple but may not be so! In this example i have two tables, with their respective columns beside in brackets! 1. SERVERS (ID, NAME, LOCATION, OS) 2. SERVERS_VM (PHYSICAL_ID, VIRTUAL_ID) The columns ID, PHYSICAL_ID and VIRTUAL_ID are all primary keys! Now consider that the SERVERS table contains lots of servers both physical and virtual each with their own unique primary key labelled ID. While the SERVERS_VM table contains a list of all physical servers that have virtual servers installed on them! So each PHYSICAL_ID in SERVERS_VM might have one or more VIRTUAL_ID's associated with it. Below i will try to give an example; SERVERS ------------------------------------------- ID Name Location o/s ------------------------------------------- 1 Bob12 BobOffice Win Server 23 Ash14 AshOffice Virtual 7 Hank89 Hankoffice Win Server 14 Tom98 Tomoffice Virtual 8 Mark45 Markoffice Win Server 93 Bar123 Baroffice Virtual SERVERS_VM --------------------------- PHYSICAL_ID VIRTUAL_ID --------------------------- 7 23 8 14 7 93 Ok so, now not trying to confuse people, but if we see above, Ash14 tom98 and bar123 are virtual servers (os=virtual) located on physical servers (shown in servers_vm) From SERVERS_VM we can see that server number 7 houses two virtual servers given by their VIRTUAL_ID which is the same as the ID i the SERVERS table! (23 & 93) So heres is the big question? How can i run an SQL query to list all the physical servers that have virtual servers alone installed on them?? The results should be something like; --------------------------------------------- ID NAME VIRTUAL_ID --------------------------------------------- 7 Hank89 23 7 Hank89 93 8 Mark45 14 the problem is the fact that there are two primary keys in the SERVERS_VM table, well even though the PHYSICAL_ID repeats in the SERVERS_VM table this is what i have so far; SELECT PHYSICAL_ID, VIRTUAL_ID FROM (SELECT ID, NAME FROM SERVERS WHERE OS like '%Virtual%') WHERE SERVERS.ID=SERVERS_VM.VIRTUAL_ID i have gone to much more de