PDF Report not reflecting changes after update

I've working on a report at a client and I'm having an issue with a report
not reflecting multiple updated. The basic procedure that is followed is:
1. The client adds an event to the timeline.
2. The client runs the timeline report and the new event shows up.
3. The client adds a new event to the timeline.
4. The second, and any subsequent events do not show up.
I've checked the stored procedure that the report calls and it returns the
correct data every time (reflects the events as added). I've also checked
the execution properties in the report to be sure that the report isn't set
to be cached, and it's not. I'm using SQL Server 2000 & Reporting Services,
and I'm using Visual Studio 2003 SP1.
Any help would be really appreciated.It took me awhile to find the answer when I had the same problem.
Use;
rs:ClearSession=true in the url assuming you are using the url method.
directs the report server to remove a report from session. All report
instances associated with an authenticated user are removed from
session. (A report instance is defined as the same report run multiple
times with different report parameter values.)
Neil
John Swaringen wrote:
> I've working on a report at a client and I'm having an issue with a report
> not reflecting multiple updated. The basic procedure that is followed is:
> 1. The client adds an event to the timeline.
> 2. The client runs the timeline report and the new event shows up.
> 3. The client adds a new event to the timeline.
> 4. The second, and any subsequent events do not show up.
> I've checked the stored procedure that the report calls and it returns the
> correct data every time (reflects the events as added). I've also checked
> the execution properties in the report to be sure that the report isn't set
> to be cached, and it's not. I'm using SQL Server 2000 & Reporting Services,
> and I'm using Visual Studio 2003 SP1.
> Any help would be really appreciated.|||Neil,
That worked great. It took me a while to figure out that I had to add it
via the ReportViewer.SetParameter() function. But once I did that everything
is cooking!
Thanks for the help!
"neilgould@.gmail.com" wrote:
> It took me awhile to find the answer when I had the same problem.
> Use;
> rs:ClearSession=true in the url assuming you are using the url method.
> directs the report server to remove a report from session. All report
> instances associated with an authenticated user are removed from
> session. (A report instance is defined as the same report run multiple
> times with different report parameter values.)
> Neil
>
> John Swaringen wrote:
> > I've working on a report at a client and I'm having an issue with a report
> > not reflecting multiple updated. The basic procedure that is followed is:
> >
> > 1. The client adds an event to the timeline.
> > 2. The client runs the timeline report and the new event shows up.
> > 3. The client adds a new event to the timeline.
> > 4. The second, and any subsequent events do not show up.
> >
> > I've checked the stored procedure that the report calls and it returns the
> > correct data every time (reflects the events as added). I've also checked
> > the execution properties in the report to be sure that the report isn't set
> > to be cached, and it's not. I'm using SQL Server 2000 & Reporting Services,
> > and I'm using Visual Studio 2003 SP1.
> >
> > Any help would be really appreciated.
>

PDF output problem for checkbox like "Ticks" displayed in reports

Hi All,
we created a report that should render some "checked items" (like the ticks
in a checkbox) to indicate the given answers for multiple chooice questions
from a questionaire.
Displaying the tick is done by using a unicode character from the font "MS
Mincho". When we render the report in report viewer, all seems to be fine,
but when rendered to a pdf it goes wrong; the "tick" is replaced with a
question mark.
We can't find any specific unicode/pdf related settings for RS. Any clues.
Many thanks in advance,
TimHi tvds,
I have exactly the same problem, did you find any solution?
Thanks,
Markus
"tvds" wrote:
> Hi All,
> we created a report that should render some "checked items" (like the ticks
> in a checkbox) to indicate the given answers for multiple chooice questions
> from a questionaire.
> Displaying the tick is done by using a unicode character from the font "MS
> Mincho". When we render the report in report viewer, all seems to be fine,
> but when rendered to a pdf it goes wrong; the "tick" is replaced with a
> question mark.
> We can't find any specific unicode/pdf related settings for RS. Any clues.
> Many thanks in advance,
> Tim
>sql

PDF file

Can SSRS write reports in PDF files? What about multiple reports in a single PDF file? Thanks.Yes - PDF is an output type. You can create multiple reports and join them in one 'master' report as subreport objects to return them all in one file.|||Please kindly provide related tutorial links. Thanks.

PDF Document Map Hierarchy

