Search results for query: *

Hi, I have a strange question.... I want to generate Crystal Reports (XI), and I want to use only the Crystal part on the BO server, but the rpt file is not on BO. I'm using Vs2005 with c#. The reports are non-embedded. I have the following code: sessionMgr = new...

Hi, I want to create a report with 3 columns with 1 level of header. The detail level is "Across then Down". I want that the header goes on each level detail not just at the the beginning of the group. I'm using CR 9. How can I do that?? Is it possible?? Thanks

Hi, I have a problem... I use CR9 and I want to display the main picture of a project in the details section (with project information). But my images have not the same size. Can I ajust the picture field (in CR) depend of the picture size??? Thanks

I know my fault now.... I don't use "href"... I call a sub on client side to do some operation and redirect to the good page... Don't spend time on that

Hi, I know that we can change color of a visited link by :visited in my CSS. It works well for static link... But, how can I manage visited link if they are dynamic. In my ASP application, I made a picture search and the result show the basic information about the pictures found and a link...

Ok, but my tooltip can be anywhere in page and its size is not static. So, I will try with iFrame. Thanks for your answer

Hi !! My client ask me to create new dynamic tooltips. The problem is that my tooltip appears in front of controls (OK) except comboxbox (NOT OK). For my tooltip, I use a textarea in a <span> and the z-index is set to 200. Here my declarations <SPAN size=""> <div id="tt_Custom"...

I have a field "Status" and I just need to see this field on all page footer

Hi, I'm using CR9 and I have a question for you... Can I take a field of the last record of the report and display this field on all pages footer of the report??? My report give a history summary of the updates on a table. Each record is a change made by the user. I need to display the last...

I'm sorry. You lose your time with that!! With my UNION, SQL Server sorts the two results, so when it sorts "down", it reverses my two "SELECT". I'm sorry, but thanks to take the time to answer me, I appreciate

The problem is if I take the first "SET" (SET @Amount = 9249599.0), my result is... @Amount = 9200000.0 @Result = 9249599.0 It should be the opposite !!! I don't understand

Hi, I have a question for you. I need to round a number. I did this function... It works wells, but sometimes it gave me an error DECLARE @Amount float(53) --SET @Amount = 9249599.0 --'Problem.. why?? SET @Amount = 54249 -- Same thing --SET @Amount = 892499.0 -- Again --SET @Amount =...

I'm wrong since the beginning. The problem was not in my function, but in the transfer between SQL server and Crystal. So for people who wants to avoid cursor and make a fast function. Use this pattern. CREATE FUNCTION dbo.ConcatSourceOfFinancing ( @Opportunity_ID varchar(32) )...

I forget to tell you that the query is in a string and we to the execution of the string I tried a cast for my function but i got a syntx error near of AS. This my call "' +(cast( + '"(dbo.ConcatSourceOfFinancing (SLI_VIEW_FIND_LEADS_WKGRP.Opportunity_ID)) "' + AS varchar(1000))) + '"AS...

I think that I fin the problem... Before, when the data is passing to crystal, the lenght of field was 40. But now, with concatenation, I need a lenght of 1000 (don't take chance!!) How can I change the len of the field in Crystal??? Thanks

for 3700 records it takes 7 seconds directly on server. That's good. But I think that the problem is if I have 3 Sources Of Financing, the transfer to crystal fails because "the rows will be truncated". I still use my function above but i replaced the 400 for 8000 juste to be sure.

It works well directly on server. The data are transfered the server to Crystal reports and after to Excel... The problem can be there

The problem is.... I don't know because it works in a marketing application, so the error message is... "A error as occurs, if problem persist contact administrator" I can't try it in SQL server directly, because I need two much of parameter. This section is only a part of the request. but I...

Hi, I did that: Select * from OppSalesTeam where role = 'Financing' and Opportunity = '123456'; The result is this: ID role name Opportunity 2143 Financing bank 123456 4141 Financing owner 123456 But, I would that...

I tried this and it works well, but it fails if I have too much of records. I'm searching for a means for robust. This is my code.... CREATE FUNCTION dbo.ConcatSourceOfFinancing ( @Opportunity_ID varchar(32) ) RETURNS varchar(400) AS BEGIN...