|
Hi, Pls am new in crystal report in ASP.NET 2008 (usign VB codes). I created a CR using dataset (DataTable). Tested it with an SQL statement and it displays data. When I remove the direct where clause conditions to use parameter (because i will display the parameter as header information), it is giving me "Missing parameter values." Can someone help me. The code is below:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
Dim conn As New OracleConnection(ConnectionString)
Dim MyDA As New OracleClient.OracleDataAdapter
Dim vacancyid As Integer = Request.QueryString("vacancyid")
Dim sql As String = ""
Dim cmd As New OracleCommand(sql, conn)
sql = "select a.VACANCY_ID,a.VAC_TITLE,a.PUBLISH_SDT,a.PUBLISH_EDT,a.MAX_SAL,b.OFFER_DT,b.SALARY "
sql = sql & " from vacancy a,offer_tbl b where a.COMPANY_ID=b.COMPANY_ID and a.VACANCY_ID=b.VACANCY_ID "
sql = sql & " and a.VACANCY_ID='" & vacancyid & "' and a.VAC_STATUS='F' order by VACANCY_ID"
cmd.CommandText = sql
cmd.CommandType = CommandType.Text
MyDA.SelectCommand = cmd
Dim myDS As New Vacancy_Test
MyDA.Fill(myDS, "DataTable1")
'====== Running the report directly with this statement works
' ''sql = "select a.VACANCY_ID,a.VAC_TITLE,a.PUBLISH_SDT,a.PUBLISH_EDT,a.MAX_SAL,b.OFFER_DT,b.SALARY "
' ''sql = sql & " from vacancy a,offer_tbl b where a.COMPANY_ID=b.COMPANY_ID and a.VACANCY_ID=b.VACANCY_ID "
' ''sql = sql & " and a.COMPANY_ID='1' and a.VACANCY_ID=1 and a.VAC_STATUS='F' "
' ''sql = sql & " order by VACANCY_ID"
'===================
Dim oRpt As New ReportDocument()
'Dim rpt As New ReportDocument
Dim reportPath As String = Server.MapPath("Vacancy-Test.rpt")
oRpt.Load(reportPath, OpenReportMethod.OpenReportByDefault)
Dim ParamFields As ParameterFields = Me.CrystalReportViewer1.ParameterFieldInfo
Dim p_vacancyid As New ParameterField
p_vacancyid.Name = "rpt_VacancyID" ' THE PARAMETER IN THE REPORT
Dim p_vacancyid_value As New ParameterDiscreteValue()
p_vacancyid_value.Value = Convert.ToInt32(vacancyid)
p_vacancyid.CurrentValues.Add(p_vacancyid_value)
ParamFields.Add(p_vacancyid)
'oRpt.DataDefinition.ParameterFields()
oRpt.SetDataSource(myDS)
CrystalReportViewer1.ReportSource = oRpt
End Sub
none
|
|
|
|
|
Use this function as per your need
private void setCurrentValuesForParameterField(ReportDocument rptDocument, string[] paramValue)
{
ParameterValues currentParameterValues = new ParameterValues();
ParameterFieldDefinitions parameterFieldDefinitions = rptDocument.DataDefinition.ParameterFields;
for (int i = 0; i < parameterFieldDefinitions.Count; i++)
{
ParameterFieldDefinition parameterFieldLocation = parameterFieldDefinitions[i];
currentParameterValues = parameterFieldLocation.CurrentValues;
ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
if (paramValue.Length - 1 >= i)
{
parameterDiscreteValue.Value = paramValue[i].ToString();
currentParameterValues.Add(parameterDiscreteValue);
parameterFieldLocation.ApplyCurrentValues(currentParameterValues);
}
}
}
|
|
|
|
|
Please am using VB code not C#. can someone help on VB Code
Thanks
Joe
none
|
|
|
|
|
|
Hi,
I had written a webservice..which is working fine. This webservice will reside in server.
Now if I have make this webservice work for multiple servers.
Right now Iam adding a webrefernce to my application which is consuming webservice.
if this webservice has to be utilised globally..then what I have to do?
If I have to host the same webservice on different servers that leads to waste memory..since in all web methods in all the webservices have same logic and same datatype.
1.To make the same webservcie work on mutiple servers....
2. How add web refernce globally through programatically
3. If to make the webservcie work globally what are the paarameters I have to pass for them?.
4. what is best mechanism to check whether server running or down?
Kindly help me in achieving above
So kindly tell me wat is the best way..
|
|
|
|
|
My application is written in ASP VB.Net VS-2002.
Parser Error Message: The XML file c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config could not be loaded. Attempted to access an unloaded AppDomain.
This is always after returning from :
-
myProcess = Process.Start(my.exe, sArguments)
Do While Not myProcess.HasExited
System.Threading.Thread.Sleep(10000) 'Every ten Seconds.
Loop
Or :
-
myProcess = Process.Start(my.exe, sArguments)
Do Until myProcess.WaitForExit(Timeout.Infinite)
' ....... code to write to log file.
Loop
|
|
|
|
|
For anyone else that might be experiencing this issue or something similar, the only way I was able to get around the process threading issue was to write my own HasCompleted vb routine looping for the existence of an end of process file.
|
|
|
|
|
grr
why am I getting this error: Too many characters in character literal
with this code
<asp:ImageButton ImageUrl="~/Images/minimize.gif" runat="server" ID="ImageButton1" PostBackUrl="~/Help.aspx?help=help1" ImageAlign="AbsMiddle" OnClick="window.open(this.href,'popupwindow','width=850,height=700,scrollbars,resizable');return false;" /></li>
thanks
|
|
|
|
|
I think because PostBackUrl and OnClick are the same thing.
|
|
|
|
|
OK got rid of the error but have another problem now.
When I enter a URL it keeps putting a deafult pre address in it so lets say the file the above code is in is in folder1 well it does this on the url folder1/folder2/page.aspx instead of just folder2/page.aspx
why would this be?
thanks
|
|
|
|
|
I'm not too sure what you mean. Could you please paste some more code and I might be able to help.
|
|
|
|
|
sorted it, needed to put full url path in
cheers
|
|
|
|
|
I have a problem with mac and safari.
In windows and ie you can define for example word to open a document in the same window for editing.
But with Mac with Safari there is a problem.
If you have a file named: test.rtf in the root of your webservers default catalog, the only thing you have to do is create a href string like this "\\webserver\test.rtf" and configure windows explorer to open the rtf extension in the same windows as explorer.
If you use Safari insted of IE there is problems, but is'nt there any workaround for this problems?
Does anyone have experience of this things please reply.
|
|
|
|
|
i am using sphorium framework webdav.net from sourceforge.net
its having webdav.net framework its maintaining only filesystem
in that same framework i want with sql storage
i want the coding in asp.net with c#
anybody developed please give the details
modified on Thursday, August 7, 2008 3:43 AM
|
|
|
|
|
Dont come here asking for chunks of code you will only get abuse
|
|
|
|
|
I have a customvalidator for textbox' in a gridview. The problem is, it doesn't fire up. I did put a break point to validation method but it never catches. The code is working fine in a single page with a single textbox but not in a GridView Can you please tell me what's wrong? Here's my code:
<asp:Content>
<script language="c#" runat="server">
private void NumericControl(object sender, ServerValidateEventArgs args)
{
if (Tools.IsNumeric(args.Value))
args.IsValid = true;
else
args.IsValid = false;
}
</script>
<asp:GridView>
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:TextBox ID="txtValue" runat="server" Width="50" /><br />
<asp:CustomValidator ControlToValidate="txtValue"
EnableClientScript="true"
ClientValidationFunction="NumericControl"
ErrorMessage="Not numeric"
OnServerValidate="NumericControl"
runat="server"
ValidationGroup="Kontor"
Display="Dynamic"
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</asp:Content>
|
|
|
|
|
Check if your button has CausesValidation = true and the ValidationGroup = "Kontor";
And Set the ValidationGroup="Kontor" for the TextBox
EG
<asp:textbox id="txtValue" runat="server" width="50" validationgroup="Kontor" xmlns:asp="#unknown" />
|
|
|
|
|
I did. I added ValidationGroup to textbox and ValidationGroup and CausesValidation to button. Nothing changed. Thanks for the advice though..
|
|
|
|
|
|
|
Problem because the gridview is generated at runtime therefore control validate has to.. maybe
|
|
|
|
|
HI,
I was trying to apply styles like width height and border for dropdownlist control in asp.net using CSS. It works fine in Mozilla but for ie 7 its not working. Can anybody help me .Any workarouns for this
Thanx in advance
|
|
|
|
|
hai
i think it is the problem of IE 7 i have also faced this problem so use earlier version
|
|
|
|
|
hi
every one
i am trying to make website setup.
but in add project output group
wimdow i am able to see only content file
option other options are not visible to
me.
how i can make webset up .
so that i can access it to other
computer.
thanks..gaurav
|
|
|
|
|
Sorry if this annoys anyone, but I'm only looking for rough ideas, not a whole solution, and my prior thread on the subject[^] has fallen off the map with no replies at all.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