I've notice a couple other posts about this issue, but could not seem
to find any responses/resolutions.
I have a table with multiple groups. In HTML the document map
hierarchy looks fine. In PDF there is no hierarchy.
Thanks for any help with this.
Example - HTML:
- Sex
- Male
- Age
- 35
- 40
- 45
- Female
- Age
- 35
- 40
- 45
Example - PDF:
Sex
Male
Age
35
40
45
Female
Age
35
40
45Hi Bob,
how did you get the hierarchy in HTML and preview? I have no hierarchy at
all.
thanks
Matt
"BobA" <robert.ames@.mercer.com> wrote in message
news:b7b93183.0410051203.4d37c984@.posting.google.com...
> I've notice a couple other posts about this issue, but could not seem
> to find any responses/resolutions.
> I have a table with multiple groups. In HTML the document map
> hierarchy looks fine. In PDF there is no hierarchy.
> Thanks for any help with this.
> Example - HTML:
> - Sex
> - Male
> - Age
> - 35
> - 40
> - 45
> - Female
> - Age
> - 35
> - 40
> - 45
> Example - PDF:
> Sex
> Male
> Age
> 35
> 40
> 45
> Female
> Age
> 35
> 40
> 45|||Thanks, I figured it out. I needed to set the document map against the
group not the element in the table.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> Hi Bob,
> how did you get the hierarchy in HTML and preview? I have no hierarchy at
> all.
> thanks
> Matt
>
> "BobA" <robert.ames@.mercer.com> wrote in message
> news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > I've notice a couple other posts about this issue, but could not seem
> > to find any responses/resolutions.
> >
> > I have a table with multiple groups. In HTML the document map
> > hierarchy looks fine. In PDF there is no hierarchy.
> >
> > Thanks for any help with this.
> >
> > Example - HTML:
> >
> > - Sex
> > - Male
> > - Age
> > - 35
> > - 40
> > - 45
> > - Female
> > - Age
> > - 35
> > - 40
> > - 45
> >
> > Example - PDF:
> >
> > Sex
> > Male
> > Age
> > 35
> > 40
> > 45
> > Female
> > Age
> > 35
> > 40
> > 45
>|||This is still an issue. Are there any ideas on how to fix this
problem?
Matt wrote:
> Thanks, I figured it out. I needed to set the document map against
the
> group not the element in the table.
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > Hi Bob,
> >
> > how did you get the hierarchy in HTML and preview? I have no
hierarchy at
> > all.
> >
> > thanks
> >
> > Matt
> >
> >
> > "BobA" <robert.ames@.mercer.com> wrote in message
> > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > I've notice a couple other posts about this issue, but could not
seem
> > > to find any responses/resolutions.
> > >
> > > I have a table with multiple groups. In HTML the document map
> > > hierarchy looks fine. In PDF there is no hierarchy.
> > >
> > > Thanks for any help with this.
> > >
> > > Example - HTML:
> > >
> > > - Sex
> > > - Male
> > > - Age
> > > - 35
> > > - 40
> > > - 45
> > > - Female
> > > - Age
> > > - 35
> > > - 40
> > > - 45
> > >
> > > Example - PDF:
> > >
> > > Sex
> > > Male
> > > Age
> > > 35
> > > 40
> > > 45
> > > Female
> > > Age
> > > 35
> > > 40
> > > 45
> >
> >|||Hi Bob,
I am facing the same dilema. The Document map hierarchy appears flat when
you export to PDF. Very annoying!!!
Thanks,
Terry
"BobA" wrote:
> This is still an issue. Are there any ideas on how to fix this
> problem?
> Matt wrote:
> > Thanks, I figured it out. I needed to set the document map against
> the
> > group not the element in the table.
> >
> > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > > Hi Bob,
> > >
> > > how did you get the hierarchy in HTML and preview? I have no
> hierarchy at
> > > all.
> > >
> > > thanks
> > >
> > > Matt
> > >
> > >
> > > "BobA" <robert.ames@.mercer.com> wrote in message
> > > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > > I've notice a couple other posts about this issue, but could not
> seem
> > > > to find any responses/resolutions.
> > > >
> > > > I have a table with multiple groups. In HTML the document map
> > > > hierarchy looks fine. In PDF there is no hierarchy.
> > > >
> > > > Thanks for any help with this.
> > > >
> > > > Example - HTML:
> > > >
> > > > - Sex
> > > > - Male
> > > > - Age
> > > > - 35
> > > > - 40
> > > > - 45
> > > > - Female
> > > > - Age
> > > > - 35
> > > > - 40
> > > > - 45
> > > >
> > > > Example - PDF:
> > > >
> > > > Sex
> > > > Male
> > > > Age
> > > > 35
> > > > 40
> > > > 45
> > > > Female
> > > > Age
> > > > 35
> > > > 40
> > > > 45
> > >
> > >
>|||Hi,
I have the same issue also. Did anyone ever find a solution to it?
Thanks,
Melissa
"Terry" wrote:
> Hi Bob,
> I am facing the same dilema. The Document map hierarchy appears flat when
> you export to PDF. Very annoying!!!
> Thanks,
> Terry
> "BobA" wrote:
> > This is still an issue. Are there any ideas on how to fix this
> > problem?
> >
> > Matt wrote:
> > > Thanks, I figured it out. I needed to set the document map against
> > the
> > > group not the element in the table.
> > >
> > > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > > news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > > > Hi Bob,
> > > >
> > > > how did you get the hierarchy in HTML and preview? I have no
> > hierarchy at
> > > > all.
> > > >
> > > > thanks
> > > >
> > > > Matt
> > > >
> > > >
> > > > "BobA" <robert.ames@.mercer.com> wrote in message
> > > > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > > > I've notice a couple other posts about this issue, but could not
> > seem
> > > > > to find any responses/resolutions.
> > > > >
> > > > > I have a table with multiple groups. In HTML the document map
> > > > > hierarchy looks fine. In PDF there is no hierarchy.
> > > > >
> > > > > Thanks for any help with this.
> > > > >
> > > > > Example - HTML:
> > > > >
> > > > > - Sex
> > > > > - Male
> > > > > - Age
> > > > > - 35
> > > > > - 40
> > > > > - 45
> > > > > - Female
> > > > > - Age
> > > > > - 35
> > > > > - 40
> > > > > - 45
> > > > >
> > > > > Example - PDF:
> > > > >
> > > > > Sex
> > > > > Male
> > > > > Age
> > > > > 35
> > > > > 40
> > > > > 45
> > > > > Female
> > > > > Age
> > > > > 35
> > > > > 40
> > > > > 45
> > > >
> > > >
> >
> >

