Selectionformula
-
Dear all I had installed new visual studio.net 2005 into my PC and I have tried to open my old program which was I made under visual studio.net 2003, everything was running well until I tried to run my report form which was connected to my report form made under crystal report sheet. I couldn't run selectionformula, to present all my data from my database to my report sheet as I wanted. Here is I treid to give you a small part of my program I have a textbox1 in my form which is I will use as my parameter to order crystalreport to present data as I need base on the contains of that textbox1. and the list of my program are : If textbox1.text="ALL" then crinv.SelectionFormula= "" crinv.RefreshReport() Else crinv.SelectionFormula="{inventory.invcod)='" & Me.textbox1.Text & "'" crinv.RefreshReport() Endif I can get all data from my data base if I type "ALL" into Textbox and I can get the data base on inventroy code which I typed on textbox1 as well when I still use Visual studio 2003, but now I could not get any data with the same command under visual studio 2005. My question is Could you please to give me information how to use the right SelectionFormula command in Visual studio.Net 2005, that I can present all information from my database ? I do hope you will understand what I mean with my poor english. Thank you for your attention Best regards ICE
-
Dear all I had installed new visual studio.net 2005 into my PC and I have tried to open my old program which was I made under visual studio.net 2003, everything was running well until I tried to run my report form which was connected to my report form made under crystal report sheet. I couldn't run selectionformula, to present all my data from my database to my report sheet as I wanted. Here is I treid to give you a small part of my program I have a textbox1 in my form which is I will use as my parameter to order crystalreport to present data as I need base on the contains of that textbox1. and the list of my program are : If textbox1.text="ALL" then crinv.SelectionFormula= "" crinv.RefreshReport() Else crinv.SelectionFormula="{inventory.invcod)='" & Me.textbox1.Text & "'" crinv.RefreshReport() Endif I can get all data from my data base if I type "ALL" into Textbox and I can get the data base on inventroy code which I typed on textbox1 as well when I still use Visual studio 2003, but now I could not get any data with the same command under visual studio 2005. My question is Could you please to give me information how to use the right SelectionFormula command in Visual studio.Net 2005, that I can present all information from my database ? I do hope you will understand what I mean with my poor english. Thank you for your attention Best regards ICE
Swiss Mantoro wrote:
crinv.SelectionFormula="{inventory.invcod**)**='" & Me.textbox1.Text & "'"
I noticed that your string doesn't end with a curly bracket "}". Perhaps that's why it fails? :)
-
Swiss Mantoro wrote:
crinv.SelectionFormula="{inventory.invcod**)**='" & Me.textbox1.Text & "'"
I noticed that your string doesn't end with a curly bracket "}". Perhaps that's why it fails? :)
Thank you for your reply but actually I used the curly bracket in my real program, but for this line program was not problem, I just concern to program line which tell, crinv.selectionFormula="". In my previous visual studio.net version whole those program was running well, but I have no Idea why it doesn't running in version of 2005. Thank you ICE
-
Thank you for your reply but actually I used the curly bracket in my real program, but for this line program was not problem, I just concern to program line which tell, crinv.selectionFormula="". In my previous visual studio.net version whole those program was running well, but I have no Idea why it doesn't running in version of 2005. Thank you ICE
Perhaps this is an issue that you need to raise with the makers of Crystal Reports, at www.businessobjects.com. I just quickly ran through there website and found a PDF talking about a couple issues with SelectionFormula on WebForms. Didn't look related to your issue, but it confirms that there are known bugs. http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Release_Notes.pdf[^]