Problem with Subreport

[campbere]

I have a report that has 4 subreports. I can get it to run on my machine but not on any other users. After picking it apart I learned that if I removed all the subreports it runs on their machine. I am thinking that this is a missing DLL file or another supporting file.

Anyone know what files are necessary to run Subreports?

I am on Windows 2000 and Crystal Reports 8.5.

Thanks

 

[dgillz]

Are the subreports using the same datasource as the main report? When you say you cannot get it to run, what error messages, if any, are you getting? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[campbere]

They all use the same datasource. I am getting an error which I started to investigate but it didnt seem to fit because I could not find anything wrong with the formula. In addition to that what bothered me was I could run this report just fine on my machine.

The error I got was

Report Error: 20515 Error in File SummmaryInv.rpt: Error in Formula <StartInv>. 'if instr({Query.ID}), '-') = 0 then The string in non-numeric.IM006 [Microsoft][ODBC Driver Manager ]Drivers's SQL SetConnectAttr failed 0

What I ended up doing was stripping the graphs and subreports from the report and running it on the user's machine it worked. I put the graph back in and it worked. I then inserted the first subreport it failed. I then stripped the graph from the subreport and it failed. I then stripped every formula fromt the subreport and it still failed. After stripping practically everything from the subreport and it still not running that seems to indicate I am having running subreports on the users machine.

Thanks for any help that you can provide.

 

[Ngolem]

if instr({Query.ID}), '-') = 0 then

this formula has an error in it...you have an extra bracket
unless this is just a typo on your part....paste the complete formula for us to look at

Should be: if instr({Query.ID}, '-') = 0 then

Jim

JimBroadbent@Hotmail.com

 

[campbere]

That was a typo. The complete formulat reads:

if Instr({Query.ID}, '-') = 0 then
tonumber({Query.ID})
else
tonumber(mid({Query.ID}, 1, instr({Query.ID}, '-') - 1))

Sorry about that.

 

[Ngolem]

the error you are getting implies that the string is not a number

This could be for 2 reasons I can think

1. you are encountering NULLS in your data.

2. the data has other non numeric characters other than a &quot;-&quot;

You should check out the database on this site Jim

JimBroadbent@Hotmail.com