Search results for query: *

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...

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...

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!!

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!

I am using Crystal Reports 11 Release 2 I am creating a report that will invole about 3 subreports. There will be a main report, call that 1 then a subreport that goes into that called report 2 and then I want a subreport within subreport 2 called report 3. I have that all set up but report 3...

I am using crystal reports 11 release 2. I decided to group by the OrderDtl.OrderDate field. When I did I still have the OrderDtl.OrderDate field in the details section of my report. I noticed that the dates between whats in the detail and what is in the group are about one or two day off and...

I have Crystal Reports 11 Release 2 I have three groups. I want to only the total of the group2 endbalances for my Group One called Assests. I should do a running total but I need this number to be placed in the report footer and it will get messed up by other endbalances in the groups that...

I am using Crystal Reports 11 release 2. I would like to make a heading that says "Gross Sales for "minimum date - maximum date" I have that set up but they way the fields are it gives the time too and I don't want that so it says right now Gross Sales for 1/15/2009 12:00 AM - 6/30/2009 12:00...

I am formatting my report so that the order line, release number and order number can all go together like this 11023/3/45. My formula looks like this: totext({JobProd.OrderNum},0) + " / " + totext({JobProd.OrderLine},0) + " / " + totext({JobProd.OrderRelNum},0) but I am getting this as a...

I am using Crystal Reports 11 release 2 and I would like to put in a running total that will reset at every new page, how should I do this? Thanks for the help!!

I am using crystal reports 11 release 2 and have no idea how to connect to Epicor ERP system. What has been happening is I am using Epicor and I ask it to generate a General Ledger report that is a template that comes with the software. Then Crystal Reports opens up with a general ledger...

I am using Crystal Reports 11 Release 2 and I want to change the section heights manually how can I do this? Thank you!

I am using crystal reports 11 release 2 and I would like to add 2 running totals together. This is what I have: Current Assets 879.96(running total) Other Assets 963.25(running total) Total Assets (879.96+963.25 here!) Current Assets and...