Search results for query: *

It is a varchar but I figured it out I was about to post: SUBSTRING(columnname, 1, PATINDEX('%.%',columnname))

I am SQL Server 2008 I can't figure out how to trim my characters after a decimal has occured. For example I have 123.56 and I just want 123. Then problem is the strings are not always the same length, because I wanted to just use substring but I am not sure how to write where to make the...

I have a dynamic prompt in my crystal report that is failing to display data. So I went into the Business Objects Business View Manager to see how the prompt was refreshed. The last scheduled instance failed because it failed to open rowset. So I tried to schedule it on demand and got the...

I am using Visual Studio and I am trying to open a VB File from a USB and the file will not show up in the solution explorer.. I am new to visual studio so any help would be appreciated!

I am using crystal 2008 and I know that I crystal does not allow me to group on data that is not there, but I need to get around this. I am trying to get a total of the amount of trips requested per hour and if there are not any trips made during an hour I want a zero. After I get through...

I am building a universe and trying to get a count of all my parnet records, but I am getting duplicate parnets because they have children. So I tried doing distinct but because the children are different for the same parnet it thinks that it is counting distinct records. If anyone has something...

This is my SQL thank you for the help: SELECT "CLARITY_LOC"."LOC_NAME", "PATIENT_MOTHER"."PAT_NAME", "PATIENT_MOTHER"."PAT_MRN_ID", "DM_OB_BABY_INFORMATION"."BIRTHTIME", "DM_OB_BABY_INFORMATION"."DELIVERYMETHOD", "CLARITY_LOC"."LOC_ID", "DM_OB_MOTHER_INFORMATION"."FORCEPS"...

I put the code at the top into the selection criteria in Crystal and it still does not give me the correct results. When I put the code into sql with the same joins and everything as in crystal I get the correct answer. If anyone has any more suggestions please let me know! Thank you

I am using Crystal 2008 and Oracle, I am having trouble with my record selection criteria. The formula I am using is below, basically I want the report to show records that say yes in any of these fields expect for these two (({DM_OB_MOTHER_INFORMATION.PRBC} = 1) or...

I am using Crystal Reports 2008 and I was wondering if there was a way to make crystal change the SQL syntax that it uses to join tables. Basically I want crystal to do a natural join instead of an inner join. Thanks!

I am using Crystal Reports 11 Release 2 I want order lines 10, 11 ,12 to be exculded form the report when the sales order 11059 comes up I wasn't sure if anyone could help me. Thanks

I am using Crystal Reports 11 release 2 I am tryin to pass a running total from my subreport into my main report and I cannot figure out what I am doing wrong. In the subreport the running total is in the Group Footer 2a and the shared variable is in Group footer 2b the formula looks like...

Thank you soooo much that works!!

This is what I tried: In the group header of the subreport I put these two formulas: //@Suppress whileprintingrecords; booleanvar flag := true; and a shared variable to carry it to the main report: //@SharedSuppress Shared BooleanVar Suppress; Suppress := {@suppress}; In the main report...

The group Header is blank because I subreport is there and when it is blank I wanted the whole section to be suppressed. I did go to the boolean variable, but I do not know how to reset the formula for subsequent grpfooters. If you could tell me how to do that I would really appreciate it!

I am using crystal 11 release 2 I want to supress Group Footer 2b in my report when Group Header 2b is supressed in my report. Group Header 2b is set to to be suppressed when section is blank. If anyone could help be I would appreciate it!!

Thanks! I got it!

I am using Crystal Reports 11 Release 2 I want to suppress my group 2 footer when the subreport that is in that seciton gets suppressed. What should my formula look like and where should I put it? Thanks!

Actually is their anyway to link the second subreport and the third subreport to each other within the main report..or is that still nesting? Because I have these accounts and they have "parnets" then those parnets are apart of a larger group and so forth and I want to see the layout of that...

Thanks for the Help