Click to See Complete Forum and Search --> : [RESOLVED] passing parameter to Crystal Report


toraj58
December 24th, 2008, 04:34 AM
how to pass a parameter in ASP.NET to Crystal Report.

for example i have Crystal Report for Members Table (in SQL Server).
i want to pass a parameter to it in runtime in order to only generate for those members e.g. that their id is less than 50,000; something similar to this SQL query:


select * from members where id < 50000


for example i want a TextBox in .aspx (e.g. generate_report.aspx) that get the parameter and pass it to Crystal Report then Crystal Report generate report base on it.

i am using Visual Studio 2005 and .net 2.0

marceln
December 24th, 2008, 06:48 AM
This is what you need to do: http://www.thescarms.com/dotnet/CrystalParms.aspx

toraj58
December 24th, 2008, 10:23 AM
thanks; i got some clue from it.

toraj58
December 29th, 2008, 07:57 AM
my problem resolved by using of SQL Expert and some code.