|
Willem_Le_Roux wrote: How do I pass the invoice number to the report and have it display all entries of the selected invoice number only?
You have an option in the report to set parameters. You can set a parameter and then you can send the parameter from the dialog box.
You could write a function like this
<br />
private ParameterField AddParameter (string paramName, string paramValue)<br />
{ <br />
ParameterField paramField= new ParameterField();<br />
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue ();<br />
ParameterValues paramValues = new ParameterValues ();<br />
paramField.ParameterFieldName = paramName; <br />
paramDiscreteValue.Value = paramValue;<br />
paramValues.Add (paramDiscreteValue);<br />
paramField.CurrentValues = paramValues;<br />
<br />
return paramField;<br />
}<br />
And to add a parameter
<br />
private CrystalDecisions.Windows.Forms.CrystalReportViewer crResults;<br />
crResults = new CrystalDecisions.Windows.Forms.CrystalReportViewer();<br />
<br />
rptMyReport crReportDocument = new rptMyReport();<br />
crResults.ReportSource = crReportDocument;<br />
<br />
CrystalDecisions.Shared.ParameterFields paramFields = crResults.ParameterFieldInfo; <br />
paramFields.Add(AddParameter("paramName",strValue)); <br />
Tarakeshwar
MCP, CCIE Q(R&S)
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW
-- modified at 9:19 Monday 26th June, 2006
|
|
|
|
|
Hi Tarakeshwar!
In future I promise to write a little article on the subject and I will be sure to put your name all over the place. I will also do all future communication via the forums for all to see. Sorry about that my fellow gurus! 
I made the requested changes and and the "report.Load(strReportPath);" seems to be working now. 
But I am still having a problem with the line "paramFields.Add(AddParameter(PARAMETER, strTransactNo));" When I run the application it states that "Object reference not set to an instance of an object". 
Willem Le Roux
I wish that the designers of programming languages would start writing their error messages in English... 
-- modified at 7:30 Wednesday 28th June, 2006
|
|
|
|
|
Have you added a crystal report viewer to your screen and named it as crystalReportViewer? I amnot sure why your getting that error.
Can you debug and tell me the exact point your getting this error and if you can put a try catch and paste the error here.
Tarakeshwar
MCP, CCIE Q(R&S)
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW
|
|
|
|
|
My Crystal Report Viewer is the only control on my frmReport form. The Crystal Report Viewer's name is "crystalReportViewer".
The try/catch is showing the following error:
System.NullReferenceException: Object reference not set to an instance of an object. At ProgName.frmReport.ConfigReport() in D:\ProgName\ProgName\frmReport.cs:line 47
And the line of code on Line 47 is
paramFields.Add(AddParameter(PARAMETER, strTransactNo));
In despiration I added a few MessageBoxes to see were exactly the error happens. As It runs through AddParameter(string paramName, string paramValue) it seems to catch the exception just before "return paramField;"
Why... I don't know.
Willem Le Roux
|
|
|
|
|
I have tried to have a look at it, I am not sure why your getting that error. I would suggest you to see what is the paramName and paramValue inside the AddParameters function, probably its going as null or something.
Tarakeshwar
MCP, CCIE Q(R&S)
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW
|
|
|
|
|
My goodness golly me... I dont know. I added the following to AddParameter function...
MessageBox.Show("Param Name: " + "*" + paramName.ToString() + "*");
MessageBox.Show("Param Value: " + "*" + paramValue.ToString() + "*");
and it displayed the following on screen...
Param Name: *TRASNACTNO*
Param Value: *Habula Lodge 2006\06\28 11:22:07 AM*
...seems correct.
I know this is a little beyond the norm and it might be seen as a little bit of "spoon feeding"... which it is I suppose, but is there any possablility that you could email me a little project with a working sample. This way I can compare code and see where I went wrong. I will understand if you say no... Company policies, extra effort and so on.
What ever way this goes, I want to thank you for your patience, time and quick responces! You rock man! Your help is much appreciated!
Willem Le Roux
|
|
|
|
|
Actually what I pasted you was from a working code I am using.
Have you declared the Paramenter TRASNACTNO in your crystal report?
And are you sure that your using the same spelling on TRASNACTNO and not TRANSACTNO in one place and TRASNACTNO in other.
Tarakeshwar
MCP, CCIE Q(R&S)
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW
|
|
|
|
|
That whole TRASNACTNO - TRANSACTNO thing was a typo from my side... Hehe. Sorry!
I must confess, I did not declare the TRANSACTNO parameter in Crystal, But I have now, and I seem to get the same error! I will go through all we have done so far, and check if I can spot something that is out of the norm.
Thanx for all your help so far buddy! I will be in contact...
Willem Le Roux
|
|
|
|
|
Can you perhaps paste your ConfigureReport() function in here again please?
Willem Le Roux
|
|
|
|
|
<br />
private CrystalDecisions.Windows.Forms.CrystalReportViewer crViewer;<br />
crViewer = new CrystalDecisions.Windows.Forms.CrystalReportViewer();<br />
<br />
rptSampleReport crResults = new rptSampleReport(); <br />
Database crDatabase; <br />
Tables crTables; <br />
Table crTable; <br />
TableLogOnInfo crTableLogOnInfo; <br />
ConnectionInfo crConnectionInfo = new ConnectionInfo(); <br />
<br />
crConnectionInfo.ServerName=strServerName;<br />
crConnectionInfo.DatabaseName = strDatabaseName; <br />
crConnectionInfo.UserID = strSqlUserName; <br />
crConnectionInfo.Password = strSqlPassword; <br />
<br />
crDatabase = crResults.Database; <br />
crTables = crDatabase.Tables; <br />
<br />
for (int i = 0; i < crTables.Count; i++) <br />
{ <br />
crTable = crTables [i]; <br />
crTableLogOnInfo = crTable.LogOnInfo; <br />
crTableLogOnInfo.ConnectionInfo = crConnectionInfo; <br />
crTable.ApplyLogOnInfo(crTableLogOnInfo); <br />
}<br />
<br />
crViewer.ReportSource=crResults;<br />
CrystalDecisions.Shared.ParameterFields paramFields= crViewer.ParameterFieldInfo;<br />
paramFields.Add(AddParameter("@TransactionID",strTransactionNo)); <br />
<br />
crViewer.Show();<br />
Tarakeshwar
MCP, CCIE Q(R&S)
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
!sgub evah t'nseod margorP sihT ?sgub naem ayaddahW
|
|
|
|
|
Hello, I am a new member of the code project and i have found this site to be a very interesting and helpful place. This is my first blog but this site have already helped me through so much. However i came accross one very confusing problem in .net. I am working with web services and i am creating a client for a service that someone else already have in place. I generated a proxy class from wsdl, with some complex type that if null will be notified by <var nil:true> no matter what the variable type is.
Now the problem is when i send in a request value that does not exists in their database, its normal for them to return null, but my application, the client application throw a nullreference exception. Saying that the input format is incorrect. I am a newbie with web service and i have been trying to trace the problem, when the search value exists this does not happen. Here is the stack trace and a sample soap message. Hope someone can help me out.. THankz.
<CP0307I01Response xmlns="namespace">
<EAIHeader>
<serviceId>ID</serviceId>
<beginTimestamp>2006-06-26T15:40:26.125+07:00</beginTimestamp>
<endTimestamp>2006-06-26T15:35:11.955+07:00</endTimestamp>
<transactionId>0f7a58bf0ac6321501fd4878a404f1f5</transactionId>
<sourceTransactionId>3000</sourceTransactionId>
<sourceSystem>RSB</sourceSystem>
<userId>user</userId>
<password>password</password>
<status>3</status>
<reasonCode>60007</reasonCode>
<reasonDesc>CPACholder not found</reasonDesc>
</EAIHeader>
<CPACholder>
<cardExpDate xsi:nil="true"></cardExpDate>
<cardholderID xsi:nil="true"></cardholderID>
<creditLimit xsi:nil="true"></creditLimit>
<currentAcctNo xsi:nil="true"></currentAcctNo>
<fstEbName xsi:nil="true"></fstEbName>
<ownCustObj xsi:nil="true"></ownCustObj>
<savingAcctNo xsi:nil="true"></savingAcctNo>
</CPACholder>
</CP0307I01Response>
Stack trace : err msg = "There is an error in xml document (4,677)"
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at CP0307I01.doService(EAIHeader& EAIHeader, CPACCardholder& CPACCardholder) in D:\e-MobileApplicationProjects\asynWebTest\asynWebTest\CP0307I01ProxyClass.cs:line 42
at asynWebTest.Program.Main(String[] args) in D:\e-MobileApplicationProjects\asynWebTest\asynWebTest\Program.cs:line 22
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Thznk in advance i have been trying to figure it out for many days hopefully someone with enough experience will know 
Wicky
|
|
|
|
|
Hi,
When i tried to "Add New Item" (Crystal Report), there is no Template for Crystal Report in the Template area. Is there any way to add it exclusively, or need to change some sort of settings?
Or it is the matter of installation. I first installed the .Net VS 2005 Express edition (C#) a month ago, and installed recently, Crystal report 10. I'm using SQL Server 2000 at back.
I just want to include reports in my windows application, and for this tried various methods (including report binding options from MSDN too), but no use.
Can anybody help in this regard. Any idea, suggestion, guideline please.
Thanks
_____________________________
Success is not something to wait for, its something to work for.
-- modified at 7:29 Monday 26th June, 2006
|
|
|
|
|
Hi,
I've implemented a class (see below) to handle communications for multiple objects that use a separate thread to handle UDP communications over the same ports using the UdpClient class (.net 2.0). To be sure only one instance can be made for each port I've implemented this in a static way. As you can see below this looks relatively simple.
However, once I've started listening for data using "listen" and the callback is made, the EndReceive (I marked it below) method gets me an error:
"The I/O operation has been aborted because of either a thread exit or an application request"
I've checked for possible thread abortion, but I'm sure this isn't the case. So my question is: what causes this error?
Also, I don't see why it's necessary to pass a reference to the endpoint in the EndreceiveMethod: Isn't the callback made because data was received from a known endpoint? Does the endreceive method update the endpoint passed to the endpoint the data was actually received from (so that I can delegate this to my evenlisteners)?
I've checked MSDN docs on "EndReceive" but they don't comment on this.
Any comments or suggestions are very welomce, thanks in advance!
<br />
class LineConnection<br />
{<br />
static UdpClient receiver = new UdpClient(5048);<br />
static UdpClient sender = new UdpClient(5049);<br />
public delegate void DataReceivedDelegate(byte[] d, IPEndPoint endpoint);<br />
public static event DataReceivedDelegate DataReceived;<br />
public static bool receiving;<br />
<br />
public static void Send(byte[] b, IPEndPoint ipe)<br />
{<br />
sender.Send(b, b.Length, ipe);<br />
}<br />
<br />
public static void listen()<br />
{<br />
if (!receiving)<br />
{<br />
receiver.BeginReceive(ReceivedData, null);<br />
}<br />
}<br />
<br />
private static void ReceivedData(IAsyncResult result)<br />
{<br />
if (result.IsCompleted)<br />
{<br />
try<br />
{<br />
receiving = false;<br />
IPEndPoint end = new IPEndPoint(IPAddress.Any, 5048);<br />
<br />
byte[] b = receiver.EndReceive(result, ref end); <br />
<br />
if (DataReceived != null && b != null)<br />
DataReceived(b, end);<br />
}<br />
catch (Exception e)<br />
{<br />
Console.WriteLine("Error getting data: "<br />
+ e.ToString());<br />
}<br />
}<br />
}<br />
}<br />
|
|
|
|
|
sjembek wrote: IPEndPoint end = new IPEndPoint(IPAddress.Any, 5048);
Try:
IPEndPoint end = null;
|
|
|
|
|
No luck, unfortunately, I get the same error-message
|
|
|
|
|
Try running the receive syncronous and in another thread.
|
|
|
|
|
Yep, that's what I did, and that works. But I'd still like to know what the problem is, there's no reason this shouldn't work.
|
|
|
|
|
Hello, i am a newbie to Microsoft Communication server, I need help on development of Instant messenger using communication server API's
(i don't know is it possible or not but i heard that its possible)
(i had implemented chat programs using sockets.)
if anybody know things about this, please reply..
|
|
|
|
|
Hi to all,
How to use function "GetData(ref object DataBindings,object type, object maxlen)" of WinsockClass in Visual C#? If possible give me ex. how to call this function or what should be parameter of this function?
Best Regards & Thanks,
Aniket Salunkhe
-- modified at 5:51 Monday 26th June, 2006
|
|
|
|
|
Hi all!!
If I upload files and want to save it to a different file format, how do I do this in .NET 2.0?
What I mean is, if I upload a file called MyFile.gif, how do I specifyy how to resave it to MyFile.jpg? It's easy to go and change the extension, but when I change a .gif file to a .jpg file in my graphics editor, then it is usually redused in size.
Can any one let me know what to go and search on at Google? I tried "image manipulation .net 2.0". Nothing returns, or very little in fact.
Regards
ma se
|
|
|
|
|
May you use GDI+, using Image and save as another filet type.
|
|
|
|
|
I'm not sure what GDI is?? But I would like to keep it .NET as far as possible.
|
|
|
|
|
/*
System.Drawing.Image image = System.Drawing.Image.FromFile();
System.Drawing.Image image = System.Drawing.Image.FromStream();
image.Save("a.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
image.Save("a.gif", System.Drawing.Imaging.ImageFormat.Gif);
*/
|
|
|
|
|
Thanks, but I am a bit confused with the code. Which is the source file, and which is the destination file?
|
|
|
|
|
Two ways
1) you get the stream from Memory, by BinaryRead a little complex
2) you save the file to your hard disk first, then
get local file path and save as aonther file,
simple but unefficient.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
