Fixed it...
Just saved the subreports as separate files.
removed the malfunctioning subreports.
readded them in...
and voila. presto chango
It works.
Stupid crystal.
I have a report which will not completely export to a crystal report file when using the RDC.
There are a total of 6 subreports all of which use the same SQL-ODBC File DSN. They all are stored procedures.
The code goes something like this...
'Set logon for main report
For I = 1 To...
Found a workaround...
Turning Enableparamaterprompt = False would default
all to a null value. Therefore you don't have to worry about setting a value to each one, only those that need them.
I have many reports which use subreports. These reports are based off of stored procedures (requiring parameters).
I pass certain values the the different subreports so they should have a value attached to them. When you run the report in Crystal, it only prompts me for the parameters which...
Read this article...
http://support.crystaldecisions.com/library/kbase/articles/c2007359.asp
I've come across this issue before finding this article.
It's been awhile but I thought that turning on the property
"Keep Together" for the groups was a work around for the problem.
That would depend on your font size and type.
Crystal uses windows fonts so there can be no set
number of characters.
You'll have to try yourself to figure it out.
Use a fixed font like Courier and start typing.
Pass in a parameter to the report
name it something like "Format Type"
then under the sections use want to display
based on the selection : go to Format Section:
and under the suppress (No Drill-Down) click the
formula button and put something like this in...
If {?Format Type} =...
I run this query in the MDXSample application...
I use to date range sets and crossjoin to get them back in the result.
WITH
SET ["2001"] As ' {[Date].[2001].[Quarter 1].[January].[1]:[date].[2001].[Quarter 4].[December].[31]}'
member [Date].["2001"]
as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.