Search results for query: *

Does anyone have a SQL query to select the price for a particular item and customer from the Great Plains extended pricing module?

http://www.asp101.com/articles/john/indexserver/part2.asp

If you didn't associate the catalog with a WWW Server instance (from wihtin the catalog configuration screen), the vpath property always comes back blank.

I am using Great Plains 7.5 SP2, and have modified one of the Service Advantage reports and added VBA code. I exported my customizations to a package file, and am able to successfully import this package on my machine. But when I try to import the package onto a user's machine it says: Name...

I ended up following the instructions in the article and they worked perfectly. I didn't have to detatch/attach anything since I shut the SQL services down before copying the mdf/ldf files, and I didn't have to restore any backups. All of my logins, jobs, linked servers, and DTS packages came...

I have a few hours of downtime. I was hoping to move all of the objects (databases, logins, jobs, DTS) over in one fell swoop rather than individually, which is why I was interested in the method described in that article.

I want to move a SQL 2000 Server completely (all data jobs, DTS packages, logins) from one W2K SP4 machine to another, then rename the new server as the old server. I have read related posts on this site and found the following article that describes how to do this...

TechKnowledge articles 850774 and 857426 describe how to create a script.log file that contains a list of all the procedures and functions called. I was able to do this in Great Plains 7.5 but it doesn't seem to work in 8.0 (I don't have a Debug menu option). Does anyone know how to do this in...

We recently upgraded from Great Plains 7.5 to 8.0. I installed Integration Manager 8.0 onto a workstation, then (per TK 856226) copied our existing 7.5 IM.mdb file to the workstation. We are able to login to IM 8.0 and we see our integrations, but they all say version 7.5 beside them. They...

We are using Great Plains 8.0. I recently customized the SOP Blank History Invoice Form report, but deleted the "Page No." field from it. How do I add this field back to my report? I see a "Page Number" field listed under the globals section, but when I add this to my report it prints a 0 on...

I am experiencing a similar issue and am interested in an add-on or workaround. Does Crystal XI support <table> tags?

Thanks Turkbear! That did the trick!

I have a parameter {?Field} that is set to allow multiple values. I have a formula {@strField} that joins the parameter values (array) into a comma-delimited string with # characters surrounding each value (eg. #value1#,#value2#) @strField: "#" & join({?Field},"#,#") & "#" My record selection...

How do you list parent/child items on an ASP.NET page, grouped by the parent? For example, my data looks like this: Category Item -------- ------- Cat 1 Item 1 Cat 1 Item 2 Cat 1 Item 3 Cat 2 Item 4 Cat 2 Item 5 I need to display it on my ASP.NET page...

Bless you synapsevampire!!! You are my savior! That worked perfectly!

If I insert a summary then it will display a count/sum of the items, like this? Category Column 1 Column 2 Column 3 ------------------------------------------------------- Cat #1 3 2 3 I need to display each of the item values on the report, like this...

My report contains the following fields: {Category} {Column} {Item} The data looks similar to this: Category Column Item -------- ------- -------- Cat 1 1 a Cat 1 1 b Cat 1 1 c Cat 1 2 d Cat 1 2 e Cat 1 3...

I am running CR 8.5, and have created a manual cross tab report that groups by category, and lists items under the columns that I have designated (I created a formula for each column). It works great, only the items are not formatted/spaced the way I need them to be. They are currently...

The text in the database field does not contain any font tags. Unfortunately, I appear to be very limited on what I can do via a SQL expression since this is a text field. I can't concatenate and I can't replace.

I have a memo field (datatype is "text" in SQL Server database) that I am displaying on a Crystal Report (version 8.5). The field is set to "HTML interpretation". No matter what size I set the font to in Crystal Reports, it is displayed as size 12. Is this the default font size that is used...