|
Please help;
For a couple days I've been battling with writing a report that has to tables linked by a Inner join.
I think I found a work around. I'm using an SQL SERVER database.
Crystal was creating the following query:
SELECT t_EMPINFO.c_EmpFName,
t_EMPINFO.c_EmpCode,
t_Employee_Salary.c_TotalIncome, t_Employee_Salary.c_TotalDeduction,
t_Employee_Salary.c_TotalSalary
FROM t_EMPINFO INNER JOIN
t_Employee_Salary ON t_EMPINFO.c_EmpID = t_Employee_Salary.c_EmpId
WHERE (t_EMPINFO.c_Softdelete = '1') AND (t_Employee_Salary.c_SoftDelete = '1') AND (t_Employee_Salary.c_Year = 'PARAMETER1') AND (t_Employee_Salary.c_Month ='PARAMETER2')
IN Above Query In place of ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) PARAMETER1 and PARAMETER2 I want to pass Differnt value at the run time (e.g 2007 , 01 ) how it's set dynamically
I have questions though:
1) Is it possible to change the sql that crystal generates without writing my own sql command?
Thanks again for all of your help on this!
|
|
|
|
|
|
Hi,
If you are using VS2005. I think the following will helps to you.
1) Make the EnableParameterPrompt to false.
2) For your example create two text box and a button.
3) In the button click event add the following code.
CrystalReportSource1.ReportDocument.SetParameterValue(0,TextBox1.Text)
CrystalReportSource1.ReportDocument.SetParameterValue(1,TextBox2.Text)
Thats it.
|
|
|
|
|
Hi,
I've a dropdownlist which I'm populating through Javascript.
Initially, it doesn't have any value , but based on selection in other dropdownlist, some values are added in dropdownlist.
My problem is that when page is posted back on server, it doesn't contain any value there.
Please help.
Thanks and Regards
Irshad
|
|
|
|
|
Hi to All,
How can I use FrameSet with ASP.NET2 AND C#?
|
|
|
|
|
Hi,
you can use following code in html code:
when you use above code,you may not be able to switch to design view of aspx page,because frame is not compatible with asp.net2 but dont worry it will work properly in run time.
zahra yousefi
yousefi105@yahoo.com
|
|
|
|
|
Hi everyone
i have the problem to debug my web applications.
It is some previleges problem.
error is
"error while trying to run the project.you do not have previleges to debug web server process."
from this forum itself i got solution that i should attach aspnet_wp to my application.But
it did'nt allow me to attach aspnet_wp.exe
i m using windows XP.
error comes while i m going to attach aspnet_wp.exe
"unable to attach to process.Access is denied."
|
|
|
|
|
hi all
i m developing a site for our client.There r sevral Uploading Images Options so how can i store tht Images into Web Server which is hosting our site.According to my knowledge Server dosent give any Read/Write permission into security context.
so anyone can help me abut tht. if anyone help me abut FTP thn plz give me some appropriate Suggestion.
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Hi,
U can make a folder for images on seb server n then upload all images in that.
so that whatever images u need in ur site will directly fetched from the folder.
hope u want this only
|
|
|
|
|
dear diya
tnx
u r right at the point of view of my sites Images but i want to use the asp:upload controls and browse the image at runtime thn i want ot save tht image into web server. i.e Picture upload into sites.
hope u'll understand my Problem.
Actually i m searching for FTP too.
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
How can I get Printer List from server in asp.net 2?
Thanks
Mazy
"One who dives deep gets the pearls,the burning desire for realization brings the goal nearer." - Babuji
|
|
|
|
|
Hello guys, yeah I know I can't belive I'm sort of working on xmes eve....anyways this is the functionality I'm trying to implement (Link below). I already figured out how to change the body color...now I am working on changing the font style and size on the entire page??
Does anyone know where the source code might be for this sample?? I checked on gotdotnet but not on there. Is there anyhting I'm missing????
http://samples.gotdotnet.com/quickstart/aspplus/samples/apps/cookies1/VB/customize.aspx
|
|
|
|
|
http://forums.asp.net/thread/1409803.aspx
i think this link may be helpful to u..
Regards
Vmssanthosh
VMSSanthosh
|
|
|
|
|
What is the best way to produce and print simple reports from an ASP.NET application? I have an application hosted on a public web site (public hosting company), and would like to print simple reports without using such things as Crystal Reports since I have no access to the web server machine.
You could point me to any useful source for printing reports via an ASP.NET application.
|
|
|
|
|
I think the simplest is to format a "report" (e.g. a gridview of data on a web page) in your .aspx page, then let the user use the browser's print function.
|
|
|
|
|
You can use Report Viewer, But I think for that you must have VS 2005 .Just do some googling to confirm that.
|
|
|
|
|
I'm working on using authorization manager as policy data store for authorization and roles.. and i'm facing some problems i wish you can help me in
1)Do I have the ability to authorize users againest performing some action in ASP.Net page using AzMan while i'm using forms authentication not windows ? "it all depends on the user running the ASP.net as ithink when running in forms authentaction anonyoumus access is enabled and only one windows user will run for all users"
2)what is the use of such statment "it gets the user token but if there any more siple way .. and how this statment work"
HandleRef token = new HandleRef(this, ((HttpWorkerRequest)((IServiceProvider)Context).GetService(typeof(HttpWorkerRequest))).GetUserToken());
the token variable is then used like this
IAzClientContext context = iazApplication.InitializeClientContextFromToken((UInt64)token.Handle, 0);
wish you can help
My Regards
|
|
|
|
|
i declare a variable to track the number of visitors to my web app in .asax file like
app_start event
application("userscount")=0
session_start event
application("userscount")+=1
session_end event
application("userscount")-=1
on testing the webapp by opening several sessions of a page to test the count, the Session_Start event works fine, but on closing a session, teh session_end event does not decrement
pls help
t.aransiola
|
|
|
|
|
HI Aransiola,
If you use the Session variable rather then application as i saw in your example above then this will work fine.
Use like this:
Session("userscount") in place of application("userscount")
and if you want to count then application variable is fine but you have to use application_start event .
Vicky
|
|
|
|
|
did anybody know some free vb.net code to c# code convert tools,i prefer a application,beacause my poor net speed.
I think therefore I am
--~--~---------~--~----~------------~-------~--~----~
My Blog and Website：
http://www.cnblogs.com/pinzui/
http://www.pinzui.cn
http://jnlinux.org
--~--~---------~--~----~------------~-------~--~----~
|
|
|
|
|
Other than the online converters, all of the commercial VB to C# converters (including ours: Instant C#) have free demo/trial editions that will convert limited amounts of code at a time.
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
Instant C++: C# to C++ converter, VB to C++ converter
Instant Python: VB to Python converter
|
|
|
|
|
thanks for your reply.
I think therefore I am
--~--~---------~--~----~------------~-------~--~----~
My Blog and Website：
http://www.cnblogs.com/pinzui/
http://www.pinzui.cn
http://jnlinux.org
--~--~---------~--~----~------------~-------~--~----~
|
|
|
|
|
Hi dear,
For converting from VB to C# please go through the following link and that is very good tool absolutely free ....
http://www.eggheadcafe.com/articles/cstovbweb/converter.aspx
so enjoy it...
Vicky
|
|
|
|
|
convert vb to C# code follow the links
http://www.developerfusion.com/tools/convert/vb-to-csharp
http://www.dotnetspider.com/Convert/Vb-To-Csharp.aspx
priya
|
|
|
|
|
Hello all
I start developing a web application, in which I need to open other .aspx from the main master page, what is the best practice to implement this.
I have read about the QueryString, what is the full implementation of this, If I need to pass values to the same .aspx ..
What about creating contents page of the master page ...
Can someone help me to the best direction ...
Thanks, Best Regards
Waleed Seada
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
