|
Try looking in BOL for replication - its a large subject
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I suggest you read BOL or get a book on SQL server management as this is not answerable in a forum post. Its the same as asking how do I set up SQL Server, answer, install it.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
In crystal report, you can select the printing direction in Layout tab between "Across then Down" and "Down then Across."
For Ex:
I have a dataset with 2 column:
id Name
1 Jim
2 Jess
3 John
4 Jane
5 Joey
I want the result to print like this:
id name id name
1 Jim 2 Jess
3 John 4 Jane
5 Joey
How can i do this in local RDLC report or is it even possible?
Please help/advice. I'm really stuck on this. Thanks in advance!!!!
|
|
|
|
|
What an odd request, I thought so last time you asked, obviously you got no answer. I will be surprised if you get one in the SQL forum for a CR issues. However heres what I have done when CR SSRS won't do as they are told.
Try getting the result in SQL server before passing it to CR. You may be able to position the data where you want it in a sroed proc and just stick the lot into a grid type control in CR.
I presume you have tried the CR forums and support - now theres sarcasm for you.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Umm... he's not really asking how to do this in CR, I think... 
|
|
|
|
|
He does mention CR in the OP and "local RDLC report", I have no idea what an RDCL report is and as he first asked this in the VB forum I got the idea it was a CR issue.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Let me clarify my question for you:
This option is possible to do in Crystal report where you can add another column and choose a direction to print your data (if you want the data to display across then down or down then across).
However, I did see option that you can increase the column number in SSRS when you create RDLC, but i didn't see anywhere that you can determine the printing direction and i'm just trying to find out if they have this option in SSRS (i'm trying to create a client report definition RDLC using VS2008 with C#). I thought maybe I'm looking for this option in a wrong place, since in crystal report this option seem to be out of sight too.
Also, the reason I ask this question again this forum because i thought that the reason i didn't get any response last time was maybe because i asked question in a wrong type of forum & since this is topic associate more with SSRS, I ask again in here.
|
|
|
|
|
Few choices come in mind:
- preorganize your data in "two columned set" before feeding it to rdlc
- add a two-column table to the rldc and in detail row create an expression for both columns. Rows in the data that have an odd row number go to the left column and rows with even row number go to the right (not sure that this is a good idea)
Hope this helps,
Mika
|
|
|
|
|
Thanks....that's a good option to do so.
Thanks!
|
|
|
|
|
You're welcome
|
|
|
|
|
So, do you need Visual Studio 05 installed on the same box as SQl 2005? I just installed SQL 05 on a db box and I see that there is an installation of VS05, but I think that is only used for SQL projects. I'm not going to do any programming on that box, so do I need VS05 installed there or can I get rid of it.
|
|
|
|
|
You don't need it but I do find it useful when you need to do a local compile to debug a problem.
|
|
|
|
|
No, it does not have to be all on the same box.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi,
I need help with selecting part of column value.
Say that I have a database that return me a InventoryID
InventoryID
as123-CE123daf235
23d45543-CE23432
234dave-CEj324lio
I want to select everything before -CE, i couldn't use Substring() function because each value have a different character id. can anyone advice me how to do this???
Thanks in advance!!!
|
|
|
|
|
SELECT LEFT(InventoryID, LEN(InventoryID) - CHARINDEX('CE',InventoryID))
|
|
|
|
|
Thank you....the substring function work without -2 at the end.
Thanks again!!!
|
|
|
|
|
<br />
select substring(InventoryID,1,CHARINDEX('CE',InventoryID)-2) from tablename
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
I have another small question regarding this:
select substring(inventoryId,1,Charindex('-CE',InventoryID)) from Inventory
work if all the inventoryID contain -CE, however there're some inventoryID that doesn't contain -CE and for those that doesn't contain -CE i want to select the whole field.
My SQL statement is really big, if i use If..Else statement then it's like
if InventoryID like '-CE' begin
.....the whole nine yard of select statement...
else
.....another nine yard of select statement....
i was wonder if you can use if within select statement...what i picture are:
SELECT *, (inventoryid without -CE for those that contain -CE)
FROM Inventory
I hope you understand my question.
Thanks!
|
|
|
|
|
InventoryID contain values like this:
23d45543CE23432
23d45543-CE23432
73d45543CE23434
73d45543-CE23434
... and so on
Try T-SQL down below I think it will work for you.
select <br />
case when CHARINDEX('-CE',inventoryid ) =0 then<br />
inventoryid <br />
else<br />
substring(inventoryid ,1,CHARINDEX('-CE',inventoryid )-1) <br />
end as inventoryID<br />
from Inventory
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Thank you so much...that's just want i needed...
Thanks!!!
|
|
|
|
|
No problem. You are welcome.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Does anyone happen to know why the column headers to do render in the
email? I have the bit set to '1' which should pass the column headers
in the attachment?
exec [msdb].[dbo].[sp_send_dbmail] @profile_name =
'dbmailden', @recipients = em...@email.com,
@subject = 'Weekly Tickets Reported in the Last 7 Days',
@query_result_width = '3250',
@query_no_truncate = '1',
@query_result_header = '1',
@query_result_separator = ' ',
@execute_query_database = 'webhelp2', @attach_query_result_as_file =
'1',
@query_attachment_filename = 'weeklyticketssummery.xls', @query = '
select count(*) as [Total Tickets Assigned]
, location_name [Cient], Priority_type_name [Priority],
SUM(CASE
WHEN DATEDIFF(DAY, Report_Date,
CURRENT_TIMESTAMP)
BETWEEN 2 AND 6
THEN 1
ELSE 0
END) AS over_2_days,
SUM(CASE
WHEN DATEDIFF(DAY, Report_Date,
CURRENT_TIMESTAMP)
BETWEEN 7 AND 14
THEN 1
ELSE 0
END) AS over_7_days,
SUM(CASE
WHEN DATEDIFF(DAY, Report_Date,
CURRENT_TIMESTAMP) >= 15
THEN 1
ELSE 0
END) AS over_15_days ,
SUM(CASE
WHEN DATEDIFF(DAY, Report_Date,
CURRENT_TIMESTAMP) >= 30
THEN 1
ELSE 0
END) AS over_30_days
from job_ticket j
inner join priority_type p on p.priority_type_id = j.priority_type_id
inner join tech t on t.client_id = j.assigned_tech_id
inner join location l on l.location_id = j.location_id
where status_type_id != 3
group by p.Priority_type_name, l.location_name'
Regards,
Hulicat
|
|
|
|
|
what does this mean "Integrity constraint violation" while trying to write data into oracle tables ?
Thanks,
Nice things do nice works
|
|
|
|
|
Well, at a guess... I would say the table you are tring to write to has constraints on it and the data you are inserting/updating violates those constraints.
See if you can get a copy of the database schema for the affected table(s) to determine how you are violating the constraint.
Tim
|
|
|
|
|
Can you post the Oracle error code ? Something like ORA-00001 ...
By having the error code, it would be easier to determine what is causing the problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
