473,386 Members | 1,693 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,386 software developers and data experts.

Passing querystring to a website through sql report

390 Expert 256MB
I am trying to develope one sql report .
In the hyperlink URL i would like open a URL which accepts queystring
like
http:\\localhost\mysite?t=FieldID.value

Now this FieldID.value will be dynamic based on the row for which the link will be clicked.
FieldID.value is a field in my dataset
My URL opens the site perfect but the querystring value comes as t=FieldID.value insted of the actual value of FieldID.value
which should be like 1,2 ,3 based on the row cliked.
Jul 14 '08 #1
3 1428
ck9663
2,878 Expert 2GB
Check your dynamic query on your front-end side.

-- CK
Jul 14 '08 #2
mzmishra
390 Expert 256MB
Thanks for the reply .I got the solution for my problem.
It is very basic thing.
I am adding the solution here which may help someone.

click the column u want as hyperlink.click navigation.jump to url.
then write the expression like
="http://localhost/mypage.aspx?t=R&id=" &Fields!confNum.Value

Now u r id will be dynamic since u r passing a field value there
Jul 14 '08 #3
ck9663
2,878 Expert 2GB
Yes, that's what am trying to say.

This is more of an issue on your front-end, not SQL Server.

Thanks for posting the solution...

-- CK
Jul 14 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: SusanC | last post by:
Hi folks. I have something here that I don't understand. I am passing a value held in a session variable on a url. It works fine locally testing but when I put it on the main web server the...
5
by: Jack | last post by:
Hi, I need to pass multple variables in a link in order to go to a asp page with the two varables. The following are the values of the variables using response.write: <%'Response.Write Mypage...
1
by: Russell | last post by:
Hi there, I'm currently creating a .NET Web Application and I have a question about passing values from one screen to another. I previously used Session variables in the code to store these...
5
by: Rod | last post by:
I've written 2 ASP.NET applications (I've worked on one with a team and another by myself). In my ASP.NET pages, when saving data to a backend database I've done it by using the click event of a...
1
by: Adeel Ahmad | last post by:
Hi, The subject sounds confusing but here is what i want to do. I have a button on my page which says...
3
by: bindurajeesh | last post by:
I want to open a crystal report using a viewer to do so and want to have my user click on a link to my webserver. The problem is the report is based on a stored procedure that requires a...
3
by: Tor Inge Rislaa | last post by:
Passing and using parameters How to get hold of the parameter value provided by the URL? When I open a web form with a DataSource I often include a parameter in the URL as below: ...
2
by: aarnan | last post by:
I have developed a website in ASP.NET 2.0 that is one of several accessed from the same protal. All of the other sites use ASP 3.0, and this is the first .NET site. The rest will be converted as...
6
by: djjohnst | last post by:
I am creating a program that will list program times for people who visit our website. Users can login create, edit, delete a program. These dump into a database. The ASP webpage then reads from...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.