Hey guys
This is my first time ever using msdn for support and why not right, using Microsoft product, makes sense to get support from fellow users and pros.
So here is my dilema, I'm more of a C and C++ guy but only know the basics of that (only 1 year into my 4 year degree program at college) but at work I was asked to create a report which connects to and Access 97 database (dont ask, I have no control over this its a government standard thing) and pulls data I need. So we ordered Crystal Reports XI and I had no clue on how to use the program.
But with some playing around I eventually got a good, buggy, but good report done and my boss is pleased. Well she wants one more thing, since she and many of our fellow employees have no clue on how to use Crystal Reports to retreive the data they need, she has asked me to create a front end so all she has to input is the start date and end date and it goes into the report replaces the start and end date and pulls the data.
I'm running Visual Studio 2003 .net, I've loaded the CrystalReportsViewer and have actually displayed the report in my vb program but I need user input in regards to inputing of dates which goes and querys the Access 97 db we have setup.
Hope someone can point me in the right direction on getting this done. I learnt a bit of vb coding in high school (4-5 years ago) and that was it, since then its only been C and C++.
Thanks guys, hope to get a positive turn out on this topic.
Need help...noob
IT Lackey
SK9
So now the final thing (if i may say that lol) I need to be able to select a start date, and an end date using visual basics datetimepicker (ive got 2 set up called startdate and enddate) and i need to use them in the selection formula so it selects a range.
When I swap #2006/01/01# with StartDate I get a string cannot be converted to long, when I do StartDate.Text it compiles but crashes when I hit the Display button.
How would I go about doing this
Dalaware
I need to finish this ASAP guys. Please
Thanks
Avi Cohen
You should refer to the Crystal XI api available on the BusinessObjects web site:
http://support.businessobjects.com/global/interactive/xi/om/default.html ref=devzone_main_objectmodel
You can accomplish what you're looking to do by assigning values to CrystalDecisions::Shared::ParameterValues which will allow you to pass parameters collected from your app into the Crystal Report.Beyond that, I suggest you RTFM!
sushi1869
Thanks for the information. I have gotten most of it down. I just cant get the connection between data selection in my program to send the range to my crystal report.
This is the code im using:
[code]
Private Sub redisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles redisplay.Click
myCrystalReportViewer.SelectionFormula = "{Client.Entry}>#2006/01/01#"
myCrystalReportViewer.RefreshReport()
End Sub
[/code]
I'm using it to test it to see if it actually can filter the dates, but thats not even working. Eventually I need it to select a range of dates (first of the month to the end) and filter it like that.
Thanks
mbarbiero
You need to reference the value parameter of the datepicker not the text parameter. StartDate.Value will return a datetime value.
P