PDF export

I have a main report with 2 subreports as the only items
in a list control. I am linking the 2 reports to a field
in the dataset of the main report. When I view the
report from the report manager or just from the report
URL it looks fine. When I export to PDF the first page
is blank. The 2nd page and all other pages are fine, but
the data from the first page just isn't there. The data
on the 2nd page is supposed to be the 2nd page so it's
just the first page that is not showing up. Has anyone
else seen this and have an idea of how to correct it?Rick,
I see this same problem with my report. Although with mine I have about 20
pages, but if I re-order those pages moving any other page to the first page
position, that page becomes blank, and the old first page is fine, so no
matter what is on the page, it is always the first one that is blank. I have
posted around on this and have not gotten a working response, I did however
find a MSDN "chat" where microsoft briefly mentioned this and said they knew
about it but did not know how to fix it
(http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx)
well post here if you ever get a solution. Thanks and sorry I couldnt be more
helpful.
David
"Rick" wrote:
> I have a main report with 2 subreports as the only items
> in a list control. I am linking the 2 reports to a field
> in the dataset of the main report. When I view the
> report from the report manager or just from the report
> URL it looks fine. When I export to PDF the first page
> is blank. The 2nd page and all other pages are fine, but
> the data from the first page just isn't there. The data
> on the 2nd page is supposed to be the 2nd page so it's
> just the first page that is not showing up. Has anyone
> else seen this and have an idea of how to correct it?
>

Passing Text in parameter dropdown

I have a month drop down list.

In my dataset I have the code which generates month name for all months.

In my parameter list I want the functionality of the user able to select 'All' as Month name.

How can I achieve this in the query and parameter.

Code for month generation is as.

SELECT DISTINCTSUBSTRING(DATENAME(mm, T1.OPEN_TIME), 0,4) AS Month,
DATENAME(mm, T1.OPEN_TIME) AS MONTH_NAME_FULL,
DATEPART(mm, T1.OPEN_TIME) AS MONTH_NUM
FROM APPS237.Cats.dbo.Pd T1
Order By
DATEPART(mm, T1.OPEN_TIME)

Thanks,

Kiran.

You can use the UNION ALL clause to add the 'All' entry to the beginning of the table generated by your query. For example,

SELECT DISTINCT SUBSTRING(DATENAME(mm, T1.OPEN_TIME), 0,4) AS Month,
DATENAME(mm, T1.OPEN_TIME) AS MONTH_NAME_FULL,
DATEPART(mm, T1.OPEN_TIME) AS MONTH_NUM
FROM APPS237.Cats.dbo.Pd T1
UNION ALL
SELECT 'All', 'All', 0
Order By MONTH_NUM

Ian

Passing SQL statement to Dataset of report

Does anyone know how to pass a SQL statement to a dataset of a report? You used to be able to do this with Crystal and found it a really helpful tool.
Any help would be appreciatedAlthough there might be a way to do this you would be leaving a major
security hole open. You can pretty much do whatever you need to do but you
need to switch your thinking around to RS being the place that pulls the
information together to create the appropriate query. You can pass
parameters, you can have conditional code that changes the where clause, you
can have code behind that does things. Plus when you integrate you can send
a URL or use web services. There is a lot of flexibility and you can
probably do what you want but you might need to think about things
differently and utilize the features that RS provides.
Bruce L-C
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:B32D68AB-898C-4B82-86E3-C656091D5A2A@.microsoft.com...
> Does anyone know how to pass a SQL statement to a dataset of a report? You
used to be able to do this with Crystal and found it a really helpful tool.
> Any help would be appreciated
>

Passing row data!

Hi Team,

I am trying to build a report which compose of EmployeeName and his order assigned. First of all, I created a dataset which include all of the employee name, then I created another dataset which return all the count of the order by passing the employeeName as parameter. My question is how to pass the employee name which are generated from the first dataset and then pass to the second dataset?

Any help I will greatly appreciate.

You can refer to the value of the first parameter in the query parameter value expression of the second dataset. For example, =Parameters!<param1>.Value.