While I was not able to set up the odbc yet, loading the client got me the drivers I needed to create the aliases I needed to connect directly with Crystal Reports DB2 connector. Thanks for the tip, mikrom.
Hi All,
I'm sure this one's been beat into the ground, but I can't find a good answer. I'll start this off by saying I'm a Business Objects and Crystal developer. I'm not good with databases and I know nothing of Unix or Linux.
I've got Business Objects on a Windows 7 machine.
I've got a db2...
Hi,
I did an upgrade on a VB project from Crystal 9 to XI. The new viewer shows up, but the parameter interface or GUI or whatever is the same one from Crystal 9. The whole point of this was to get the new interface. I attached a screenshot of the difference in the windows.
So, anyone know...
Thanks for your responses.
A third party viewer is not an option in this environment.
I finally got VB to accept the Crystal XI viewer outside of Administrator mode by running it in XP compatibility mode.
It turns out the CRViewer91 was just the name on the Viewer Object. I replaced the...
Hi,
Start this by saying I'm a Crystal Reports developer, not VB.
I've got an application that already uses Crystal 9. There's about 20 instances in the code where CRViewer91 is used. I need to upgrade this all to Crystal XI R2. So far, the problems I'm having...
I don't know what to...
Hi,
Start this by saying I'm a Crystal Reports developer, not VB.
I've got an application that already uses Crystal 9. There's about 20 instances in the code where CRViewer91 is used. I need to upgrade this all to Crystal XI R2. So far, the problems I'm having...
I don't know what to...
Hi,
I'm trying to do a comparison across a year in a crosstab and graph. I want compare the each business day by first business day of the month... second business day of the month... etc. I know how to do this with variables, but I can't get that to graph. Does anyone have a formula for...
Either I'm using it wrong, which is very possible, or this isn't working for my needs. I'm pulling multiple records based on the selection in the combo. I still can't get past the compile error.
I've got a crosstab query that's being displayed in a form. I need it to display data only for certain managers based on a combo box. Here's the code:
Private Sub cmbMSCManagerDisplay_Click()
Me.MSC_CrosstabAPI.Form.Filter = "Managers.ID=" & "" & ""
Me.MSC_CrosstabAPI.Form.FilterOn = True...
Can anybody point me towards some step by step instructions for this? I just want people to view or access a Crystal Report from an Access 2007 form. I can find the controls, but I don't know which one to use and and I can't find the place to link the report.
Has anyone used Crystal 9 connected to ServiceCEO? I'm used to using 11 and 2008. I just want to know how to set up a report so the Print Range connects to the parameters like all the other reports.
I got it figured out. It needed to be told to take the minimum of In, Out, Last, Aged at the group level to do the Distinct Count.
Minimum({sr.Age},sr.InvoiceNum)
Then the distinct counts needed to be done off that.
Invoice is Group 2 because because I'm using an Audit trail, so the Invoice number comes up many times. This makes the final counted age based on the earliest change to the Invoice.
There are no formulas for the groupings, except Age, and that's just Changed Date - Created Date.
I'm using the...
I've got a report with 3 groups. Department, Invoice Number, and Age of Invoice.
Nothing is hidden or suppressed.
The Invoice Number (based on Age) can be In, Last, Out, or Aged.
I have a charts in the Report Header and Group Headers telling me a Distinct Count of Invoice Numbers in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.