Search results for query: *

Hi all, I want to know about how much license has been purchased by the company for sqlserver thru some sql or stored proc. Because , we are having ERP system in which we want to restrict the no. of concurrent user license like sql server does. Urgent Thanks & regards Buhari

I am thankful to both of u. I will try both the way. Regards, Buh

Hi, We are having lot of sql server stored procedures to be installed at client sites. Each time we will open each procedure and execute it thru query analyser.I consumes lot of implementation time. Now, we don't want to do this. Instead, we want to have one stored procedure or sql statement...

Hi Friends, Basically I am a PB Programmer. We have developed an Accounting Package which is currently running on Sql Server 7.0. One of our client wants to use our Package with Oracle as Database. So, we plan to convert from Sql Server to Oracle. But the problem is, We have used Stored...

Hi all, This is not crystal report quest. In our invoice printing program, I am printing more than one invoice by giving the range of invoice nos. Each and every invoice has more than one page I need to print the total at the last page of each invoice.How will i achieve this? Because of...

I am having column which contains status as "Quoted", "Job Awarded","Enquiry" and atlast i am showing the totals for all the status like Total Quoted : Total Awarded : and also the status is passed as a parameter.If the user select "Quoted", then it will...

I am a having a multi value parameter with 8 column of a physical table. when the user select multiple column, he allowed to give search condition for each column, i am having 8 individual parameter for the search field.He can randomly select the column, he will enter the search condition.If i...

No, I can't use stored procedures, views etc. Ony tables are possible. My front-end is like that.It supports only tables.If i use stored procedures or views, it doesn't allows me to view the report and also i am using CR 8.5. Any other idea. Verry Urgent, Buhari

Awithers, I am able to convert it to a string using cast function in the select statement of the report. but in the formula editor, that column is not appearing. when i manually enter, it shows "Blob or memo field cannot be used in the formula". Very urgent

I want to create a formula which will extract a string from a blob or memo field.Only tables I can use in the report. No stored procedures, No Views allowed to split the Blob or Memo field. Because my Front End tool supports only tables. Verry Urgent. Early Reply Solicited. Regards, Buhari

Ngolem Now it is ok

Is it possible to extract a substring from a blob or memo field and assign it to a formula (Or) Is it possible to access the memo field or blob field in the CR Please help me in this subject. Very Urent Regards, Buh

Hi all, How can i extract only the numbers from the string. Is there any function? Early reply solicited, Regards, Buh

Report is in Table Format (with Lines) My Totals are in the Report Footer.So it will print only at last page (as u already know).The problem is, if the totals goes to a new page without any detail record, then the totals are coming correctly, but all the lines extended upto the end of the page...

I want to populate a parameter depending on other parameter. How can I do this. Ex. I am having column names in one parameter. If i select one of the column from the list box, i need to populate the column values to another Parameter as a list. How can i do this. Please help me in this...

I am having a table which contains two columns as "Status" and "Amount". Status may be Completed or Pending and the corresponding Amount.At the end of the report, i.e. in the Report Footer, i want to show the total amount for Pending Status and the total amount for Completed...

Hi guys, How to read server's hard disk serial no. from the client m/c. Very Urgent Buhari

Thanks. I will try that

The main report is having the same table as Pending Subreport.Because I can only get user either from the Pending table or Completed table.

Hi all, I am having report which show all the pending activities and completed activities for a particular user Pending activities means from taking from Pending table. Completed activities means from taking from Completed table. We are not maintaining the status for Pending or Status. I have...