Pattern matching with multiple values

I want to check for multiple patterns in a particular column.
For one pattern I can write e.g.
SELECT * FROM <TablName> WHERE ColumnName LIKE '%abcd%'.

My requirment is to select all rows for which column value matches with many patterns.I will fetch the patterns in a subquery
e.g. (SELECT '%'+name+'%' FROM <TableName>)

Any thoughts?

Hi
It might work if you move your like into Exists , like

SELECT * FROM <TableName> T1
WHERE EXISTS (SELECT * FROM T2
WHERE T1.column LIKE '%' + T2.NAME + '%'
)

NB.|||

Thanks for your solution !

|||

Thanks for your solution !

However my problem won't get solved this way. Actually I am building anSSRS report and the subquery was meant to be the 'Available Values ' of a multi-valued Input parameter.
When the user selects one or more params SRS will form a string of the values like " 'val1','val2','val3'...."
In my case SRS is forming a WHERE clause like
.........
.........
WHERE colname in ('val1','val2','val3'). This would search for the exact string, whereas I would like it to only match with patterns like '%val1%','%val2%','%val3%'.

|||

i think you need to build it as

WHERE colname like '%val1%' or colname like '%val2%' or colname like '%val3%'.

|||

Thnx. Shallu.....That is correct syntax, but you need to see that the number of values is not static and all of them are stored as one parameter by ssrs.

To simplify it for you, say SSRS is providing me with a string series like " '%val2%', '%val2%' ,'%val2%' ...". Now I need to use this to do my comparison.

|||Hi

There might be a better solution from SSRS comunity , you should try your question there as well. From T_SQL point of view you could try following solution:
Create 2 store procedures : one - master that recived your string of parameters , parses a string into a list of single parameters and collects whatever children return , the other one - child , that can process one parameter at a time

CREATE PROCEDURE MultipleParameterSearch_procedure
@.intString varchar ()

as
CREATE TABLE #reultset (<your columns>)

DECLARE @.PARAMETER
-- parse your string into separate parameters , one at a time
...
...

WHILE @.PARAMETER is not nul
BEGIN
-- accumulate your single parameter procedure results
INSERT INTO #reultset (<your columns>)
EXEC SingleParameterSeach_Procedure @.PARAMETER
-- get next parameter
END

SELECT * FROM #reultset
RETURN
GO

CREATE PROCEDURE SingleParameterSeach_Procedure @.Parameter VARCHAR()
AS
SELECT <your columns>FROM <Table> WHERE Column LIKE '%' + @.Parameter + '%'
RETURN
GO|||Hi
Just one last suggestion.
LIKE %val%' is a very expensive operation, as no indexes can be used to help QueryOptimiser to make a quick search. Adding multiple LIKE parameters are going to decrease performance of your query. If you are doing your Report for production , explain to the user implications and pesweid them to use a single-parameter select .

:-).NB|||Thanks for taking the pains .I'll follow this up |||

Please take a look at the link below:

http://www.sommarskog.se/arrays-in-sql.html

It discusses various techniques to process lists using SQL. You can use one of those methods to generate a table that contains the individual values and then use it as source in the EXISTS sub-query.

Passing SQL Clauses as Parameters to a Stored Procedure

Hi,

I have a complex SQL query against multiple tables that ideally would be best used as a stored procedure.

I know of and have read about creating named parameters and setting the parameters' values in ASP just before issuing an execute command via the Command object. What I'd like to do is assign the text of the filter and sort clauses to the parameters. Not the values, but the entire string, such as

"WHERE lastname LIKE 'A%' "

"ORDER BY lastname "

I need to assign the entire clause because the query may or may not use a particular clause.

I have experimented. However SQL treats the parameter as a literal string rather than part of the SQL query itself. Is there another technique that I may use to accomplish my goal?

Thanks in advance for your opinion, suggestion, criticism, etc.

--Tom.Dynamic SQL|||and look up SQL Injection

DECLARE @.SQL varchar(8000)

SELECT @.SQL = 'SELECT * FROM INFORMATION_SCHEMA'
EXEC(@.SQL)

You should use dynamic as a last reort...

What prob you trying to solve?