Search results for query: *

So we are using CRS2008 and trying to achieve row level security along with the values that show up in the parameter list and facing a chicken and egg situation. So created a blank report and made formula for CurrentCEUserName and then made subreport which has a proc which takes in value to...

So we are using CRS2008. I created a normal user TestUser and made it a member of group TestGroup. Next i created a folder called TestFolder. Now let me put in the rights for Folders. At top level for All Folders security Administrators - Full Control Everyone - Just Granular Rights no...

So we have installed sql server 2008 on microsoft server 2008 web edition with 32GB memory. the funny thing is that when i run jobs the memory keeps increasing and then it stops at 99% and stays there even though there are no jobs running on it. shouldn't it normally come back to 10-15%. my...

hi, i have installed sql server 2008 and i was told it is utf-8 compliant but when i installed it and went to create a new database and looked at the collation options i could not see utf-8. How does one do it or what is the collation option which does the same as utf-8 unicode compliance at...

Thanks, But this is the same problem with CR 2008 . It is wierd on CR's part to give this feature for cross-tab but not charts where you would think the underlying logic is same.

I am using Crystal Reports 2008. So i have date and counts chart with dates on the x axis and counts on the y axis. so the dates are mm/dd/yyyy format 1/10/2008,1/12/2008,1/1/2009,1/11/2008 So now in the chart i want to show it as Oct-2008,Nov-2008,Dec-2008 and Jan-2009 as display which is...

does mysql support cursors with arguments and if so what's the syantax. I have been using oracle and sql server forever and never encountered this issue.

hi i am using CE10 and when i preview a report it shows it in the java viewer and then when i hit the export button it shows all the export options and then i select and option and i give it the file path and hit OK nothing happens and no file is created. Any solutions or settings i need to check?

hi, i am using crystal reports 11 and was wondering if anybody has been able to format a chart ( i am using stacked chart) where you could use 2 on change and 2 show values so that we would have a subgroup count withing the group count. When i do this on stacked chart it gives error. So is...

I have a 5 concurrent user license version of CRS XI. Now i am using URL reporting syntax to render reports using http://<server>/businessobjects/viewrpt.cwr?ID=7480&cmsname=<CMS>&apsuser=<user>&apspassword=<pwd>&apsauthtype=secenterprise Now i am using a fixed user for this report. So...

hi, i wanted to know if we could create a procedure and write code for another procedure or functions inside and use it locally. So basically i wanted to know if the sql server stroed procedure can behave like an oracle package?

i opened this csv in texpad and in the document properties it said code set ANSI and file type UNIX so i saved it as file format PC and encoding ANSI and imported and it imported fine now i have to check the data.

hi, i have a CSV which has file type ANSI and {LF} as row delimiter and double quote(") as text delimiter and comma(,) as column delimiter. when i try to import using text file drive it fails after importing records for a while for weird reason saying Error at source for row number 74555...

I know this can be done using simple update but i was trying to write an update cursor and even though this table has just 40 records it is taking forever to update so i thought there is syntax issue. Meanwhile the real issue is with this cursor where while executing i get Server: Msg 16957...

Here i have written simple update cusror for experiment and it is taking forever DECLARE c1 CURSOR for select scnt from support_date_exception FOR UPDATE OF scnt OPEN c1 FETCH NEXT FROM c1 WHILE @@FETCH_STATUS = 0 BEGIN UPDATE support_date_exception set scnt=null WHERE CURRENT OF c1 END...

I have a report where i need to use the parameter value of the main report as a conditional filtering criteria for the subreport. To achieve that i created a shared variable on the main report and created a formula in the subreport to get the shared variable. Now when i am using that formula for...

I am running a sql in toad select (to_date('01/JAN/1970')+(1122568480/86400)) from dual to get normal date when there is epoch date stored which is the number of seconds since 1,1,1970 andit runs fine there. But when i try to run this same sql in crystal reports using native connection...

Thanks for the reply. I also got a similar solution which is select to_date('01/JAN/1970')+numtodsinterval(1122568480,'second') from dual where the second can be changed to minute or hour as needed dependant on the data stored.

I have a number column which has value in the form of number of seconds since 1 jan 1970. Please suggest a select and not a fnction which would allow me to use dateadd or similar function to get a date out of the number field. Eg. the value in the number column representing the no. of seconds...

Inside a stored procedure i am calling another stored procedure using exec and that stored procedure creates a temp table. But when i try to access that temp table from the main procedure it says invalid object. Is there any way to access that temp table. Or what would be the alternative method.