Crystal: IF, While-Do loop, or something else…?
Hi, I’m new to Crystal and writing code. I have a simple(?) problem but I am running in circles. We have customers who have ordered in previous financial years and the current year: these are classed as ‘Existing’. Any customer who has not ordered in the previous year (but has an invoice in the current [...]
Answer Question
| February 28, 2012 7:31 PM
Crystal Reports 2008, SAP analytics and reporting
Hi, I’m new to Crystal and writing code. I have a simple(?) problem but I am running in circles. We have customers who have ordered in previous financial years and the current year: these are classed as ‘Existing’. Any customer who has not ordered in the previous year (but has an invoice in the current [...]
Answer Question
| February 28, 2012 7:31 PM
Crystal Reports 2008, SAP analytics and reporting
WKS link to multiple column excel report
I have tried a 1:12 to get the info, and I get only period 1, if i put in just a 12 i get 12, How do i get this to work in the new MR module. It works fine in FRx.
Answer Question
| March 6, 2012 6:55 PM
Dynamics GP, dynamics GP 2010, MR, wks, wks link
I have tried a 1:12 to get the info, and I get only period 1, if i put in just a 12 i get 12, How do i get this to work in the new MR module. It works fine in FRx.
Answer Question
| March 6, 2012 6:55 PM
Dynamics GP, dynamics GP 2010, MR, wks, wks link
service start failed..
when i start the service then an error occurs which is a cross sign is displayed before this message “Registering the service ‘cognos8′ starting the service ‘cognos 8′ this is the error “[Registering Service] 1. [ ERROR ] CFG-ERR-0101 Unable to register Cognos 8 service. Execution of the external process returns an error code value [...]
Answer Question
| March 6, 2012 2:31 PM
Cognos
when i start the service then an error occurs which is a cross sign is displayed before this message “Registering the service ‘cognos8′ starting the service ‘cognos 8′ this is the error “[Registering Service] 1. [ ERROR ] CFG-ERR-0101 Unable to register Cognos 8 service. Execution of the external process returns an error code value [...]
Answer Question
| March 6, 2012 2:31 PM
Cognos
Crystal Reports using SQL to create inner join
I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don’t put any fields on the report from the joined table. ie - if I just use fields [...]
Answer Question
| March 6, 2012 9:47 PM
Crystal Report XI, JOIN, SQL
I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don’t put any fields on the report from the joined table. ie - if I just use fields [...]
Answer Question
| March 6, 2012 9:47 PM
Crystal Report XI, JOIN, SQL
as400
what is the difference between source and object? Does source occupies the memory space?
Answer Question
| March 6, 2012 4:59 AM
AS/400, DB2
what is the difference between source and object? Does source occupies the memory space?
Answer Question
| March 6, 2012 4:59 AM
AS/400, DB2
Print 3d view in AutoCAD
I have AutoCad 2002. When I command hide in a 3d view, the objects behind the faces do not show in the screen, but when I plot in a HP printer, the hiding does not work and all the wire frame is shown as if there were no faces. Please advise. Thanks
Answer Question
| November 9, 2012 8:00 AM
AutoCAD, AutoCAD 2002, AutoCAD Views
I have AutoCad 2002. When I command hide in a 3d view, the objects behind the faces do not show in the screen, but when I plot in a HP printer, the hiding does not work and all the wire frame is shown as if there were no faces. Please advise. Thanks
Answer Question
| November 9, 2012 8:00 AM
AutoCAD, AutoCAD 2002, AutoCAD Views
InfoPath cannot connect to data source
Hi all, I have an InfoPath form in SharePoint 2007 that has dataconnections to SQL server DBs. I have a group of users that have been using them for the past few months with no problem. The permissions on the site have not changed but users can no longer access the Data connections. They get [...]
Answer Question
| November 14, 2011 7:46 PM
Data Connector, Infopath, SharePoint 2007, SharePoint permissions, SQL
Hi all, I have an InfoPath form in SharePoint 2007 that has dataconnections to SQL server DBs. I have a group of users that have been using them for the past few months with no problem. The permissions on the site have not changed but users can no longer access the Data connections. They get [...]
Answer Question
| November 14, 2011 7:46 PM
Data Connector, Infopath, SharePoint 2007, SharePoint permissions, SQL
IT Certification
Hi! I’m new to this forum! Wondering what certifiations everyone has?
Answer Question
| March 7, 2012 4:10 PM
certification, IT certification, IT training, IT training and certifications
Hi! I’m new to this forum! Wondering what certifiations everyone has?
Answer Question
| March 7, 2012 4:10 PM
certification, IT certification, IT training, IT training and certifications
How are Sametime Messages Stored and how to I Export Them?
Hello, I’ve been asked if I can extract Sametime messages and then archive them to a recods management system. How are the messages stored, assuming the customer has opted to save them? If they are stored in an Oracle, MSSQL or MySQL database, I can probaby extract them easily. If they are stored in a [...]
Answer Question
| November 8, 2011 12:13 PM
Export, Instant Messaging, Integration, Lotus Sametime, Sametime
Hello, I’ve been asked if I can extract Sametime messages and then archive them to a recods management system. How are the messages stored, assuming the customer has opted to save them? If they are stored in an Oracle, MSSQL or MySQL database, I can probaby extract them easily. If they are stored in a [...]
Answer Question
| November 8, 2011 12:13 PM
Export, Instant Messaging, Integration, Lotus Sametime, Sametime
Supression of field
is it possible to supress then unsupress based of variables?
Answer Question
| November 4, 2011 2:23 PM
Crystal Report
is it possible to supress then unsupress based of variables?
Answer Question
| November 4, 2011 2:23 PM
Crystal Report
COGNOS server error message
We are getting an error and not sure where to go from here. The COGNOS server appears to come up fine but when we try and start the service we are getting an error. I am looking to the forum for any help to pass on the the person in charge of getting this up. [...]
Answer Question
| November 2, 2011 2:36 PM
Cognos, Servers
We are getting an error and not sure where to go from here. The COGNOS server appears to come up fine but when we try and start the service we are getting an error. I am looking to the forum for any help to pass on the the person in charge of getting this up. [...]
Answer Question
| November 2, 2011 2:36 PM
Cognos, Servers
I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
Answer Question
| November 1, 2011 10:05 AM
DB2
I have a table unload query, which is of length 33, But I need the output file length 80, which means 47 bytes extra..
Answer Question
| November 1, 2011 10:05 AM
DB2
How can a message board moderator find out my personal email address?
I used a message board from my college campus and then later, I received an email to my college email address from a moderator. I do not use that address for anything but school and have never made it public or used it to log in anywhere. Can someone find that out through my IP [...]
Answer Question
| October 28, 2011 7:39 PM
IP address, Networking, privacy, Security
I used a message board from my college campus and then later, I received an email to my college email address from a moderator. I do not use that address for anything but school and have never made it public or used it to log in anywhere. Can someone find that out through my IP [...]
Answer Question
| October 28, 2011 7:39 PM
IP address, Networking, privacy, Security
Components and cables to design/build a network
Hello there, I would like to design-build a network for a small company (about 80 employees). The company is divided in 3 sections which are: designers (30 employees), sales (30 employees) and administrator/marketing (15 employees). Also there are 3 managers and a CEO. What components do I need to build this network (router, switches, hubs) [...]
Answer Question
| February 27, 2012 6:29 PM
Cables, Data transfer, Network, Network design, Routers, Switches
Hello there, I would like to design-build a network for a small company (about 80 employees). The company is divided in 3 sections which are: designers (30 employees), sales (30 employees) and administrator/marketing (15 employees). Also there are 3 managers and a CEO. What components do I need to build this network (router, switches, hubs) [...]
Answer Question
| February 27, 2012 6:29 PM
Cables, Data transfer, Network, Network design, Routers, Switches
DB2 Join Query Error: DECFLOAT
com.ibm.db2.jcc.a.in: Invalid character found in a character string argument of the function “DECFLOAT”.. SQLCODE=-420, SQLSTATE=22018, DRIVER=3.52.95 While executing the join query in DB2 ‘m getting above error, how can i identify or resolve this issue, kindly help on this.
Answer Question
| October 25, 2011 3:40 PM
IBM DB2
com.ibm.db2.jcc.a.in: Invalid character found in a character string argument of the function “DECFLOAT”.. SQLCODE=-420, SQLSTATE=22018, DRIVER=3.52.95 While executing the join query in DB2 ‘m getting above error, how can i identify or resolve this issue, kindly help on this.
Answer Question
| October 25, 2011 3:40 PM
IBM DB2
how to show register with CrystalReport using Access2007
I want to make reports using CristalReport for Visual Studie 2008 and Access 2007 as basetables, and the report not show the register. I did all the step for make a report, but it is imposible to show it. but, it is posible with acces 2003. What I can do for it.
Answer Question
| October 20, 2011 8:31 PM
Access 2007, Crystal Reports, Visual Studio 2008
I want to make reports using CristalReport for Visual Studie 2008 and Access 2007 as basetables, and the report not show the register. I did all the step for make a report, but it is imposible to show it. but, it is posible with acces 2003. What I can do for it.
Answer Question
| October 20, 2011 8:31 PM
Access 2007, Crystal Reports, Visual Studio 2008
Loop is seen on router but line protocol is down
Loop is seen on router but line protocol is down, where could be the issue?
Answer Question
| October 19, 2011 9:37 PM
Data link protocols, LOOP statement, Routers
Loop is seen on router but line protocol is down, where could be the issue?
Answer Question
| October 19, 2011 9:37 PM
Data link protocols, LOOP statement, Routers
Free IT Book: Demystifying the Virtual Desktop
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]
Answer Question
| May 4, 2012 2:23 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]
Answer Question
| May 4, 2012 2:23 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free SQL software with interface to enter data
Hi, I need to enter about 5000 lines of data with about 10 columns. and then i would query the data (by lets say sql, but i am open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view [...]
Answer Question
| October 17, 2011 10:08 PM
Data entry, Free software, Freeware, SQL, SQL Query
Hi, I need to enter about 5000 lines of data with about 10 columns. and then i would query the data (by lets say sql, but i am open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view [...]
Answer Question
| October 17, 2011 10:08 PM
Data entry, Free software, Freeware, SQL, SQL Query
Open IT Forum: What tech CEO would you vote for?
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!
Answer Question
| March 9, 2012 7:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!
Answer Question
| March 9, 2012 7:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
