Search results for query: *

Hi, This sounds like a strange question, but is there any function (or any other way) of passing a string in and getting out the field with the same name in a query? Something like this (SalesTotals is a column in tblSalesTotal) : SELECT someFunction ('SalesTotals') from...

Hi All... I'm trying to calculate a dynamic period by using a value from a table to determine the period used. i.e. in some cases I'd like to compare the dates in days and other cases in years, months etc... DECLARE @DatePart varchar(50) SELECT @DatePart = [DatePart] FROM tblDateParts SELECT...

Sorry for the strange title, but I don't know how else to describe what I'm trying to achieve. Imagine a table tblTable (all three columns are integers) : ID Int1 Int2 1 10101 100 1 10102 25 1 10102 50 2 10013 65 I want a simpler way of finding the maximum...

Hi, We are looking at making a basic BO universe to test it's performance and usefulness against our currect solution (SQL Server stored procedures). We are keeping the SQL Server - and currently the SPs references tables and includes the "with(nolock)" hint. Is there a way to force queries...

Hi, We are looking at making a basic BO universe to test it's performance and usefulness against our currect solution (SQL Server stored procedures). We are keeping the SQL Server - and currently the SPs references tables and includes the "with(nolock)" hint. Is there a way to force queries...

Hi, I have a copy of Business Objects Enterprise XI Release 2. In the Infoview the button at the top called 'My InfoView' is greyed out (inaccessible). When I go into preferences - the option to set My Infoview as the initial view is also greyed out. Why might this be? I need to give my...

Guys, I have a stored procedure along the following lines : Create Procedure ProcedureName AS Create Table yyy ( IDField int, Field1 varchar(50), Field2 varchar(50), Field3 varchar(50), Fieldx... etc... ) Insert into Table yyy (IDField) SELECT ID from tblPPP where...

Hiya all! I've looked into similar jobs to the one I'm currently doing and noticed I'm being paid 50% less than the average for my area (jobwise and locationwise). Several attempts to have my pay increased with my boss has gone unactioned by higher management. I have a meeting with my boss -...

Hi, I can modify the 'inline' code within an InfoView and see the changes reflected in Internet Explorer. However, if I change the code in the 'codebehind' file (a *.aspx.cs file) - the changes are not reflected. I understand this is because the .cs file is compiled into the 'project'...

Hi all, RE: Crystal Reports XI and BOXI We have lots of reports which have a data source of an SQL Server Stored procedure. We are moving into using Business Views to read the Stored procedure data - and then add filters to the data (like row level security) to allow certain users to have...

Hi, Let's pretend I have a table like this : ID Sequence Status 1 1 Y 1 2 Y 1 3 N 2 1 N etc... I want a single query to return the latest status. For example for ID=1 this would be N. At the moment...

Guys (CE10), I'm having a look through the Event Viewer (Application Log), and there are many error entries in there in this form : "The schedule result provided by the Job Server for the object identified by 868088 is invalid." The number, in this case 868008 can be other numbers too. This...

I am designing a report in CR10, using a Business View from CE10. It has several SQL Expressions in the business view – which I created in the Foundation. The SQL Expressions are similar, like this : CASE WHEN "Table1"."Price">0 THEN ("Table2"."Total"/"Table1"."Price")*100 else 0 END...

I am designing a report in CR10, using a Business View from CE10. It has several SQL Expressions in the business view – which I created in the Foundation. The SQL Expressions are similar, like this : CASE WHEN "Table1"."Price">0 THEN ("Table2"."Total"/"Table1"."Price")*100 else 0 END...

All, I have a copy of Enterprise XI. We like it! However, I have a problem trying to customize the pages within the InfoView (XI's version of ePortfolio). Each aspx page references it's equivilent aspx.cs page, with the coding in it. However, changing the cs text does not change the...

Hi all, I have created a new group and a new user on CE10. I have assigned this user to the group. I have a new report, in a new folder. I am now trying to modify the Advanced Rights for the group over the report - with the intention of only allowing the user to see instances in the history...

Hi guys, I have created some icon files (256 color). They look great. I'm using the notifyIcon to put these icons into the system tray thus : System.Drawing.Icon ico = new System.Drawing.Icon("checking.ico"); sysTray.Icon = ico; However, when the icon is in the system tray, it looks like...

Hi all (CE9), I want to query the InfoStore and require the result to be ordered by SI_NAME. However, I only want it to take into account the 2nd character in the name. This query : SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS ORDER BY SI_NAME Returns something like the following : SI_ID...

Hi ppl, I need to capture the event when a user resizes a column in a listview control... Any ideas? Thanks! Rob Stay Blue, Bob. x

Hi ppl, I use the following type of WHERE statement all the time : WHERE SI_PROGID='CrystalEnterprise.Report' Is there a SI_PROGID which defines users instead of reports!?!?!? Thanks! Stay Blue, Bob. x