Has anyone used Crystal reports with online Microsoft Dynamics 365 ?
Using a 3rd party ODBC connector and tried a different connection through reportbuilder and get the same message
DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad...
found a 3rd party ODBC connection so I can connect Crystal reports to Dynamics 365. Since new the 365 tables are small so I did a quick report of 1 table to view the all data. Worked once but then the key id field was blank. contacted support and both blame the other. However the ODBC...
HI,
Have always used a local server and kept our accounting software in house . Trying to find something so I can connect Crystal reports to access the data from Microsoft Business Central 365 online
I have experimented with PowerBI and it will connect. Would think Crystal would have...
Have an older version of Backup exc 9? and need to pack up 2003 server. I have another 2003 server that has no issue but the other cannot seem to find the tape drive. Checked on the web and concluded I need the driver for the HP 448. But since both tape drive and server are obsolete and...
I print a lot of shipping labels for Amazon. Never had an issue until this month. Previously when I selected the label printer it would automatically adjust to the proper print size. Now it stays on 11 by 8.5 and will not let me change it. I have an older PC with windows 7 and the using the same...
I have the latest version and backup via a usb passport. It works well except when I switch to another passport my jobs get updated to include backing up a new drive ( the new passport). When it backs up it goes in a continued loop backing up 200 gigs or more of data instead of the actual 25.
I...
Hi,
I have others users run reports using Crystal Active X for viewing reports. Seems the latest update from Microsoft has stopped Active X from running. The report pulls up a blank page. Is there a newer version. All machines are 32 bit. With the previous updates I was able to add the report...
I have a Crystal report that prints Bill of ladings (BOL) from our accounting system. I can only print 7 items on the BOL. So after 7 lines, I force it to start a new page. Works perfectly for less than 7 lines and 8 or more. However when there is exactly 7 lines it prints a blank second page...
Trying to import data from an Excel file that has many Order headers and Order lines. I need to convert it into a fixed length text file so I can import the information into our accounting system. Unfortunately the import is fixed width and dependent on the column position. I have it working...
I have a windows server 2003 that runs Trend Micro SMB. Recently I upgraded from 3.5 to 3.6 to accomadate a few Vista computers on my network.
I have the web console set up for anonymous login but it requests the admin and password. It didn't do this for 3.5
Trend will force updates to the...
I have a HP 350ml running windows 2003. One of the drives went bad under warranty and I contacted HP. Before they would send me another drive they required me to update to the latest firmware.
So I did that and ran their diagnostics only to find out I have a bad drive.
Replaced the drive and...
More of a curious question.
If you're creating formulas for example, sometimes you have a choice of selecting existing report fields or going back to the table to get the data.
When you have this choice, What would be the best programming practice to use?
I have a field I am trying to post a summary.
I have it reset to 0 in the groupheader1 Customer name
Group footer 2 has the formula
also have my calculation for openamt
whileprintingrecords
numbervar totalopenamt
totalopenamt := totalopenamt + openamt
in groupfooter 1 I have...
Currently using Crystal 9 and want to connect to an old database from Q&A. Can't find the right DLL I need to download. database file extention is DTF
get the error No database DLL has been specified.
I am using CR 9 and a sql 2000 database.
I have tried all join types, reversed links but still get the same number of records. There are rows in axapataoraclelines that do not have a corresponding row in inventtable. If I use Crystal SQl designer - I get all the rows
The query by CR9
SELECT...
I want to develope a report that looks like this
Sales as of "aug 15, 2004" -
cust# daily sales MTD sales YTD sales lastyear sales
a1 1.00 2.00 4.00 10.00
a2 4.00 5.00 15.00
a3 1.00...
In a sql database table there is a column called address.
However if you have more than one line on the address, it's separated by a carriage return within the same column.
when I view the field within the applications I can see the entire address.
In Crystal I only see the first line.
How...
I can connect to my Oracle 7.3.4 database in CR 9 but no tables appear.
Currently using Oracle own ODBC and it works, but can not get the left outer join to work.
It was suggested I use the CR driver. If I use Admin32 I can connect and see the tables but get an warning message that I need to...
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.